, , , , . , ( Excel ).
:
1. .
2. .
, . , :
1 | 3 | 5 | 7 | 9 | 11 | 12 |
12.04.00 | 12.05.00 | 12.06.00 | 12.07.00 | 12.08.00 | 12.09.00 | 12.10.00 |
0 1/2 | 1 1/2 | 2 1/2 | 3 1/2 | |||
10% | 30% | 50% | 70% | 90% | 110% | 130% |
1- | 5- | 9- | 13- | 17- | 21- | 25- |
1 | 3 | 5 | 7 | 9 | 11 | 13 |
, .
A | B | C | D | E | |
1 | 3 | ||||
12.04.00 | 12.05.00 | ||||
0 ½ | |||||
10% | 30% | ||||
1- | 5- | ||||
1 | 3 |
2.1.
, 2.1., , .
. , . , . , , .
2.8. ""
Excel () , "=" (). , , Excel , , . , , . , , (. . 2).
2 | u | = | =3*__1 | |||||||||||||||
A | B | C | D | E | ||||||||||||||
4
| ||||||||||||||||||
. 2.2
, . , : , , . F4: F4 , . .
Excel : , , .
. (. . 2.2). "\" ( ) VBA ( ).
2.2
+ () | |
- () | |
- () | |
* () | |
/ ( ) | |
% () | |
^ () |
:
1.
2.
3.
4.
. Excel &, .
. Excel (. . 2.3).
2.3
= | |
< | ) |
<= | |
> | |
>= | |
<> |
. Excel (. . 2.4).
2.4
: () | 5:10 | |
, () | 4,5 ( ) | |
() | 1:5 3:3 ( 3) |
Excel A1, A IV (256 ), 1 65536. . , D50 , D 50- . , , / ($).
, :
4,
$F$3,
$F5 $3.
, .
|
|
( ) , . : Þ Þ ; .