how do I reflect a (-) outcome as 0

  • Thread starter Thread starter mike
  • Start date Start date
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
 
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.
 
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)
 
Back
Top