Hi Bruce
Try =IF(J2-H20,J2-H2,0)
Regards
Rowan
bruce2444 wrote:
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
|