Excel
, , , . .
(; __; __ )
- , .
__ , , .
__ , , .
:
7- __ __, , .
:
1. .
:
(B2>C2; "!"; "OK"), D2, . :
2. :
89 A
³ 80 89 B
³ 70 79 C
³ 60 69
60 F
:
(>89;"A";(>79;"B";
(>69;"C";(>59;"D";"F"))))
3. (, , ) :
2:
(D2<10;C2*D2*1,11;(D2<30;C2*D2*1,07;C2*D2*1,04))
F2:
(D2<10;"11%";(D2<30;"7%";"4%"))
:
, , .
(1; 2; )
1, 2, 1 30 , , .
(; )
(; )
(2+2=4; 2+3=5)
³ B1:B3 , , , :
(B1:B3)
B4 1 100, :
(1<B4; B4<100) .
4, 1<<100 " ", . 4 156, :
((1<B4; B4<100); B4; " ") " ",
50, :
((1<B4; B4<100); B4; " ") 50
, ; , .
|
|
(1; 2; )
:
()
(1+1=1;2+2=5)
³ 1:3 , , , :
(A1:A3)
. "" "s", ʳ:
(( ²()="c"; ²()="s"); (ʳ ))
.
()
.
()
. , , .
()
:
()
(1+1=2)
?