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