A AkitaMom Jun 12, 2008 #1 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
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
D Dave Peterson Jun 12, 2008 #3 =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 Click to expand...
=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 Click to expand...
A AkitaMom Jun 12, 2008 #5 Thank you I was putting in too many ( and not enough , Thanks for the help