can I get cells with a minus number to show zero

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"
<marcus1066@discussions.microsoft.com> 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.

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" <marcus1066@discussions.microsoft.com> wrote in message
news:B519F61E-B641-4936-8746-7F535AE314DD@microsoft.com...
> 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" <marcus1066@discussions.microsoft.com> wrote in message
news:B519F61E-B641-4936-8746-7F535AE314DD@microsoft.com...
> 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.