View Single Post
  #2   Report Post  
Rowan
 
Posts: n/a
Default

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