| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement with 3 parameters
D22 = 508 kg
B19 = $35.00 (minimum) C19 = $.25 D19 = $275.00 (maximum) Problem: if D22*C19< then B19 if D22*C19 greater than B19, but less than D19, D22*C19 if D22*C19D19 then D19 How do I construct the nested IF statement? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement with 3 parameters
Your first parameter is not clear. If D22*C19 < ???
Generally, these formulas have the form =IF(A1<A2,A3,IF(A4<A5,A6,IF(A7<A8,A9,""))) etc. IF...THEN...ELSE IF...THEN...ELSE IF...THEN...ELSE Dave -- Brevity is the soul of wit. "Teri" wrote: D22 = 508 kg B19 = $35.00 (minimum) C19 = $.25 D19 = $275.00 (maximum) Problem: if D22*C19< then B19 if D22*C19 greater than B19, but less than D19, D22*C19 if D22*C19D19 then D19 How do I construct the nested IF statement? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement with 3 parameters
Thanks for catching that!! Should be <B19
"Dave F" wrote: Your first parameter is not clear. If D22*C19 < ??? Generally, these formulas have the form =IF(A1<A2,A3,IF(A4<A5,A6,IF(A7<A8,A9,""))) etc. IF...THEN...ELSE IF...THEN...ELSE IF...THEN...ELSE Dave -- Brevity is the soul of wit. "Teri" wrote: D22 = 508 kg B19 = $35.00 (minimum) C19 = $.25 D19 = $275.00 (maximum) Problem: if D22*C19< then B19 if D22*C19 greater than B19, but less than D19, D22*C19 if D22*C19D19 then D19 How do I construct the nested IF statement? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement with 3 parameters
Teri a écrit :
D22 = 508 kg B19 = $35.00 (minimum) C19 = $.25 D19 = $275.00 (maximum) Problem: if D22*C19< then B19 if D22*C19 greater than B19, but less than D19, D22*C19 if D22*C19D19 then D19 How do I construct the nested IF statement? Hi Teri, Can also be =min(D19,max(B19,(D22*C19))) Regards FxM |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement with 3 parameters
Perfect! Thank you!!
"FxM" wrote: Teri a écrit : D22 = 508 kg B19 = $35.00 (minimum) C19 = $.25 D19 = $275.00 (maximum) Problem: if D22*C19< then B19 if D22*C19 greater than B19, but less than D19, D22*C19 if D22*C19D19 then D19 How do I construct the nested IF statement? Hi Teri, Can also be =min(D19,max(B19,(D22*C19))) Regards FxM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question using dates in a statement | Excel Discussion (Misc queries) | |||
| IF Statement W/3 Parameters ? | Excel Worksheet Functions | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| Parameters are not allowed in queries that can't be displayed grap | Excel Discussion (Misc queries) | |||
Hybrid Mode
