=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.