a+b<4 then 4,a+b<4 then sum a+b

M

maril

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!
 
R

Ron Coderre

Try this:

C1: =MAX(A1+B1,4)

That formula returns the greater of (A1+B1) or 4.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
N

Niek Otten

=MAX(4,a1+b1)

--
Kind regards,

Niek Otten

| 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!
 
M

maril

WOW! THANKS FOR MAKING MY LIFE EASIER!

Ron Coderre said:
Try this:

C1: =MAX(A1+B1,4)

That formula returns the greater of (A1+B1) or 4.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
Click to expand...
 
Top