=((:;2):(:;()-1)).
: , , 2, , ()-1 , . . .
, .
4.17.
. Excel. , F(X)
Y=SIN(X) Y1=SIN(X)*COS(5*X).
. 4.17-2 0,3 0 6,3, Y(X), Y1(X). , 2,
B2=SIN(A2)
C2=SIN(A2)*COS(5*A2).
. , ( D2)
=+ 3=A2+$D$2.
, ( =0,3). . 4.17-3 , Excel.
. . , , , ..
( . 4.18-4), . :
, 20%- , ,
10%, ,
.
, . . 4.17-5, ( ) .
, .
DX=max-min, =DX-10%*DX,
=Xmin+20%*DX.
X=(max-min)-10%*(max-min)
=(max-min)*(1-10%),
X=min+20%*(max-min).
2
2=(B2>((B$2:B$5)-(B$2:B$5))*90%;"";
(B2>(B$2:B$5)+20%*((B$2:B$5)-(B$2:B$5));"";"")).
A | B | C | D | A | B | C | D | |||
N | N | |||||||||
. 4.17-6 |
. - . , . , , . , . , ( 0). , (, , ) . . 4.17-6 -, , (, ).
|
|
A | B | C | D | E | |
... | |||||
. 4.18 | -7 | ||||
A | B | ||||
: | 4 345 103,2 | ||||
: | . . . 20 | ||||
. 4.17 | -8 |
, , , , .
A2=(C2>0;
ר(C$1:C2;">0");""),
D7=(C2:C6;D2:D6).
- . , (. ) , , .
. ( 9 999 999 .), , .
. ( ) (. 4.17-7) . , 0 99 ( ), 0 9 ( ). , , . : 3:102 ( ), D3:E12 ( ). , . . 4.17-7 1 , 2 . . 4.17-9. , &. ( ) , . . ( ). . . ., . . , - ( , ), (). , , (). . , 1, (B1; "0000000,00"), (). ((B1; "0000000,00");1;1) , (.. ). (), , (), . , 4 345 103,2 "".
|
|
. 1 99 . , . 1 19, , . . . . , , . :
, , , , , ..
, , , , ..
D , . D24=B24&C24, .
D , (+ ++).