a+b<4 then 4,a+b<4 then sum a+b
As you can tell with the subject line, I am having problems with a SIMPLE
formula that I cannot get right. What I need is:
if a1+b1 is less than 4 then c1 shows 4, but if a1+b1 is greater than 4 then
c1 shows the sum of a1+b1.
Can any one help me? many, many thanks!
|