29. , . 1 (. . 8)
30. , . 2 (. . 9)
31. B , . :
1 B13;
B13 . ;
Ctrl , B14:B30. B14:B30 1 18.
32. . :
10000 C13.
13:30;
// /;
, , 500;
OK.
33. , . 6 (. . 10).
34. . 3, 4, . 3:9, , . 34, , . 44, .
35. :
E20 | . / |
F21 | |
E22 | . . |
F23 | |
E24 | % |
F24 | 5 |
G24 | 5 10 |
H24 | 10 |
F25 | |
G25 | |
H25 | |
E26 | . |
F27 |
36. B3 ( , , $ F4 , Enter):
=(3;$L$3:$P$9;2;)
$ ( ).
. .
37. B4:B9. , , , .
. . .
38. D3:D9 E3:E9 ( ) )
|
|
39. 34 ( ):
=((A34;$$3:$J$9;3;);$$13:$$30;2; )*
(A34;$$3:$J$9;7;) /$F$23
40. 35:40.
41. 34 . , . :
=((()‑(A34;$L$3:$P$9;5;))/365<5;
B34*$F$25/100;((()‑(A34;$L$3:$P$9;5;
))/365<10;B34*$G$25/100;B34*$H$25/100))
35:40.
42. D34 :
=B34+C34
D35:D40.
43. H3 . H4:H9.
44. B44 :
=((A44;$A$3:$J$9;8;)-$F$21*(A44;$A$3:$J$9;6; ))*0,12
B45:B50.
45. 44 :
=(44;$A$3:$J$9;8;)*0,01
45:50
46. D44 :
=(((44;$$13:$F$15;2;));0;((A44;
$A$3:$J$9;8;)-B44)*(44;$E$13:$F$15;2;)/100)
D45:D50.
47. 44 : =B44+C44+D44
E45:E50.
48. I3 . I4:I9.
49. {=H3:H9 - I3:I9}. J3:J9, =, H3:H9, -, I3:I9, Ctrl +Shift+ Enter.
50. , .1. 10 :, H10 /- /. H3:H9, Enter. H3:H9 Enter.
I10, J10.
51. 1. I12 1. J12 :
=(3:E9;1;J3:J9)
52. J13 2.
53. 1. I14 1 . J14 :
=(3:E9;1)
54. J15 2.
55. .