View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
maril
 
Posts: n/a
Default 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!