On 1/30/2017 at 1:58:05 PM Claus Busch wrote:

Hi,

Am Mon, 30 Jan 2017 18:14:42 +0000 (UTC) schrieb tb:

=IF(X4="",IF(ISNA(L4),"",IF(G4<"",L4*(1-G4),IF(LEFT(H4,5)="1M0ER",L
4*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="1HA
CCH6
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)="1FR
IC") ,L4*0.45*0.95,IF(OR(E4=1,E4=3),L4*0.4*0.9,"")))))) )

try:

=IF(OR(X4="",ISNA(L4)),"",IF(G4<"",L4*(1-G4),IF(LEFT(H4,5)="1M0ER",L4
*0.4,IF(OR(OR(LEFT(H4,5)={"1H00E";"1C050"}),OR(H4= {"1HACCH1MEL000H000E
";"1HACCH2CNT000H000E";"1HACCH5CNV000H000E";"1HACC H6SBI000H000E";"1HAC
CHIMELH0003";"1HACCH2CNTH0003";"1HACCH2CNVH0003";" 1HACCH6SBIH0003"})),
L4*0.38*0.95,IF(OR(LEFT(H4,5)={"1F0VE";"1FACC";"1F 0VT";"1FRMP";"1F0FV"
;"1FRIC"}),L4*0.45*0.95,IF(OR(E4={1;3}),L4*0.4*0.9 ,""))))))


Regards
Claus B.

Thanks, Claus. I will be testing your formula and hopefully everything
will be ok.

--
tb