| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Another Extremely complex IF statement
Try this:
=IF(I53*363<D53,MAX(D53*0.2617,C10),MAX(I53*D10,C1 0)) Does that help? *********** Regards, Ron XL2002, WinXP "Teri" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Another Extremely complex IF statement
Ron, I'm going to run this by my boss, but I've been so confounded by this
problem! Thank you for helping me !! Teri "Ron Coderre" wrote: Try this: =IF(I53*363<D53,MAX(D53*0.2617,C10),MAX(I53*D10,C1 0)) Does that help? *********** Regards, Ron XL2002, WinXP "Teri" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
