MS Excel Word. , . , Excel Word (, , , Word , Excel ). , , Word, . . . , . . "" "". , Word, (, , " ", "").
Excel ( "" [Ctrl] + [Z]) , . , Word .
Excel , ( ). Word , , , , , , , ..
, , Excel, , Word.
MS Excel
MS Excel . .
MS Excel "=". .
1) ; "=";
2) , :
=+ ( );
=- ( );
=* ( );
=/ ( );
=A<B, =A<=B, =A=B, =A<>B, =A>B, =A>= ( );
, ( , ), ;
3) .
( > > "").
, , . :
|
|
#/0! | |
#! | () |
#? | (, ) , , |
#! | (, ) |
MS Excel , "", " ". , . , MS Excel, , , , . :
, | , | , MS Excel |
=(A1+B1)/C1 | =(A1+B1/C1 | =(A1+B1/C1) |
, , MS Excel , . .
, , , . , "", . "".
( ) . , . , , () (), , : , .
"" ( [-2;2] 0,2):
A | B | C | |
xn | xk | h | |
-2 | 0,2 | ||
x | y | ||
=A2 | =(A4=0;0;EXP(LN(ABS(A4))/3)*A4/ABS(A4)) | ||
=A4+C$2 | =(A5=0;0;EXP(LN(ABS(A5))/3)*A5/ABS(A5)) | ||
=A5+C$2 | =(A6=0;0;EXP(LN(ABS(A6))/3)*A6/ABS(A6)) | ||
=A23+C$2 | =(A24=0;0;EXP(LN(ABS(A24))/3)*A24/ABS(A24)) |
, C$2; . , (, $C2). , , ( $C$2), .