How to make negative numbers to become 0?
 

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.

How to make negative numbers to become 0?
 

=MAX(0,your_formula)

--
HTH

Bob Phillips

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

wrote in message
oups.com...
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.