Eliminate Negatives
 

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.

Eliminate Negatives
 

=MAX(0,B2-B3)

"MCheru" wrote in message
...
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.

Eliminate Negatives
 

Thank you. This is good!

"Bob Umlas" wrote:

=MAX(0,B2-B3)

"MCheru" wrote in message
...
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.

Eliminate Negatives
 

Hi,

You can also try the follwing:

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"MCheru" wrote in message
...
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.