| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
complex IF statement
Hello.
In cell $E$70 I have a data validation drop down list which allows the user to select a percentage between 0% and 10%. I am trying to get cell $D$70 to read "Product Subtotal at 1% discount" when cell $E$70 is 1%, "Product Subtotal at 2% discount" when cell $E$70 is 2%" etc. I tried using an IF statement, however as you know, it caps out at 7 IF arguments. I need 10 arguments and then just "Product Subtotal" when 0% is selected. Does anyone know how to get around the 7 argument problem? Thanks in advance -- Cathy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex IF Statement | Excel Discussion (Misc queries) | |||
| Complex IF THEN statement | Excel Worksheet Functions | |||
| Complex If/And Statement | Excel Worksheet Functions | |||
| Help with complex If statement | Excel Worksheet Functions | |||
| complex IF(OR(...AND())) statement | Excel Discussion (Misc queries) | |||
Threaded Mode
