How to make negative numbers to become 0?

  • Thread starter Thread starter qazmlp1209
  • Start date Start date
Q

qazmlp1209

When the formula calculates, the value in the cell can be <0, 0, >0.

How can we make it such that
- only 0, >0 values are shown as it is, but
- <0 i.e. the negative numbers, should be ignored and shown as 0?

I know a method, where we can have an IF statement in the formula. I
would like to know whether there are any other way of doing it.
 
=MAX(0,your_formula)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top