can I get cells with a minus number to show zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell which has a basic formula in (adding up from 2 other cells)
This number can end up being a minus number (-167), If this happens I need to
be able to make that minus number appear as a zero (0). Is this possible?
please help.
 
If you want to retain the underlying value, but just show the 0 value, use a
format like General;\0
 
Re-write your formulas by wrapping them in an IF statement that requires the
result to be greater than or equal to zero, like.....

=IF(YourFormula<0,0,YourFormula)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top