ü () p=3,14159265358979.
ü ( ) .
ü ( ) .
ü SIN( ) .
ü COS( ) .
ü TAN( ) .
ü ASIN() . .
ü ACOS() . .
ü ATAN() . .
ü ATAN2(X;Y) X Y.
, . ATAN(y/x) ATAN2(x;y), 0. : SIN((90))=1, SIN(()/2)=1, (ATAN(1))=45.
, , . , Excel , , , ., .
ü () .
: ("1232,56")=1232,56.
ü (; ) , .
: (2,715; "00,00")="02,72", ("25.3.98";"")="".
ü ([; ])
. , .
: (12345,678; 2)="12345,68", (12345,678; -3)="12000".
ü () . : (" Enter")=13.
ü () ( ) .
: (" 1 ")= "1 ", (" ")&""= "".
ü (1; 2) . , , . , . .
: ("";"")= , ("";"c")= ,
("";" ")= .
ü ( ; ; ; ) ( ) .
: ("1234567"; 3; 4; "*")=12*7, ("1234567"; 1; 9; "*")=*,
|
|
("1234567"; 4; 0; "*")=123*4567,
("1234567"; 4; 0; " ")=123 4567.
ü ( ; , [; ]) , . , . , 1 ( ).
: ("";"")=6.
ü ( ; , [; ]) , (? * ). . , 12 , .. ("*.";C12) 1, , , .. #!, .
ü (; ) . : (" ";6)= "".
ü (; ) . : (" ";7)= " ".
ü (; ; ) , . . , , . : (" ";3;5)= "".
ü (1; 2;...) , . &. , .
: (" ";"")=" ", (3;5,81)="35,81"
ü () . : (". ")=". ".
ü () .
: (". ")= ". ".
, . Excel, .
ü (; , ; [, ]) , , , .
: 1 5 "A1 B5" "A1 B5" ,
=(A1>B5; "A1 B5";"A1 B5").
|
|
.
. 1, 5 ,
=(A1>B5; A1; B5).
. , , .. , =5*(A1>B5;A1;B5)-24.
() ( ) . , 1, 2, 3, , , 1 . :
=(A1>B1;(A1>C1; "A1 ";
"1 "); "1 ").
, () . , , , , . , (). , , , 0.
(), (), (). .
ü (; ;...) , . .
ü (; ;...) , . .
ü () , . , .
. , , 1 ( ):
((A1>A2;A1>A3);"A1 ";"A1 ").
: , , .
((A2<0; A1<0; A3<0); ""; "").
, .
(), (), () , , . (). , , . , , ( , , , ). (), . , , -, . - , ,
((1; (2));((1);2)).
, , 1 2 0
(((A1>0;(A2>0));((A1>0);A2>0));"";"")
(((A1>0;A2<=0);(A1<=0;A2>0));"";""). /.
. , . , 1 2 0
=((A1>0)*(A2<=0)+(A1<=0)*(A2>0);"";"").
, ,
=(1*1+0*0;"";"")=(1;"";"")="",
|
|
1 ( ) Excel .
. , . , (1, 2, 3, 4) . , ,
=(((A1>0;A2<=0;A3<=0;A4<=0); (A1<=0;A2>0;A3<=0;A4<=0);
(A1<=0;A2<=0;A3>0;A4<=0); (A1<=0;A2<=0;A3<=0;A4>0)); ""; "").
. , , , . , , , , , , 1 (, (1>0;1)). , 1, . :
=((A1>0;1)+(A2>0;1)+(A3>0;1)+(A4>0;1)=1; "";"").
() , , , , . , () .
=((A1>0)+(A2>0)+(A3>0)+(A4>0)=1;"";"").
.
. , (/ ), , . , / ( ). , 150 200 , 55 100 .
=(<150 >200 <55 >100, , ).
. 4.7-1.
D2=((B2<150; B2>200; C2<55; C2>100);" ";""),
, . () () , , (/):
D2=((B2>=150;B2<=200;C2>=55;C2<=100);"";"")
A | B | C | D | |
. 4.7-1 |
. . , ( ) . ( ):
=(1; __1;
(2; __2;
(3; __3;
__3))).
(, 1) , (__1), 2 ..
=(1;__1;(2; __2; (3; __3; __3))).
|
|
. - Y(X)
A | B | C | D | E | F | G | H | I | J | K | L | M | |
X | -6 | -4 | -2 | ||||||||||
Y | -1 | ||||||||||||
. 4.7-2 |
5+ <0,
Y= 5 0£<10,
10-0,5X 10£.
-6 +16 2.
|
Y=(X<0;5+X;((0<=X;X<10);5;10-0,5*X))
Y
B2=(B1<0;5+B1;((0<=B1;B1<10);5;10-0,5*B1))
B2=(B1<0;5+B1;(B1<=10;5;10-0,5*B1)).
, () 1<0 , 1>=0. , .
, () , . , , (). , Excel . 4.7-2, . 4.7-3.
@ , .
. , , 1 ( , ).
: | 10% | 12% | 14% | 17% | 20% |
: | 10 | 20 | 30 | 40 | 40 |
, 10 . 10%, 10 20 . 12% .. , ,
=1*(1<10;10%; ((1>=10;1<20);12%;
((1>=20;1<30);14%; ((1>=30;1<40);17%;20%)))).
, (). , , >40, 20% . , . , , . , , , (<)
=1*(1<10;10%; (1<20;12%; (1<30;14%; (1<40;17%;20%))))
, (>.)
=1*(1>=40;20%; (1>=30;17%; (1>=20;14%; (1>=10;12%;10%)))).
, 1=25, ..
=25*(25>=40;20%; (25>=30;17%; (25>=20;14%; (25>=10;12%;10%)))).
1 40 30 . 1>=20 . 14% .
=25*(;20%; (;17%; (;14%; (25>=10;12%;10%)))) = 25*14%.
, , - ( ), . , , ( ).
=1*(1<10;10%;1)*((1>=10;1<20);12%;1)*((1>=20;1<30);14%;1)*
((1>=30;1<40);17%;1)*(1>=40;20%;1).
, . () . , 1 ( ) , . , 25 ., (, () ).
|
|
= 1*1*1*14%*1*1 =1*14%.
, :
=1*((1<10;10%;0)+ ((1>=10;1<20);12%;0)+ ((1>=20;1<30);14%;0)+
((1>=30;1<40);17%;0)+ (1>=40;20%;0)).
0 ()
=1*((1<10;10%)+((1>=10;1<20);12%)+...)).
( ): =1*(0+0+14%+0+0)=1*(14%).
, , , , , .
A | B | C | D | E | |
: | |||||
? | |||||
? | |||||
? | |||||
. 4.7-4 |
. . . 4.7-4 , , , ?.
, .
1. , 300 . 8 .
=(=, 300 ., 0 ).
: E3=(B3="";300;0). E3=(B3="";0;300).
2. , . , , , , . ( 1).
=(= =, 300 , 0 ),
E3=((B3="";B$1=3);300;0).
=(= ¹, 0 , 300 ),
E3=((B3="";B$1<>3);0;300).
3. , .
=((= =) (= =), 300, 0),
E3=(((B3="";B$1=3);(B3="";B$1=2));300;0).
E3=(((B3="";B$1<>3);(B3="";B$1<>2));0;300).
4. , -: 10% , 300 . . (0, 10% 300 .), ().
=(= =, 300 ,
(= =, 10% , 0 )),
E3=((B3="";B$1=3);300;((B3="";B$1=2);10%*3;0))
,
=(= =, 300 .)
+(= =, 10% ),
E3=((B3="";B$1=3);300)+((B3="";B$1=2);10%*C3).
. , , (, , )
I ((B3="";B$1=3);300)+((B3="";B$1=2);10%*C3) =0+0=0
II ((B3="";B$1=3);300) + 0 [300. ]
III 0 + ((B3="";B$1=2);10%*C3) [10% ].
5. , , , 500 . ( ).
=(= =, 300 )
+(= =, 10% )+(=,500 )),
E3=((B3="";B$1=3);300)+((B3="";B$1=2);10%*C3)+(B$1=1;500).
6. 200 ., , .
=(=; (*200>; ; *200;0)).
, = , 1 0
=(*200>; ; *200;0)*(=;1;0)
E3=(D3*200>C3;C3;D3*200)*(B3="";1;0).
E3=(D3*200>C3;C3;D3*200)*(B3="").
() (). E3=(D3*200;C3)*(B3="").
7. : 100 ., 150 ., 250 .,
=(=1;100; (=2;100+150; (>=3;100+150+250;0)))
E3=(D3=1;100; (D3=2;250; (D3>=3;500;0))).
, .
.
8. 500 . , 1000 .
9. 1 500 . , 1000 ., 20% .
10. , 800 .
+ | |||
+ | |||
+ | + | ||
+ | |||
+ | |||
+ | + | ||
+ | |||
+ | |||
+ | + | ||
. 4.7-5 |
. , , . 1 . , (, , ). , 1 20%, 8- 10%. 15%. 40%. , 12 (. 4.7-5). ( , , , +), , 11
__1_.=__1.*
((=1;¹+;¹+) 1-20%;
((=1;¹+;=+) 1-20%+40%;
((=1;=+;¹+) 1-20%+15%;
((=1;=+;=+) 1-20%+15%+40%;
((=8;¹+;¹+) 1-10%;
((=8;¹+;=+) 1-10%+40%;
((=8;=+;¹+) 1-10%+15%;
((=8;=+;=+) 1-10%+15%+40%;
((¹+;=+) 1+40%;
((=+;¹+) 1+15%;
((=+;=+) 1+15%+40%; 1))))))))))).
. , 1- 8- .
, . , () , .. . , , 100%
__1 = __1* (1+(=1, -20%, 0)
+(=+, 15%, 0) +(=+, 40%, 0) +(=8, -10%, 0)).
, 8- .
=__1*(1+0+15%+40%-10%)
=__1*(1+45%)=__1*145%.
, 4, D4, E4 , 2, Excel
=2*(1+(4=1;-20%)+(D4=+;15%)+(E4=+;40%)+(4=8;-10%)).
. , : 70%, 50%, 25%.
=_*(1-(, 70%, 0)-
(, 50%, 0)- (, 25%, 0)).
, 1, , 3, D3, E3. Excel
=1*(1-(3=;70%)-(D3=;50%)-(E3=;25%).
, , .
, 100% ( 145%), , , , . , 100%
=1*(1-((3=;70%)+(E3=;50%)+(D3=;25%); 100%)).
1 ( 100%) 100%. , 100%, =1*(1-100%)=0, =1*(1- ).
. ,
=1*(1-((3=;70%);(E3=;50%);(D3=;25%)).
: =1*(1- ).
. () () .
ü (; 1; 2;...) 1 29. :
(2;"";"";"")="",
(5;1;4;7;2)=#! , 5 (4).
, (B8;3;C4;C5).
ü ( ; [; ])
() , . ( ), . . . :
0 ( ).
1 , ( ) . . , 1.
A | B | C | D | E | F | |
. 4.8-1 |
-1 , . .
. , . 4.8-1.
:
(7;B2:F2;0)=4 2 ( ),
(10;B2:F2;0)=#/ ,
(20;B3:F3;1)=2 3 ( ),
(20;B4:F4;-1)=3 D4 ( ).
.
ü ( ; ; [; ])
. . . 1 ( ).
,