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.