Formula which is greater tahn or equal to zero

[Guest]

I am trying to create a formula which when calculated, if the result is equal
to or less than zero, the result would be zero, otherwise calculation would
give proper answer.

Example: Formula for i2
=j2-h2

If answer was equal to or less than zero, result would equal zero (not a
negative) otherwise calculate j2-h2

 

[Rowan]

Hi Bruce

Try =IF(J2-H2>0,J2-H2,0)

Regards
Rowan

 

[Robert_Steel]

For personal preference

=MAX(J2-H2,0)

hth RES