Hiding Negative Numbers

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I know how to format a cell under the number tab and
customize it, but is there a way to either hide the number
if the formula returns a negative number, or possibly have
the negative number expressed as a 0?
Thank you.
 
Jay

Cost Sales Profit
50.2 55.23 5.03

in c2 the formula is =IF(B2-A2<0,"",B2-A2) this hides the
result.
Or =IF(B2-A2<0,0,B2-A2) displays a zero

Regards
Peter
 
Back
Top