software

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!

Hi,

=IF(A1 B1lt;4,4,A1 B1)

Regards,
BondiTry this:

C1: =MAX(A1 B1,4)

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

Does that help?

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

XL2002, WinXP-Proquot;marilquot; wrote:

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

=MAX(4,a1 b1)

--
Kind regards,

Niek Otten

quot;marilquot; gt; 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!
=IF(A1 B1lt;=4,4,A1 B1)

Or simply:

=MAX(4,A1 B1)

HTH
--
AP

quot;marilquot; gt; a écrit dans le message de
...
gt; As you can tell with the subject line, I am having problems with a SIMPLE
gt; formula that I cannot get right. What I need is:
gt;
gt; if a1 b1 is less than 4 then c1 shows 4, but if a1 b1 is greater than 4
then
gt; c1 shows the sum of a1 b1.
gt;
gt; Can any one help me? many, many thanks!
WOW! THANKS FOR MAKING MY LIFE EASIER!

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; C1: =MAX(A1 B1,4)
gt;
gt; That formula returns the greater of (A1 B1) or 4.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;marilquot; wrote:
gt;
gt; gt; As you can tell with the subject line, I am having problems with a SIMPLE
gt; gt; formula that I cannot get right. What I need is:
gt; gt;
gt; gt; if a1 b1 is less than 4 then c1 shows 4, but if a1 b1 is greater than 4 then
gt; gt; c1 shows the sum of a1 b1.
gt; gt;
gt; gt; Can any one help me? many, many thanks!