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",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,"")))))) )

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";"1HACCH6 SBI000H000E";"1HACCHIMELH0003";"1HACCH2CNTH0003";" 1HACCH2CNVH0003";"1HACCH6SBIH0003"})),L4*0.38*0.95 ,IF(OR(LEFT(H4,5)={"1F0VE";"1FACC";"1F0VT";"1FRMP" ;"1F0FV";"1FRIC"}),L4*0.45*0.95,IF(OR(E4={1;3}),L4 *0.4*0.9,""))))))


Regards
Claus B.
--
Windows10
Office 2016