Kann das klappen?
18.08.2016 08:24:57
BS
ich habe hier etwas geschrieben in der Annahme das es so klappen könnte! :)
Doch leider zeigt mir Excel das ich anscheinend falsch lag...
If Range("S" & x) <> "40000" And Range("AY" & x) = "6" And PB > "0,5" And DN > "25" And DNPB <= "2000" Then
Range("L" & x) = "bP"
ElseIf Range("S" & x) <> "40000" And Range("AY" & x) = "6" And PB > "0,5" And DN > "25" And DNPB > "2000" Then
Range("L" & x) = "ZÜS"
ElseIf Range("S" & x) <> "40000" And Range("AY" & x) = "7" And PB > "0,5" And PB <= "62,5" And DN > "32" And DNPB > "1000" And DNPB <= "2000" Then
Range("L" & x) = "bP"
ElseIf Range("S" & x) <> "40000" And Range("AY" & x) = "7" And PB > "0,5" And DN > "32" And DNPB > "2000" Then
Range("L" & x) = "ZÜS"
ElseIf Range("S" & x) <> "40000" And Range("AY" & x) = "7" And PB > "0,5" And DN > "25" And DNPB <= "1000" Then
Range("L" & x) = "-/-"
ElseIf Range("S" & x) <> "40000" And Range("AY" & x) = "8" And PB > "0,5" And DN > "25" And DNPB <= "2000" Then
Range("L" & x) = "-/-"
ElseIf Range("S" & x) <> "40000" And Range("AY" & x) = "8" And PB > "0,5" And DN > "25" And DNPB > "2000" Then
Range("L" & x) = "ZÜS"
ElseIf Range("S" & x) <> "40000" And Range("AY" & x) = "9" And DNPB <= "5000" Then
Range("L" & x) = "-/-"
ElseIf Range("S" & x) <> "40000" And Range("AY" & x) = "9" And PB > "10" And DN > "200" And DNPB > "5000" Then
Range("L" & x) = "ZÜS"
Else: Range("L" & x) = "HAHA"
End If
Kann mir jemand von euch meinen Fehler aufzeigen?
mfg BS