excel formula

AkitaMom · Jun 12, 2008

want to add a1+b2, if that is less than zero, I want c2 to read 0, if it is
more than zero I want what 1a+b2 equals to show

Gary''s Student · Jun 12, 2008

=IF(A1+B2<0,0,A1+B2)

Dave Peterson · Jun 12, 2008

=max(0,a1+b2)

or

=if(a1+b2<0,0,a1+b2)

want to add a1+b2, if that is less than zero, I want c2 to read 0, if it is
more than zero I want what 1a+b2 equals to show

JBoyer · Jun 12, 2008

Type the following in C2:
=IF((A1+B2)<0,0,A1+B2)

AkitaMom · Jun 12, 2008

Thank you

I was putting in too many ( and not enough ,
Thanks for the help