excel formula
 

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

excel formula
 

=IF(A1+B2<0,0,A1+B2)
--
Gary''s Student - gsnu200791

excel formula
 

=max(0,a1+b2)

or

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



AkitaMom wrote:

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

--

Dave Peterson

excel formula
 

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

"AkitaMom" wrote:

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

excel formula
 

Thank you :) I was putting in too many ( and not enough ,
Thanks for the help

"Gary''s Student" wrote:

=IF(A1+B2<0,0,A1+B2)
--
Gary''s Student - gsnu200791