how do I reflect a (-) outcome as 0

O

Otto Moehrbach

Put this formula in any cell other than A1 and you will get a "0" if A1 is
less than zero (negative).
IF(A1<0,"0","Whatever")
If you want a given cell to change to "0" whenever its value goes negative,
you will need a macro. Post back if you need more. HTH Otto
 
D

David Billigmeier

Mike,
Or do you want the the value to be displayed as 0 in the actual cell (i.e.
no helper cell needed). If so this can be achieved with custom formats:

<Format>
<Cells>
Click on "Custom"
Enter this: General;"0"

This will display all positive values as their actual value as usual, but
display any negative values as simply 0. Note the negative value is still
located in the cell, it just "Looks" like it's 0.
 
D

Dave

Hi Mike,
If the cell in question is a calculated cell, ie, it gets its value from a
formula, then just add an IF statement.
eg
IF(YourFormula<0,0,YourFormula)
 

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

Top