ABS | , | = ABS(-123,89) = 123,89 | |
EXP | =2,71828182... | = () = 20,08553692 | |
LN | (>0) | = LN(1) = 0 = LN(2) = 0,693147 LN(100) = 4,60517 | |
LOG10 | = LOG10(100) = 2 = LOG10(0,1) = -1 | ||
LOG | . >0 #1; Excel 10 | = LOG(10) = 1 = LOG(8;2) = 3 = LOG(100; 2,71828...) = 4,60517 | |
(SUM) | 30 , , , , , | 54 (. 8.3) , 1:5, 1:. 5 15 | |
(POWER) | =(5;2)=25 =(4;1/2)=2 =(4;-1/2)=0,5 =(6,25;1,5)= 15,625 | ||
(PRODUCT) | 30 | , , , , ; | 5 1:5 (. 8.4) |
(SORT) | 0 | = (25) = 5 = KOPEH(ABS(-9)) = 3 | |
(SUMIF) | , | , (. 8.5). >10 2:5. , 6, 60 (25+15+20). >10, , 6. 12 (5+3+4) | |
(SUMSQ) | , .. | , | 5 , 1:4 (. 8.6). 264 (4+0+16+225+9+1+0+9) |
D | E | ||||
=(1:5;1;1:4) | |||||
. 8.3.
D | E | ||||
>3 | |||||
= (1:5) | |||||
|
|
. 8.4.
1,2 | ||
=(2:5; >10) | =(2:5; >10;2:5) | |
. 8.5.
=(1:4) |
. 8.6.
(ODD) | = (2,36) 3 = (0,1) 1 = (-2,1) -3 | |
(ROUND) | = (4,15;1) 4,2 = (1,237;1) 1,2 = (1,5;0)2 = (42,5;-1) 40 | |
(ROUNDDOWN) | , , | - |
(ROUNDUP) | , , | - |
(TRUNC) | , , | = (8,365;1) 8,3 = TRUNC(-1,567) -1 |
(INT) | 1,5 = (1,5) = 1 123,567 = (123,567) =123 -5,5 = INT(-5,5) = -6 |
. 1:5 2:5 . C2:D5 (. 8.7).
D | ||||
4,15 | 4,1 | 4,2 | ||
1,237 | 1,2 | 1,3 | ||
1,5 | ||||
42,5 | -1 |
. 8.7.