=WENN(ISTLEER(A1);"";WENN(A1<=0;"not due";WENN(UND(A1>0;$M4382<=60);"overdue"; WENN(UND(A1>60;A1<=90) ; ">60";WENN(A1>90;">90";"unspecified")))))
Danke für Eure Hilfe
B | |
2 | >90 |
3 | overdue |
4 | overdue |
5 | |
6 | overdue |
7 | not due |
8 | not due |
9 | not due |
verwendete Formeln | |||
Zelle | Formel | Bereich | N/A |
B2:B9 | =WENN(A2="";"";WENN($A2<=0;"not due";WENN(UND($A2>0;$A2<=60);"overdue";WENN(UND($A2>60;$A2<=90);">60";WENN($A2>90;">90";"unspecified"))))) |