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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding Negative Numbers to Zero 4
Red cell for negative numbers in Excel 1
How to count the maximum number flanked by zeros 9
Negative numbers 4
Excell - two conditions count if factors are true when negative nu 2
Negative result gives #### is there a way to show the actual - num 11
Help making Negative numbers to become zero 14
Smaller than 0 to return a 0 result 1

Back
Top