|
Hi Emre,
ersetze den Formelcode komplett mit:
ActiveCell.FormulaR1C1 = _
"=IF(OR(RC[-5]=1,RC[-5]=2),""1180x780x1100"",IF(RC[-11]=190,""190x140x100"",IF(RC[-11]=""290K"",""290x190x100"",IF(RC[-11]=""290G"",""290x190x150"",IF(RC[-11]=305,""305x225x124"",IF(RC[-11]=""390M"",""390x290x100"",IF(RC[-11]=""390G"",""390x290x200"",IF(RC[-11]=394,""394x194x220"",IF(RC[-11]=""530K"",""530x190x115"",IF(RC[-11]=""530M"",""530x190x230"",IF(RC[-11]=""53" & _
"0G"",""530x380x230"",IF(RC[-11]=600,""600x400x500"",IF(RC[-11]=710,""710x300x195"",IF(RC[-11]=800,""800x600x500"",IF(RC[-11]=885,""885x250x394"",IF(RC[-11]=1180,""1180x780x1100"",IF(RC[-11]=""BAN24"",""Banane"",IF(RC[-11]=""BAN20"",""Banane"",IF(RC[-11]=""BAN16"",""Banane"",IF(AND(RC[-11]=""KAR"",RC[-12]>1),""Original"",IF(RC[-11]=""190x140x100"",RC[-11],IF(RC[-11]=" & _
"""290x190x100"",RC[-11],IF(RC[-11]=""290x190x150"",RC[-11],IF(RC[-11]=""305x225x124"",RC[-11],IF(RC[-11]=""390x290x100"",RC[-11],IF(RC[-11]=""390x290x200"",RC[-11],IF(RC[-11]=""394x194x220"",RC[-11],IF(RC[-11]=""530x190x115"",RC[-11],IF(RC[-11]=""530x190x230"",RC[-11],IF(RC[-11]=""530x380x230"",RC[-11],IF(RC[-11]=""600x400x500"",RC[-11],IF(RC[-11]=""710x300x195"",RC" & _
"[-11],IF(RC[-11]=""800x600x500"",RC[-11],IF(RC[-11]=""885x250x394"",RC[-11],IF(RC[-11]=""1180x780x1100"",RC[-11],IF(RC[-11]=""Banane"",RC[-11],""""))))))))))))))))))))))))))))))))))))" & _
""
LG
Alexandra
|