can I get cells with a minus number to show zero

[marcus1066]

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.

 

[Gord Dibben]

=IF(A1+B1<0,0,A1+B1)

Alternative

=MAX(0,A1+B1)


Gord Dibben Excel MVP

 

[Bob Phillips]

If you want to retain the underlying value, but just show the 0 value, use a
format like General;\0

 

[CLR]

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