verwendete Formeln |
Zelle | Formel | Bereich |
F3 | =LÄNGE(C3) | |
F5 | =F3-D5 | |
D7 | =WENN(C7<>"";TEIL($C$3;C7;$D$5);"") | |
E7 | =WENN(C7<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D7;"C";"");"G";"")))/$D$5;"") | |
C8 | =WENN(MAX(C$7:C7)+1<=$F$5;MAX(C$7:C7)+1;"") | |
D8 | =WENN(C8<>"";TEIL($C$3;C8;$D$5);"") | |
E8 | =WENN(C8<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D8;"C";"");"G";"")))/$D$5;"") | |
C9 | =WENN(MAX(C$7:C8)+1<=$F$5;MAX(C$7:C8)+1;"") | |
D9 | =WENN(C9<>"";TEIL($C$3;C9;$D$5);"") | |
E9 | =WENN(C9<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D9;"C";"");"G";"")))/$D$5;"") | |
C10 | =WENN(MAX(C$7:C9)+1<=$F$5;MAX(C$7:C9)+1;"") | |
D10 | =WENN(C10<>"";TEIL($C$3;C10;$D$5);"") | |
E10 | =WENN(C10<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D10;"C";"");"G";"")))/$D$5;"") | |
C11 | =WENN(MAX(C$7:C10)+1<=$F$5;MAX(C$7:C10)+1;"") | |
D11 | =WENN(C11<>"";TEIL($C$3;C11;$D$5);"") | |
E11 | =WENN(C11<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D11;"C";"");"G";"")))/$D$5;"") | |
C12 | =WENN(MAX(C$7:C11)+1<=$F$5;MAX(C$7:C11)+1;"") | |
D12 | =WENN(C12<>"";TEIL($C$3;C12;$D$5);"") | |
E12 | =WENN(C12<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D12;"C";"");"G";"")))/$D$5;"") | |
C13 | =WENN(MAX(C$7:C12)+1<=$F$5;MAX(C$7:C12)+1;"") | |
D13 | =WENN(C13<>"";TEIL($C$3;C13;$D$5);"") | |
E13 | =WENN(C13<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D13;"C";"");"G";"")))/$D$5;"") | |
C14 | =WENN(MAX(C$7:C13)+1<=$F$5;MAX(C$7:C13)+1;"") | |
D14 | =WENN(C14<>"";TEIL($C$3;C14;$D$5);"") | |
E14 | =WENN(C14<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D14;"C";"");"G";"")))/$D$5;"") | |
C15 | =WENN(MAX(C$7:C14)+1<=$F$5;MAX(C$7:C14)+1;"") | |
D15 | =WENN(C15<>"";TEIL($C$3;C15;$D$5);"") | |
E15 | =WENN(C15<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D15;"C";"");"G";"")))/$D$5;"") | |
C16 | =WENN(MAX(C$7:C15)+1<=$F$5;MAX(C$7:C15)+1;"") | |
D16 | =WENN(C16<>"";TEIL($C$3;C16;$D$5);"") | |
E16 | =WENN(C16<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D16;"C";"");"G";"")))/$D$5;"") | |
C17 | =WENN(MAX(C$7:C16)+1<=$F$5;MAX(C$7:C16)+1;"") | |
D17 | =WENN(C17<>"";TEIL($C$3;C17;$D$5);"") | |
E17 | =WENN(C17<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D17;"C";"");"G";"")))/$D$5;"") | |
C18 | =WENN(MAX(C$7:C17)+1<=$F$5;MAX(C$7:C17)+1;"") | |
D18 | =WENN(C18<>"";TEIL($C$3;C18;$D$5);"") | |
E18 | =WENN(C18<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D18;"C";"");"G";"")))/$D$5;"") | |
C19 | =WENN(MAX(C$7:C18)+1<=$F$5;MAX(C$7:C18)+1;"") | |
D19 | =WENN(C19<>"";TEIL($C$3;C19;$D$5);"") | |
E19 | =WENN(C19<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D19;"C";"");"G";"")))/$D$5;"") | |
C20 | =WENN(MAX(C$7:C19)+1<=$F$5;MAX(C$7:C19)+1;"") | |
D20 | =WENN(C20<>"";TEIL($C$3;C20;$D$5);"") | |
E20 | =WENN(C20<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D20;"C";"");"G";"")))/$D$5;"") | |
C21 | =WENN(MAX(C$7:C20)+1<=$F$5;MAX(C$7:C20)+1;"") | |
D21 | =WENN(C21<>"";TEIL($C$3;C21;$D$5);"") | |
E21 | =WENN(C21<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D21;"C";"");"G";"")))/$D$5;"") | |
C22 | =WENN(MAX(C$7:C21)+1<=$F$5;MAX(C$7:C21)+1;"") | |
D22 | =WENN(C22<>"";TEIL($C$3;C22;$D$5);"") | |
E22 | =WENN(C22<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D22;"C";"");"G";"")))/$D$5;"") | |
C23 | =WENN(MAX(C$7:C22)+1<=$F$5;MAX(C$7:C22)+1;"") | |
D23 | =WENN(C23<>"";TEIL($C$3;C23;$D$5);"") | |
E23 | =WENN(C23<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D23;"C";"");"G";"")))/$D$5;"") | |
C24 | =WENN(MAX(C$7:C23)+1<=$F$5;MAX(C$7:C23)+1;"") | |
D24 | =WENN(C24<>"";TEIL($C$3;C24;$D$5);"") | |
E24 | =WENN(C24<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D24;"C";"");"G";"")))/$D$5;"") | |
C25 | =WENN(MAX(C$7:C24)+1<=$F$5;MAX(C$7:C24)+1;"") | |
D25 | =WENN(C25<>"";TEIL($C$3;C25;$D$5);"") | |
E25 | =WENN(C25<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D25;"C";"");"G";"")))/$D$5;"") | |
C26 | =WENN(MAX(C$7:C25)+1<=$F$5;MAX(C$7:C25)+1;"") | |
D26 | =WENN(C26<>"";TEIL($C$3;C26;$D$5);"") | |
E26 | =WENN(C26<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D26;"C";"");"G";"")))/$D$5;"") | |
C27 | =WENN(MAX(C$7:C26)+1<=$F$5;MAX(C$7:C26)+1;"") | |
D27 | =WENN(C27<>"";TEIL($C$3;C27;$D$5);"") | |
E27 | =WENN(C27<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D27;"C";"");"G";"")))/$D$5;"") | |
C28 | =WENN(MAX(C$7:C27)+1<=$F$5;MAX(C$7:C27)+1;"") | |
D28 | =WENN(C28<>"";TEIL($C$3;C28;$D$5);"") | |
E28 | =WENN(C28<>"";($D$5-LÄNGE(WECHSELN(WECHSELN(D28;"C";"");"G";"")))/$D$5;"") | |