| | A | B | C | D | E | F | G | H | I | J | K | | 1 | | | | | | | | | | | | | 2 | | Rohüberschusstabelle | | Ist= | 5,13% | |
|---|
| 3 | | | | | | | | | | 5,13 | | | 4 | | 5,88 | | Wert= | 1,45% | für prov |
|---|
| 5 | | | | | | | | | | | | | 6 | | | | | | | | | | | | | 7 | | Ist-Rohüberschuss | prov | Grundprovision | | Wert= | 1,15% | für Grundprovision |
|---|
| 8 | | | 2,62% | - | 0,00% | 1,20% | 0,90% | | | | | | 9 | | | 3,12% | - | 2,63% | 1,20% | 0,90% | | Wert= | 2,60% | für Prov+Grundprovision | | 10 | | | 3,62% | - | 3,13% | 1,25% | 0,95% | | | | | | 11 | | | 4,12% | - | 3,63% | 1,30% | 1,00% | | | | | | 12 | | | 4,62% | - | 4,13% | 1,35% | 1,05% | | | | | | 13 | | | 5,12% | - | 4,63% | 1,40% | 1,10% | | | | | | 14 | | | 5,62% | - | 5,13% | 1,45% | 1,15% | | | | | | 15 | | | 5,63% | - | 6,13% | 1,50% | 1,20% | | | | | | 16 | | | 6,14% | - | 6,63% | 1,55% | 1,25% | | | | | | 17 | | | 6,64% | - | 7,13% | 1,60% | 1,30% | | | | | | 18 | | | 7,14% | - | 7,63% | 1,65% | 1,35% | | | | | | 19 | | | 7,64% | - | 8,13% | 1,70% | 1,40% | | | | | | 20 | | | 8,14% | - | 8,63% | 1,75% | 1,45% | | | | | | 21 | | | 8,64% | - | 9,13% | 1,80% | 1,50% | | | | | | 22 | | | 9,14% | - | 100,00% | 1,80% | 1,50% | | | | | | Formeln der Tabelle | J4 : =SVERWEIS(J2;$E$8:$G$22;2)
J7 : =SVERWEIS(J2;$E$8:$G$22;3)
C8 : =($B$4-3,26)/100
F8 : =F15-0,3%
G8 : =G15-0,3%
C9 : =($B$4-2,76)/100
E9 : =($B$4-3,25)/100
F9 : =F15-0,3%
G9 : =G15-0,3%
J9 : =SVERWEIS(J2;$E$8:$G$22;2)+SVERWEIS(J2;$E$8:$G$22;3)
C10 : =($B$4-2,26)/100
E10 : =($B$4-2,75)/100
F10 : =F15-0,25%
G10 : =G15-0,25%
C11 : =($B$4-1,76)/100
E11 : =($B$4-2,25)/100
F11 : =F15-0,2%
G11 : =G15-0,2%
C12 : =($B$4-1,26)/100
E12 : =($B$4-1,75)/100
F12 : =F15-0,15%
G12 : =G15-0,15%
C13 : =($B$4-0,76)/100
E13 : =($B$4-1,25)/100
F13 : =F15-0,1%
G13 : =G15-0,1%
C14 : =($B$4-0,26)/100
E14 : =($B$4-0,75)/100
F14 : =F15-0,05%
G14 : =G15-0,05%
C15 : =($B$4-0,25)/100
E15 : =($B$4+0,25)/100
J15 : =WENN(E15<=$J$2;F15;"")
C16 : =($B$4+0,26)/ 100
E16 : =($B$4+0,75)/ 100
F16 : =F15+0,05%
G16 : =G15+0,05%
J16 : =WENN(E16<=$J$2;F16;"")
C17 : =($B$4+0,76)/ 100
E17 : =($B$4+1,25)/ 100
F17 : =F15+0,1%
G17 : =G15+0,1%
J17 : =WENN(E17<=$J$2;F17;"")
C18 : =($B$4+1,26)/ 100
E18 : =($B$4+1,75)/ 100
F18 : =F15+0,15%
G18 : =G15+0,15%
J18 : =WENN(E18<=$J$2;F18;"")
C19 : =($B$4+1,76)/ 100
E19 : =($B$4+2,25)/ 100
F19 : =F15+0,2%
G19 : =G15+0,2%
J19 : =WENN(E19<=$J$2;F19;"")
C20 : =($B$4+2,26)/ 100
E20 : =($B$4+2,75)/ 100
F20 : =F15+0,25%
G20 : =G15+0,25%
J20 : =WENN(E20<=$J$2;F20;"")
C21 : =($B$4+2,76)/ 100
E21 : =($B$4+3,25)/ 100
F21 : =F15+0,3%
G21 : =G15+0,3%
J21 : =WENN(E21<=$J$2;F21;"")
C22 : =($B$4+3,26)/ 100
F22 : =F15+0,3%
G22 : =G15+0,3%
J22 : =WENN(E22<=$J$2;F22;"")
|
|