OpenOffice.org Calc 3. Mathematical
Functions
- ABS(number) Function
-
ACOS(number) Function
-
ACOSH(number)
Function
- ACOT(number) Function
- ACOTH(number) Function
-
ASIN(number) Function
-
ASINH(number)
Function
-
ATAN(number) Function
-
ATAN2(number_x;
number_y) Function
-
ATANH(number)
Function
-
CEILING(Number;
Significance; Mode) Function
- COMBIN(number_1; number_2) Function
- COMBINA(number_1; number_2) Function
- CONVERT(value; text1; text2) Function
- COS(Number) Function
-
COSH(number) Function
- COT(number) Function
-
COTH(number) Function
-
COUNTBLANK(range) Function
-
COUNTIF(range;
criteria) Function
-
DEGREES(number)
Function
-
EVEN(number) Function
- EXP(number) Function
-
FACT(number) Function
-
FLOOR(Number;
Significance; Mode) Function
- GCD(Integer 1; Integer2; ...) Function
-
GCD_ADD(number 1;
number2; ...) Function
- INT(number) Function
-
ISEVEN(value)
Function
-
ISODD(value) Function
- LCM(Integer 1; Integer 2; ...) Function
-
LCM_ADD(number1;
number2; ...) Function
- LN(number) Function
- LOG(Number; Base) Function
-
LOG10(number)
Function
- MOD(Dividend; Divisor) Function
-
MROUND(Number;
Multiple) Function
- MULTINOMIAL(number1; number2; ...) Function
- ODD(number) Function
- PI() Function
-
POWER(Base; Exponent)
Function
-
PRODUCT(number 1;
number 2; ...) Function
-
QUOTIENT(Numerator; Denominator) Function
-
RADIANS(Number)
Function
-
RAND() Function
-
RANDBETWEEN(Bottom; Top) Function
-
ROUND(number; count)
Funcion
-
ROUNDDOWN(number;
count) Function
-
ROUNDUP(number;
count) Function
- SERIESSUM(X; N; M; Coefficients) Function
-
SIGN(number) Function
- SIN(number) Function
-
SINH(number) Function
-
SQRT(number) Function
-
SQRTPI(number)
Function
-
SUBTOTAL(Function;
Range) Function
- SUM(Number1; Number2; ...) Function
-
SUMIF(range;
criteria; sum_range) Function
-
SUMSQ(number 1;
number2; ...) Function
- TAN(number) Function
-
TANH(number) Function
-
TRUNC(number; count)
Function
Back to the list of
functions