| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Too Many Nested IF Statements!
Hi.
I have created the following formula which Excel refuses to accept because I have exceeded the maximum number of nested IF statements allowed. (I believe the max. number is set at seven nested IF statements.) Can anybody suggest how the formula could be optimized? =IF(W4="",IF(LEFT(L4,5)="1C050",R4*0.38,IF(LEFT(L4 ,5)="1F0VE",R4*0.45,IF(LEFT(L4,5)="1F0VT",R4*0.45, IF(LEFT(L4,5)="1FACC",R4*0.45,IF(LEFT(L4,5)="1H00E ",R4*0.38,IF(J4="X",R4*0.38,IF(L4="1HACCH1MEL000H0 0E",R4*0.38,IF(L4="1HACCH2CNT000H00E",R4*0.38,IF(L 4="1HACCH5CNV000H00E",R4*0.38,IF(L4="1HACCH6SBI000 H00E",R4*0.38,"")))))))))),"") Thanks. -- tb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nested if statements | Excel Worksheet Functions | |||
| Nested IF Statements | Excel Discussion (Misc queries) | |||
| Help with Nested If Statements | Excel Discussion (Misc queries) | |||
| I want to use more than 7 nested if then statements | Excel Worksheet Functions | |||
| Do I need nested IF statements? | Excel Worksheet Functions | |||
Threaded Mode
