Configure formula to show negative number result as zero.

[Rick93636]

Using simple multiply and divide formulas. In some cases the resulting product is a negative number. In those cases I want to display "0" instead of the negative value.

For instance: If 3 * 5 = 15 then I want to display 15.
But if -3 * 5 = -15 then I want to display 0.

Any ideas?

Thanks,

Rick

 

[Weazel]

maybe...

=MAX(0,A1*B1)

 

[royUK]

Hi Rick

=IF(3*-5<0,0,3*-5<0)

Are you actually multiplying the contents of two cells?

=IF(A1*B1<0,0,A1*B1)

 

[Rick93636]

That's it! Thanks Roy

 

[Rick93636]

That also works! Thanks Weazel.