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

I'm trying to use the IF function to do the following: IF(C16+C17)*.31600,
(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?

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

Hi
Maybe something like this =IF(C16+C17*130%1600,C16+C17*130%,1600)
HTH
John
"dschneider3" wrote in message
...
I'm trying to use the IF function to do the following: IF(C16+C17)*.31600,
(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?

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

=IF((SUM(C16:C17)*30%)1600,SUM(C16:C17)*30%,1600)
Click yes if helped
--
Greatly appreciated
Eva


"dschneider3" wrote:

I'm trying to use the IF function to do the following: IF(C16+C17)*.31600,
(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?

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

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

--
If this helps, please remember to click yes.


"dschneider3" wrote:

I'm trying to use the IF function to do the following: IF(C16+C17)*.31600,
(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?

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

Try this:

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



"dschneider3" wrote:

I'm trying to use the IF function to do the following: IF(C16+C17)*.31600,
(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?

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

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

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


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

"dschneider3" wrote:
I'm trying to use the IF function to do the following: IF(C16+C17)*.31600,
(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?

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

OOOP
Correction =IF(C16+C17*1.61600,C16+C17*1.6,1600)
HTH
John
"John" wrote in message
...
Hi
Maybe something like this =IF(C16+C17*130%1600,C16+C17*130%,1600)
HTH
John
"dschneider3" wrote in message
...
I'm trying to use the IF function to do the following: IF(C16+C17)*.31600,
(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?

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

Try

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

HTH

Bob


"dschneider3" wrote in message
...
I'm trying to use the IF function to do the following:
IF(C16+C17)*.31600,
(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?

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

It's time for me to quit .
This should be it =IF((C16+C17*1.31600),(C16+C17)*1.3,1600)
John
"John" wrote in message
...
Hi
Maybe something like this =IF(C16+C17*130%1600,C16+C17*130%,1600)
HTH
John
"dschneider3" wrote in message
...
I'm trying to use the IF function to do the following: IF(C16+C17)*.31600,
(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?

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

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

Should it be MAX?


"Joe User" wrote:


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

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


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

"dschneider3" wrote:
I'm trying to use the IF function to do the following: IF(C16+C17)*.31600,
(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?

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

"Teethless mama" wrote:
=MIN(1600, (C16+C17)*30%)

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

"Teethless mama" wrote in message
...
=MIN(1600, (C16+C17)*30%)

Should it be MAX?


"Joe User" wrote:


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

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


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

"dschneider3" wrote:
I'm trying to use the IF function to do the following:
IF(C16+C17)*.31600,
(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?