-
#22 '2001: - : Excel << >>

: 12.
EXCEL.

, EXCEL

Ъ


" : Excel"

excel-. , .

. ""

( 11- ), "" 6, 7, 8, 9, 10, 11 . , , . , F7 (. 1).

1.

=(((A7);(B7);

(C7);(D7));;(C7=ʔ;

(D7;;3;);

((C7=;E7=ʔ);

(D7;;3;)))).

.

:

"(((A7);(B7);(C7);(D7));"

4 " " ( 1, 2, 3, 4).

A6, B6, C7, D7 ( ) , F7 (. 2).

( ). (7) , , , 7. "", F7 .

. ³ , . , - , . , 6 =((7);;7) (. 2). 7 , 6 (. 2). F6 . , .

2.

:

"(C7=ʔ;(D7;;3;)"

F7 ( ), 7 "".

! 7=ʔ , , ' .

:

"((C7=;E7=ʔ);(D7;;3;))"

F7 ( ), 7 "" "".

, "", .

.

; "" - , "" "" - . .

, G6 , , ( ) :

"(D6;;4;".

( - 4) ( ), (. 3).

3.

, . 3 , , 7 "". : "(D7;;4;)". 4, 4.

4.

7 ( G7):

=(((A7);(B7);
(C7);(D7));;

(C7=ʔ;(D7;;4;);

((C7=;E7=ʔ);(D7;;4;)))).

"" , - 3- , :

1. F6 ( ).

2. , ' , , (. 5).

5.

3. F6 Esc .

4. G6 . H6, I6, J6, K6.

5. ³ G6 "3" "4".

6. ³ . H6 "3" - "5", I6 - "6", J6 - "7", K6 - "8".

7. .

"" .

" "

, " " .

(*); ; , , , .

, " ", ( ).

1. L6 :

"=((C6=;C6=ʔ);*&;&!$D$6;)", :

- C6 , L6 ' : (*), (;) , ( ) D6. - ( $), (. 6);

6.

- - , L6 .

"*;".

2. 6 :

=((C6=;C6=ʔ);;&(D6;;9;)&;;).

, , , 7 :

=((C7=;C7=ʔ);;&(D7;;9;)&;;).

: ";;".

3. 6 :

=((E6);;(C6=ʔ;;
(&(E6;;4;)&);))
.

"((E6);", , . 6 , 6 .

";(&(E6;;4;)&)" : ";()".

" " .

""

: 18 ( ) 20 ( ). 20 6 (. 7) :

=(((G6);C6=;C6=ʔ);;((C6=ʔ;
(S6)); .;
. . =&(Q6/6;2))).

7.

"(((G6);C6=;C6=ʔ);" - .

((C6=ʔ;(S6)) , 6 " .", 6 "", S6 . S6 - , 6 ' " .. =, .".

"(Q6/6;2)".

, . ".", (. 7). (Q6/6) ( - 2), 2- . , - "(Q6/6)".

, Microsoft . , Excel, . ' . .

.

"" , 8 . 4:12 ' . .

8.

:

1. .

2. .

3. ' .

' .

(. 9). : .

9.

.

6 , , 999999,99 .

( 6).

, :

V6 =(Q6>=100000;(Q6/100000);0);
W6 =(Q6>=10000;
(Q6/10000)-((Q6/100000))*10;0);
X6 =(Q6>=1000;
(Q6/1000)-((Q6/10000))*10;0);
Y6 =(Q6>=100;
(Q6/100)-((Q6/1000))*10;0);
Z6 =(Q6>=10;(Q6/10)-((Q6/100))*10;0);
AA6 =(Q6>=1;(Q6)-((Q6/10))*10;0).

! ' (0).

.

.

, :

- 17 ί ;

- , "" ( );

- ". .".

:

- ( 8 );

- , , . , =('), '.

, 6:AG6 :
6: =(V6=0;;(V6;;5;));
6: =(W6=0;;((W6=1;X6>0);
(X6;;3;);(W6;;4;)));

AD6: =(X6=0;;(X6>0;(X6;;2;)));
6: =(Y6=0;;(Y6>0;(Y6;;5;)));

F6:

=(Z6=0;;((Z6=1;AA6>0);
(AA6;;3;);(Z6;;4;)));

AG6:

=(AA6=0;;((Q6>0;Q6<1);
"";(Z6=1;"";
(AA6>0;(AA6;;2;);""))).

, .

, , , . :
AI6: =(V6=0;;(V6=5;';
(V6=9;';(AB6))));
AJ6

=(V6>0;AC6;
((Q6/1000)=15;';

((Q6/1000)=19;';
((Q6/10000)=5;';

((Q6/10000)=9;';(AC6)))));

AK6

=((W6=1;X6=0);;
((Q6/1000)>9;AD6;

((Q6/1000)=5;';
((Q6/1000)=9;';(AD6)))));

AL6 =((V6=0;W6=0;X6=0);;
(X6=1;;((X6>1;X6<5);;)));
AM6

=(Y6=0;;((Q6/100)>9;AE6;
((Q6<1000;Y6=5);';

((Q6<1000;Y6=9);';(AE6)))));

AN6

=((Q6/10)>9;
AF6;((Q6)=15;';

((Q6)=19;';
((Q6/10)=5;';

((Q6/10)=9;';(AF6))))));

AO6

=((Q6)>9;AG6;
((Q6)=5;';

((Q6)=9;';(AG6))));

AP6 =(Q6-(Q6)=0;. 00 .;
. &(Q6*100-(Q6)*100)& .).

, 18-, . .

, R6 (. 10):

=((Q6);;AI6& &AJ6& &AK6& 
&AL6& &AM6& &AN6& &AO6& &AP6),

10.

' .

  ( - ) .

F6:6 106 ( , 100 ).

! , (N6, P6, Q6, S6), .

.

11 , .

11.

, , :

D6: =((G2);;(1;;3;));

C8: =((G2);;(1;;4;));

E10: =((G2);;(1;;5;));

E12: =((G2);; . &(1;;6;));

I11: =((G2);;(1;;7;));

N11: =((G2);;(1;;8;));

, , , ( ), . D6, C8, E10, E10, E12, I11, N11 .

, . 3, , :

=((G2);;(G2;;2;)).

, :

D14: =((G2);;((G2;;6;)));

C16: =((G2);;((G2;;7;)));

E18: =((G2);;(G2;;8;));

E20: =((G2);; . &(G2;;9;));

I19: =((G2);;(G2;;10;));

N19: =((G2);;(G2;;11;));

Q11: =((G2);;(G2;;17;));

E21: =((G2);;(G2;;18;));

! E12 E20 " . &".

, .

F23 : =((G2);
;(((G2; ;3;);1)=;
(G2;;12;)&(G2;;13;)
&(G2;;14;)&;&(G2;;15;)
&(G2;;16;);(

(G2;;3;)=ʔ;(G2;;16;)
&(G2;;20;)))).

, . ϳ : "(((G2;;3;);1)=" "((G2;;3;)=ʔ", .

:

- (((G2;;3;);1)) 3 (((G2;;3;);1)) "", 12, 13, 14, 15, 16;

- 3 "", 16 20.

! "((G2);;". , , "/".

, .

, , , 1 (. 12):

1) 6 ;

2) 6 . , ;

3) 6 , . "", "", "" - ;

4) ( ""), (7). D6;

5) F6 ;

6) Q6 ;

7) , S6 - (, 1).

.

G2 , 1. , , 11, 6 , G2 1). .

- " ".


<< >>
© 2001
"-"