:
19 - , , , , .. , . 19 .
19 - Microsoft Excel.
:
1. =
2. ( ), (+, -, *, /, ^), .
3. , () ; .
4. .
5. , . .
. 19 :
(1; 2; )
: =(153;2111), =(A2:A4), =(A2:A4;15), = (A5; A6;2)
(1; 2; )
: = (1; 2; 3), =(2:6), =(2:6;100)
(1; 2; ) -
: = (1; 2; 3), =(A2:A8), =(A2:A8;33)
(1; 2; ) ()
: = (1; 2; 3), =(A2:A6), =(A2:A6;5)
(_1; _2; ) - , ; , .
- , , .
: =(2+2=4;2+3=5) (1), = (1<A2; A2<100), =(; ) (0)
(_1; _2;) - , ; , .
- , , .
: =(1+1=1;2+2=5) (0), =(A2>12; B2<100)
(_) - . , , .
- , , .
: =(1+1=2) (0), =(10<8) (1), =(1=5)
(_; 1; 2) - .
|
|
_ , , .
_ , , , 1, - 2.
: =(D3>270; ; ) ( ) 270
=((2>90; 2>85);1;0) - ( ) ( ) 90 ( ) 85
ר (; ) - , .
: =(A2:A55; ), =(B22:B122;>55)
(; ; _) - , .
.
, , .
_ ; _ , .
: , ? ( 370 )
A | B | C | D | E | F | G | |
1 | |||||||
1 | |||||||
1 | |||||||
1 |
G2 =(B2:B371;""; F2:F371)
.
. , ( 2) ( )
( - , - ) ( - , - ).
: , , , . , , .
A | B | C | D | E | F | G | H | I | |
. 1 | . 2 | . 3 | . 4 | ||||||