How to not display negative values

[quickheart]

I have a cell that is populated by subtracting one cell from another elsewhere.

I want to never display a negative value so, if the product is '-10', I want to display '0' instead of the negative value. As long as the product is a positive number I want to display it.


Thanks,

[Jonmo1]

Try

=MAX(0,A1-B1)

[quickheart]

Grrr! I knew that! Brain fade!


Thanks Jonmo1

[Jonmo1]

You're welcome.