Excel - negative result equals to zero

October 2016


My problem is relatively simple,
I wish that when the result of subtraction is negative (eg 0-2 =- 2), it appears to be zero?
Thank you for your help.


Look at this formula that references cell A1 and B1 = 0 = 2

= IF(A1-B1<0;0;A1-B1)


Thanks to mike-31 for this tip.

Related :

This document entitled « Excel - negative result equals to zero » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.