| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another Extremely complex IF statement
How would this be written as a formula?
If I53 X 363 is less than D53, then D53 X .2617 is the value, except, when D53 X .2617 is less than C10 than the value should be C10. Otherwise, the value should be D53 X .2617. However, if I53 X 363 is greater than D53, then I53 X D10 is the value, except, when I53 X D10 is less than C10, then the value should be C10. Otherwise, the value should be I53 X D10 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extremely complex IF statements | Excel Worksheet Functions | |||
| complex IF(OR(...AND())) statement | Excel Discussion (Misc queries) | |||
| Help with complex average/if statement | Excel Worksheet Functions | |||
| rather complex logic statement | Excel Worksheet Functions | |||
| Fairly Complex IF Statement | Excel Worksheet Functions | |||
Threaded Mode
