verwendete Formeln |
Zelle | Formel |
F14 | =WENN(C14-E$2<$C$2;C14-E2+$D$2;C14-$E$2) |
G14 | =WENN(F14-E2<C2;F14-E2+D2;F14-E2) |
H14 | =WENN(G14-E2<C2;G14-E2+D2;G14-E2) |
I14 | =WENN(H14-E2<C2;H14-E2+D2;H14-E2) |
F15 | =WENN(C15-E$2<$C$2;C15-E3+$D$2;C15-$E$2) |
G15 | =WENN(F15-E3<C3;F15-E3+D3;F15-E3) |
H15 | =WENN(G15-E3<C3;G15-E3+D3;G15-E3) |
I15 | =WENN(H15-E3<C3;H15-E3+D3;H15-E3) |
F16 | =WENN(C16-E$2<$C$2;C16-E4+$D$2;C16-$E$2) |
G16 | =WENN(F16-E4<C4;F16-E4+D4;F16-E4) |
H16 | =WENN(G16-E4<C4;G16-E4+D4;G16-E4) |
I16 | =WENN(H16-E4<C4;H16-E4+D4;H16-E4) |
F17 | =WENN(C17-E$2<$C$2;C17-E5+$D$2;C17-$E$2) |
G17 | =WENN(F17-E5<C5;F17-E5+D5;F17-E5) |
H17 | =WENN(G17-E5<C5;G17-E5+D5;G17-E5) |
I17 | =WENN(H17-E5<C5;H17-E5+D5;H17-E5) |
F18 | =WENN(C18-E$2<$C$2;C18-E6+$D$2;C18-$E$2) |
G18 | =WENN(F18-E6<C6;F18-E6+D6;F18-E6) |
H18 | =WENN(G18-E6<C6;G18-E6+D6;G18-E6) |
I18 | =WENN(H18-E6<C6;H18-E6+D6;H18-E6) |
F19 | =WENN(C19-E$2<$C$2;C19-E7+$D$2;C19-$E$2) |
G19 | =WENN(F19-E7<C7;F19-E7+D7;F19-E7) |
H19 | =WENN(G19-E7<C7;G19-E7+D7;G19-E7) |
I19 | =WENN(H19-E7<C7;H19-E7+D7;H19-E7) |
F20 | =WENN(C20-E$2<$C$2;C20-E8+$D$2;C20-$E$2) |
G20 | =WENN(F20-E8<C8;F20-E8+D8;F20-E8) |
H20 | =WENN(G20-E8<C8;G20-E8+D8;G20-E8) |
I20 | =WENN(H20-E8<C8;H20-E8+D8;H20-E8) |
F21 | =WENN(C21-E$2<$C$2;C21-E9+$D$2;C21-$E$2) |
G21 | =WENN(F21-E9<C9;F21-E9+D9;F21-E9) |
H21 | =WENN(G21-E9<C9;G21-E9+D9;G21-E9) |
I21 | =WENN(H21-E9<C9;H21-E9+D9;H21-E9) |