(, IF) '
1. .
2. .
3. .
1. . (, IF), :
(< >; < 1>; < 2>).
: .
, , .
1 2 . 1 2 , .
, =, >, <, <=, >=% <>, , , 7>5, 5<=20 .
|(< 1>;<2>;...) (<1>;<2>;...).
(, AND) , .
(, OR) , .
, ((5>7; 5<7); 5; 7) 5, ( (5>7; 5<7); 5; 7) 7.
' , , ð. ( 1) ( 2).
Excel, (ѭ, , ) (IF, AND, OR) .
.
- , : 1, 2, 3. :
|
. , ( ) 21% . (. .1).
|
ճ
, , .
.
3. (. . 1, ).
|
|
, , , D, ', (1, 2, 3) 31.
1 ³
1 =() =TODAY()
:
2 :
D2 8
2 10
F2 12
G2 0,21
A3
3
3
D3
F3
G3 ³
4 1
4 < 1>
4 < : 1, 2 3>
D4 < >
5 2
B5 < >
5 < >
D5 < >
.. ( )
4. ' :
4 = (C4=1;$D$2; (4=2; $$2; $F$2))
F4 = D4 * 4
G4 = F4 * $G$2
4 = F4 - G4