,
_=*._ D6=C6B6*B$3.
, . , . , , (D6=(0;C6B6*B$3)). ,
=_*_ E6=(D6;B$1:F$2;2;1)*D6.
, () . , , . F6=D6E6.
: , . , . , , , .
A | B | C | D | E | F | ||||||
: | |||||||||||
: | 0% | 12% | 15% | 20% | 30% | ||||||
. . | |||||||||||
=(0;C6B6*B$3) | =(D6;B$1:F$2;2;1)*D6 | =D6E6 | |||||||||
=(0;C7B7*B$3) | =(D7;B$1:F$2;2;1)*D7 | =D7E7 | |||||||||
=(0;C8B8*B$3) | =(D8;B$1:F$2;2;1)*D8 | =D8E8 | |||||||||
=(C6:C8) | =(D6:D8) | =(E6:E8) | =(F6:F8) | ||||||||
. 5.20
5.21. . . , , . , 2000 240, 2001 300, .. . , ( ). . , ( 1:6). 12% 10000, 18% , 10001 30000 .. 18% , , 10000. . 65000. :
A | B | C | |
% | |||
: | : | ||
10 000 | 12% | ||
10 001 | 30 000 | 18% | |
30 001 | 60 000 | 25% | |
60 001 | 35% | ||
... | |||
5 000 | |||
20 000 | 3 000 | ||
50 000 | 2 300 | ||
65 000 | 14 050 | ||
140 000 | 19 950 | ||
.5.21 |
12% 10000 0,12*10000=1200
|
|
18% 3000010000=20000 0,18*20000=3600
25% 6000030000=30000 0,25*30000=7500
35% 6500060000=5000 0,35*5000 =1750
14050
:
= ( <10, 12%*;
(<30, 12%*10+18%*(10);
( <60, 12%*10+18%*20+25%*(30);
12%*10+18%*20+25%*30+35%(60)))).
. 5.21 ( ).
. 5.21
:
B9=(B9<B$3;C$3*B9; (B9<B$4;C$3*B$3+C$4*(B9B$3);
(B9<B$5;C$3*B$3+C$4*(B$4B$3)+C$5*(B9B$5);
C$3*B$3+C$4*(B$4B$3)+C$5*(B$5B$4)+C$6*(B9B$5)))).
. 2001 . 13% . ( ) , .
A | B | C | D | E | F | G | H | I | |
20000: | 12% | ||||||||
20000: | 20% | ||||||||
. | 5.22 |
5.22. . , , /. , . , . . 20000. , 20000 20%. 12 , , , . :
___=
_____*____.
:
=__,_____ *__
|
|
__,_____ .
() . 5.22.
- | ||||||
12% 8000=960 | ||||||
12% 17000=2040 |
| |||||
20% 24000=4800 |
.
E6=($D$5:D$5;"";$D6:D6)*(($D$5:D$5;"";$D6:D6)<=$B$1;
$C$1;$C$2)($D$5:D$5;"";$D6:D6),
G6=($D$5:F$5;"";$D6:F6)*(($D$5:F$5;"";$D6:F6)<=$B$1;