Eliminate Negatives

[MCheru]

This formula (= B2 – B3) is in cell B5. I want to modify (= B2 – B3) so that
if the answer is a negative number a “0†will appear in cell B5 instead of a
negative number.

 

[Bob Umlas]

=MAX(0,B2-B3)

 

[MCheru]

Thank you. This is good!

=MAX(0,B2-B3)

 

[Ashish Mathur]

Hi,

You can also try the follwing:

=if(B2-B3<0,0,B2-B3)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com