: - , . , . , , , , , .
, . . , , . D . 1.12.
1.12
? , .
. , , . 1.7 .
1.7
7 | =(4;5) | - |
8 | =(D2:D19*)-B1*(1-B2) | - |
B9 | =B1+B8 | - |
2 | =(()-1<=$B$5;($B$4;()-1);"") | 3 19 |
D2 | =(()-1<=$B$5;$B$1*(1-$B$2)/$B$5*(1+(()-1)*$B$3/12);"") | D3-D19 |
, , . Office Excel, . OK. , 7 :
=((4);(4)+5;1)
8 , D . .
.
C D. . , . , . . , .
, . () , 2 2, ()-1 . , , .
|
|
, 2 , 3:10
=(()-1<=$B$5;(($B$4);($B$4)+ ()-1;1);)
, , . $B$1*(1-$B$2) , 5, . $B$3/12 , 1+(()-1)*$B$3/12) , , . , .
, . .
2
: .
, , 1.13. , L1 , 0401060 , 0 .
1.13 -