: , . , . -, . -, .
- (. .1.14).
1.14 -
1.8 -
| G1 | =() | - |
| 11 | =C11*D11 | 12-16 |
| 11 | =E11*G11 | 12-16 |
| I11 | =E11+H11 | I12-I16 |
| 7 | =() | - |
| I17 | =(I11:I16) | - |
| C19 | =I17 | - |
, , . 11-16; 11-16; I11-I16 , . # ##0,00;#;#. , . # , . 7 876,00.
- , sumprop.xls, , D19 :
=(C19)
:
http://superbook.nm.ru/sumprop.xls
http://super-book.euro.ru/sumprop.xls
, : Office, Excel. . .
- .
(. 1.15)
1.15 -
- . , -. . 1.16.
1.16
, , (. 1.17).
1.17 -
, -, -. A1 =, , 3. =1!B3. , -. , 1.9.
|
|
|
1.9
| 2 | =1!B4 | - |
| 5 | =1!G1 | - |
| 7 | =1!H3 | - |
| 9 | =1!I6 | - |
| 12 | =1!A11 | 13-16 |
| D12 | =1!C11 | D13-D16 |
| 12 | =1!D11 | 13-16 |
| F12 | =1!E11 | F13-F16 |
| F17 | =(F12:F16) | - |
| E18 | =1!G11 | - |
| F18 | =F17*E18 | - |
| F19 | =(F17;F18) | - |
| A22 | =1!C19&" "&1!D19 | - |
| F26 | =1!C20 | - |
| F28 | =1!I20 | - |
. 1.18.
(. 1.19) , . , .
. - 1 C19, : =(1!C19). , F18, . G18 :
=(((1!C19-F18)*100;0);00)
, ,
=2!12& &2!13& &2!14
, . -, .
1.18
1.19
3
: , .
Excel. (. 1.20).
1.20
, . , , .
, . , 1.21.
1.21
, 3 .
(! , ).
4 .
1.10
| B5 | =(G10:G12) | - |
| B6 | =(!$D$5:$D$100; B3;!$E$5:$E$100) | - |
| B7 | =B4+B5-B6 | - |
| F10 | =((!$A$5:$A$100;A10; !$B$5:$B$100))*C10 | F11-F12 |
| G10 | =(F10<D10;D10;F10)+E10+B10 | G11-G12 |
|
|
|
10:12 .
