Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
greater les than formula | Excel Discussion (Misc queries) | |||
Formula greater than | Excel Worksheet Functions | |||
Formula Greater than Less Than | Excel Discussion (Misc queries) | |||
Greater Than formula | Excel Worksheet Functions | |||
Greater than formula! | Excel Worksheet Functions |