| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
