Excel - negative result equals to zero

December 2016




Issue


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.

Solution


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

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

Note


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.