Hi

One way
=IF(W4="",
IF(OR(LEFT(L4,5)="1C050",LEFT(L4,5)="1H00E"),R4*0. 38,
IF(OR(LEFT(L4,5)="1F0VE",LEFT(L4,5)="1FACC",LEFT(L 4,5)="1F0VT"),R4*0.45,
IF(OR(J4="X",L4="1HACCH1MEL000H00E",L4="1HACCH2CNT 000H00E",
L4="1HACCH5CNV000H00E",L4="1HACCH6SBI000H00E"),R4* 0.38,
IF(OR(L4="1HACCH1MEL000H00E",L4="1HACCH2CNT000H00E ",
L4="1HACCH5CNV000H00E",L4="1HACCH6SBI000H00E"),R4* 0.38,"")))))

--
Regards
Roger Govier



"Tiziano" wrote in message
...
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