"". , , . Excel .
(< >) .
: ("1232,56")= 1232,56.
(< >; < >) < > , < > .
: (2,715;"00,00")="02,72",
("25.3.98";"")="".
: F2 (), ( m) ( ""). , 1 12 ( ), ( ).
(< >[;< >])
< > . , .
: (12345,678; 2)="12345,68",
(12345,678; -3)="12000".
(< >)
.
: (" Enter")=13.
(< >)
( ) .
: (" 1 ")= "1 ",
(" ")&""= "".
(< 1 >;< 2 >) . , , . , . .
: ("";"")=,
("";"")=,
("";" ")=.
(< ; < , >[;< ;])
, < > . < > , . < > , 1 ( ).
: ("";"")=6.
(< >;< , > [;< >])
, < > (? * ). .
|
|
, 12 , ..
("*.";12)
1, , , .. #!, .
(< >;< >)
< > < >.
: (" ";6)= "".
(< >;< >) < > < >.
: (" ";7)= " ".
(< >;< >;< >)
, < > < >. . < > , , .
: (" ";3;5)= "".
(< 1 >;< 2 >;...)
, . &.
: (" ";"")=" ".
(< >) <> .
: (". ")=". ".
(<>) <> .
: (". ")= ". ".
.
1. .
1. 1 "", 1 "", 1 "" ( !). 2 " ". 2 =1&" "&1&" "&C1. [1] , , , " ". 1 "". 2.
2. 2 . . : 2 ( . ), , , 2 , ( ), " ".
3. 2, , . A3 =(2). , . - . .
4. A3 : , . , , .
, . 4 =(" ",). [2] " ", , , A3, , . 4 =(" ",,4+1), .. , , . 4 =(3). : 7, 15, 23.
|
|
(, _, _) , , . 5, 6, 7 "", "", "". 85 =(,1,4-1), 6 =(,4+1,4-4-1), 7 =(,4+1,4-4).
. 5:7 ( ).
5. 2 : " ". , . : " ". , . 1.
#! |
.1
. ? ( ), , , . 6
=((4),(,4+1,4-4), (, 4+1.4-4-1)).
7
=((4),"",(,4+1,4-4)).
6 . , .
=((4),
(.4+1,4-4), (.4+1, 4-4-1)).
, Alt+Enter , (Enter ). , .
6. 4 5 , , , Excel. 10 " ". "/ ". . , " ", , . "". 10, 10, 10.
1.
10, 10, 10 "", "", "". D10 , " ..". ( .)
2.
, :
10 "", 10 "", 10 . ( .)
3.
(. 2).
255-377-421 |
34-442-37 |
7583-81-344 |
.2
, . :
1) ;
2) "/ ".
4.
, , , "". : ""?
1. . , .
. , , , . , Excel , . VBA.
|
|
5.
. , . ( .)
. .
2.
, () ? F3 12, G3 14, G4 = F3 & G3. 1214. (): G5 =(G4). 0. ! G4 ? : G6 = G4*1. 1214. . Excel G4 ; .
. F8:F10 ; '10, '12 '15, ? G8 1; "" (Ctrl+C); F8:F10; " "; "", "", Esc.
.
3.
( 1) :
ZBNWQ
( , , ). , .
. 1
=(((1,1,3)*1),
((1,(1) -3)),
(((1,1,2)*1),
((1,(1) -2)),
((1,(1) -1))))
. - , . , , ,
6.
( ). : "", "", "" (, "42 "; , 11 14 ""),
2. . .
7.
2:10 , (, 2 "1,2,4", A3 " 1,3,6" ..). 1 , 2. 2:10 , "" "" , 1 ( 2 "", 3 ""). 11 2:10, .
[1] & () () .
[2] .