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!

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

Hi,

=IF(A1+B1<4,4,A1+B1)

Regards,
Bondi

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

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


"maril" wrote:

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!

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

=MAX(4,a1+b1)

--
Kind regards,

Niek Otten

"maril" wrote in message ...
| 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!

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

=IF(A1+B1<=4,4,A1+B1)

Or simply:

=MAX(4,A1+B1)

HTH
--
AP

"maril" a écrit dans le message de
...
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!

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

WOW! THANKS FOR MAKING MY LIFE EASIER!

"Ron Coderre" wrote:

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


"maril" wrote:

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!