Problem With formula
I have built this formula in cell Y4 which is used to calculate prices:
=IF(X4="",IF(ISNA(L4),"",IF(G4<"",L4*(1-G4),IF(LEFT(H4,5)="1M0ER",L4*0.
4,IF(OR(LEFT(H4,5)="1C050",LEFT(H4,5)="1H00E",H4=" 1HACCH1MEL000H000E",H4
="1HACCH2CNT000H000E",H4="1HACCH5CNV000H000E",H4=" 1HACCH6SBI000H000E",H4
="1HACCHIMELH0003",H4="1HACCH2CNTH0003",H4="1HACCH 5CNVH0003",H4="1HACCH6
SBIH0003"),L4*0.38*0.95,IF(OR(LEFT(H4,5)="1F0VE",L EFT(H4,5)="1FACC",LEFT
(H4,5)="1F0VT",LEFT(H4,5)="1FRMP",LEFT(H4,5)="1F0F V",LEFT(H4,5)="1FRIC")
,L4*0.45*0.95,IF(OR(E4=1,E4=3),L4*0.4*0.9,"")))))) )
If I insert something more in line No. 8, Excel complains. See the
"IF(E4=2)L4*0.4*0.95" shown below on line No. 8. Excel keeps on
telling me that it found a problem with this formula and to click the
Insert Function on the Formula tab to fix it. I cannot figure out what
the problem is... Have I perhaps reached the max number of characters
in a formula?
=IF(X4="",IF(ISNA(L4),"",IF(G4<"",L4*(1-G4),IF(LEFT(H4,5)="1M0ER",L4*0.
4,IF(OR(LEFT(H4,5)="1C050",LEFT(H4,5)="1H00E",H4=" 1HACCH1MEL000H000E",H4
="1HACCH2CNT000H000E",H4="1HACCH5CNV000H000E",H4=" 1HACCH6SBI000H000E",H4
="1HACCHIMELH0003",H4="1HACCH2CNTH0003",H4="1HACCH 5CNVH0003",H4="1HACCH6
SBIH0003"),L4*0.38*0.95,IF(OR(LEFT(H4,5)="1F0VE",L EFT(H4,5)="1FACC",LEFT
(H4,5)="1F0VT",LEFT(H4,5)="1FRMP",LEFT(H4,5)="1F0F V",LEFT(H4,5)="1FRIC")
,L4*0.45*0.95,IF(OR(E4=1,E4=3),L4*0.4*0.9,IF(E4=2) ,L4*0.4*0.95,"")))))))
--
tb
|