IF formula is greater than X use it, if not use X

[dschneider3]

I'm trying to use the IF function to do the following: IF(C16+C17)*.3>1600,
(C16+C17)*.3, 1600.

In English: If the sum of this range times 30% is greater than 1600 then
display the sum of this range times 30%, else display 1600.

I can't get this to work? Can anyone help me?

 

[John]

Hi
Maybe something like this =IF(C16+C17*130%>1600,C16+C17*130%,1600)
HTH
John

 

[Eva]

=IF((SUM(C16:C17)*30%)>1600,SUM(C16:C17)*30%,1600)
Click yes if helped

 

[Paul C]

You seem to be missing a set of ()
your formula should be
=IF((C16+C17)*.3>1600, (C16+C17)*.3, 1600)

 

[Iriemon]

Try this:

=IF((C16+C17)*.3>1600,(C16+C17)*.3,1600)

 

[Joe User]

I'm trying to use the IF function to do the following:
IF(C16+C17)*.3>1600, (C16+C17)*.3, 1600.

=MIN(1600, (C16+C17)*30%)


----- original message -----

 

[John]

OOOP
Correction =IF(C16+C17*1.6>1600,C16+C17*1.6,1600)
HTH
John

 

[Bob Phillips]

Try

=MAX((C16+C17)*.3, 1600)

HTH

Bob

 

[John]

It's time for me to quit .
This should be it =IF((C16+C17*1.3>1600),(C16+C17)*1.3,1600)
John

 

[Teethless mama]

=MIN(1600, (C16+C17)*30%)

Should it be MAX?

=MIN(1600, (C16+C17)*30%)


----- original message -----

 

[Joe User]

Should it be MAX?

ABS'ly. I mix up left and right, too. I even had written MAX initially,
but changed it to MIN at the last minute, ass-u-me-ing I had made the same
mistake and mis-rereading the OP's posting. D'oh!


----- original message -----