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(A1+B1<0,0,A1+B1)

Alternative

=MAX(0,A1+B1)


Gord Dibben Excel MVP


On Sat, 7 May 2005 08:28:03 -0700, "marcus1066"
wrote:

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

--
HTH

Bob Phillips

"marcus1066" wrote in message
...
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.

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


"marcus1066" wrote in message
...
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.