| Zelle | Formel |
| D2 | {=MAX((A$2:A$35<=B2)*A$2:A$35)} |
| E2 | =GANZZAHL(B$2/D2) |
| D3 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D2)*(E$2:E2)); 5))*A$2:A$35)} |
| E3 | =WENN(D3=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D2)*(E$2:E2))); 5)/D3)) |
| D4 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D3)*(E$2:E3)); 5))*A$2:A$35)} |
| E4 | {=WENN(D4=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D3)*(E$2:E3))); 5)/D4))} |
| D5 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D4)*(E$2:E4)); 5))*A$2:A$35)} |
| E5 | {=WENN(D5=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D4)*(E$2:E4))); 5)/D5))} |
| D6 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D5)*(E$2:E5)); 5))*A$2:A$35)} |
| E6 | {=WENN(D6=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D5)*(E$2:E5))); 5)/D6))} |
| D7 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D6)*(E$2:E6)); 5))*A$2:A$35)} |
| E7 | {=WENN(D7=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D6)*(E$2:E6))); 5)/D7))} |
| D8 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D7)*(E$2:E7)); 5))*A$2:A$35)} |
| E8 | {=WENN(D8=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D7)*(E$2:E7))); 5)/D8))} |
| D9 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D8)*(E$2:E8)); 5))*A$2:A$35)} |
| E9 | {=WENN(D9=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D8)*(E$2:E8))); 5)/D9))} |
| D10 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D9)*(E$2:E9)); 5))*A$2:A$35)} |
| E10 | {=WENN(D10=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D9)*(E$2:E9))); 5)/D10))} |
| D11 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D10)*(E$2:E10)); 5))*A$2:A$35)} |
| E11 | {=WENN(D11=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D10)*(E$2:E10))); 5)/D11))} |
| D12 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D11)*(E$2:E11)); 5))*A$2:A$35)} |
| E12 | {=WENN(D12=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D11)*(E$2:E11))); 5)/D12))} |
| D13 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D12)*(E$2:E12)); 5))*A$2:A$35)} |
| E13 | {=WENN(D13=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D12)*(E$2:E12))); 5)/D13))} |
| D14 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D13)*(E$2:E13)); 5))*A$2:A$35)} |
| E14 | {=WENN(D14=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D13)*(E$2:E13))); 5)/D14))} |
| D15 | {=MAX((A$2:A$35<=RUNDEN(B$2-SUMME((D$2:D14)*(E$2:E14)); 5))*A$2:A$35)} |
| E15 | {=WENN(D15=0;0;GANZZAHL(RUNDEN((B$2-SUMME((D$2:D14)*(E$2:E14))); 5)/D15))} |