1
( )
ճ
1. Microsoft Excel 2007.
2. ᒺ ᒺ F2:H2; B8:D10; G8:H8; C12:E12; C13:E13; C20:E20 (. . 5.2).
3. 泅 , . 5.3, (.5.4) (,, ).
4 :
5 ( 13:20) , , , (G8; F13:H20; F22:F24) ..
6 .
7. H13,
, " IF.
8. : : OR(F13>0; G13>0) - , . :
$G$8+SUM($F$13:F13)-SUM($G$13:G13) - : .
: "" - , _, (, ), , .
9 ( , ), 13:20.
10 F22, F13:F20.
11. F23 .
12. F24 =G8+(F22-F23).
13. , , . 5.1.
14. . 5.1.
15. .
: ______________________________________________________
________________________________ϳ________________