Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yet another extremely complex IF statement
How can this be written as a formula?
If I53 X 363 is less than D53, then D53 X .0688 is the value, except, when D53 X .0688 is less than B24 then the value should be B24. Otherwise, the value should be D53 X .0688. However, if I53 X 363 is greater than D53, then I53 X D24 is the value, except, when I53 X D24 is less than B24, then the value should be B24. Otherwise, the value should be I53 X D24. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yet another extremely complex IF statement
Try this:
=IF(I53*363<D53,MAX(D53*0.0688,B24),MAX(I53*D24,B2 4)) Does that help? *********** Regards, Ron XL2002, WinXP "Teri" wrote: How can this be written as a formula? If I53 X 363 is less than D53, then D53 X .0688 is the value, except, when D53 X .0688 is less than B24 then the value should be B24. Otherwise, the value should be D53 X .0688. However, if I53 X 363 is greater than D53, then I53 X D24 is the value, except, when I53 X D24 is less than B24, then the value should be B24. Otherwise, the value should be I53 X D24. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Extremely complex IF statement | Excel Worksheet Functions | |||
Extremely complex IF statements | Excel Worksheet Functions | |||
complex IF(OR(...AND())) statement | Excel Discussion (Misc queries) | |||
Extremely complex problem: showing a value as an 'axis' on a circle | Excel Discussion (Misc queries) | |||
Fairly Complex IF Statement | Excel Worksheet Functions |