Seznam témat:
popis funkce
Popis funkce
Operátory
+
|
= 123 + B1
|
součet
|
-
|
= A5 - B1
|
rozdíl
|
*
|
= A2 * A3
|
násobek
|
/
|
= A1 / PI()
|
podíl
|
^
|
= 7 ^ 2
|
mocnina A^B
|
Logické operátory
=
|
= A1=A2
|
shoda pokud A1=A2 vrací True jinak False
|
<>
|
= A1<>B2
|
nerovnost pokud A1<>A2 vrací True jinak False
|
<
|
= A1<B1
|
je menší
|
>
|
= A1>100
|
je větší
|
<=
|
= A2<=C4
|
menší nebo rovno
|
>=
|
= A2>=123
|
větší nebo rovno
|
Trigonometrické, hyperbolické a jejich inverze
ACOS
|
=ACOS(B16)
|
arccos
|
ACOSH
|
=ACOSH(A1)
|
hyperbolic cos
|
ASIN
|
=ASIN(B6)
|
arcsine
|
ASINH
|
=ASINH(C2)
|
inverse hyperbolic sine of the argument
|
ATAN
|
=ATAN(C5)
|
arctangent
|
ATAN2
|
=ATAN2(A1; A2)
|
Returns the arctangent using x- and y- coordinates
|
ATANH
|
=ATANH(D4)
|
inverse hyperbolic tangent
|
COS
|
=COS(A1)
|
cos
|
COSH
|
=COSH(D7)
|
hyperbolic cosine
|
DEGREES
|
=DEGREES(PI()/2)
|
converts radians to degrees
|
RADIANS
|
=RADIANS(180)
|
Converts degrees to radians.
|
SIN
|
=SIN(A1)
|
sin
|
SINH
|
=SINH(1)
|
hyperbolic sine
|
TAN
|
=TAN(C3)
|
tangent
|
TANH
|
=TANH(0)
|
hyperbolic tangent
|
Exponenciální a logaritmické funkce
EXP
|
=EXP(C1)
|
exponent argumentu
|
FACT
|
=FACT(2)
|
factorial of the argument
|
LN
|
=LN(C1)
|
natural logarithm
|
LOG
|
=LOG(100, 10)
|
logarithm of a number to the specified base
|
LOG10
|
=LOG10(1000)
|
base-10 logarithm of the argument
|
POWER
|
=POWER(A1,4)
|
Raises the number to the base
|
SQRT
|
=SQRT(B5)
|
square root.
|
Absolutní hodnoty, znaménka
ABS
|
=ABS(B6)
|
Returns the absolute value
|
SIGN
|
=SIGN(A2)
|
Returns the sign
|
Zaokrouhlovací
CEILING
|
=CEILING(2,5; 1)
|
Rounds the first argument up to the nearest multiple based on the significance specified by the second argument.
|
COUNTIF
|
=COUNTIF(A1:A7;">2")
|
Counts the number of nonblank cells within a range which meet a given condition.
|
EVEN
|
=EVEN(-1)
|
Rounds the argument up to the nearest even integer
|
FLOOR
|
=FLOOR(-2,5; -2)
|
Rounds the first argument down, towards zero, to the nearest multiple of the significance specified by the second argument.
|
INT
|
=INT(E4)
|
Rounds the argument down to the nearest integer.
|
ROUND
|
=ROUND(20,57; 1)
|
Rounds the first argument to the specified number of digits.
|
ROUNDDOWN
|
=ROUNDDOWN(2,75;0)
|
Rounds the argument toward zero. The first argument specifies a number to round up. The second argument defines the number of digits to which you want to round the first argument.
|
ROUNDUP
|
=ROUNDUP(num;numd)
=ROUNDUP(-3,42;1)
|
num - Reálné číslo, které má být zaokrouhleno nahoru.
numd - Počet číslic, na které má být provedeno zaokrouhlení. Pokud má parametr numd (počet_číslic) zápornou hodnotu, bude číslo zaokrouhleno na číslice vlevo od desetinné čárky. Pokud má parametr numd (počet_číslic) hodnotu nula nebo je tato hodnota vynechána, bude číslo number zaokrouhleno na nejbližší celé číslo.
|
TRUNC
|
=TRUNC(PI())
|
Returns the integer part. Compare this with the Int function, which returns a double
|
Ostatní
MOD
|
=MOD(4,3)
|
Returns the remainder after the number is divided by the divisor.
|
ODD
|
=ODD(3.5)
|
Rounds the argument up to the nearest odd integer.
|
PI
|
=PI()
|
Returns the value of Pi
|
RAND
|
=RAND()
|
Returns a random number between 0 and 1.
|
SUM
|
=SUM(A1:C12)
=SUM(A1; 3,14; 1,57)
|
Sums all the values in the list.
|
SUMSQ
|
=SUMSQ(B1:D1)
=SUMSQ(1; 2; 3; 4)
|
Sums the square of values in the list
|
Související témata
Statistické funkce
Logické funkce
Stringové funkce
Datumové funkce
Formátovací funkce
|