1) , Y:\01. ( )\04. .\ Excel\tr14.xls. 1.
2) () :
- , (# /), - ( , /) - - , , - ) ():
) : - - ; - ( ), - (= * = *), , 2 , , , ; - ( );
) : - , 1/, ... >= 98 <= 200;
) : - , 1/, ... <= 100. , ) -) . ) - ) , ; - (, /).
3) . :
- ( 1):
1/ ( )
C D E F
64
65 , , -
66
67 . .
68
69 * >=98 <=200 <=100
70 * >=98 <=200 <=100
71 * >=98 <=200 <=100
.
2/
H I J
68
69 *
70 *
71 *
H69:J71 , :
I69:I71 =(E11<=200;E11>=98)
J69:J71 =H11<=100
, (C68:F68), , (C69:F71), (C10, E10, H10), , , . .
|
|
, ( $), ( ) , , , , (E11, H11).
- , ( ).
, , , .
1/
B C D E F G H I J K
74 # , -
75 , - - -
76
77 . - - ,
78 / ..
2/
B C D E F G H I J K
90 # , -
91 , -
92
93 . - ,
94 / ..
, , .
- , , (B10:K60). - ( , / ) : - , - (C68:F71 H68:J71). , 1/ , 2/ - , (C68:F68 H68:J68), , - , . - , , : ). (B78:K86 C94:J102). , 1/ , 2/ , (B78:K78 C94:J94). .
2. 1 Excel-7.xls.
3. D69:D71 E69:E71 ( ) . Excel Excel-8.xls.
4. : ) ) 250 100. Excel Excel-9.xls.
, , , .
|
|
- N6. : Excel
: Excel , .
: Excel .
: Excel .
1. ( Y:\01. ( )\04. .\ Excel \tr14.xls) , .