A1: =WENN(C3=
""
;
""
;
"Äpfel"
)
A2: =WENN(C3=
""
;
""
;
"Birnen"
)
A3: =WENN(C3=
""
;
""
;
"Bananen"
)
A4: =WENN(C3=
""
;
""
;
"Pfirsiche"
)
---------------------------------------------
A5: =WENN(C4=
""
;
""
;
"Äpfel"
)
A6: =WENN(C4=
""
;
""
;
"Birnen"
)
A7: =WENN(C4=
""
;
""
;
"Bananen"
)
A8: =WENN(C4=
""
;
""
;
"Pfirsiche"
)
--------------------------------------------
A9: =WENN(C5=
""
;
""
;
"Äpfel"
)
A10: =WENN(C5=
""
;
""
;
"Birnen"
)
A11: =WENN(C5=
""
;
""
;
"Bananen"
)
A12: =WENN(C5=
""
;
""
;
"Pfirsiche"
)
.
.
.
A1000