Mathematical functions

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 16:21, 1 February 2024 by DiGro (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

List of Calc Mathematical functions

COS Returns the cosine of an angle.
SIN Returns the sine of an angle.
TAN Returns the tangent of an angle.
COT Returns the cotangent of an angle.
ACOS Returns the inverse cosine of a number.
ACOT Returns the inverse cotangent of a number.
ASIN Returns the inverse sine of a number.
ATAN Returns the inverse tangent of a number.
ATAN2 Returns the inverse tangent for specified x and y coordinates.
DEGREES Converts radians into degrees.
RADIANS Converts degrees into radians.
PI Returns the value of PI.
COSH Returns the hyperbolic cosine of an angle.
SINH Returns the hyperbolic sine of an angle.
TANH Returns the hyperbolic tangent of an angle.
COTH Returns the hyperbolic cotangent of a given number (angle).
ACOSH Returns the inverse hyperbolic cosine of a number.
ACOTH Returns the inverse hyperbolic cotangent of the given number.
ASINH Returns the inverse hyperbolic sine of a number.
ATANH Returns the inverse hyperbolic tangent of a number.
Rounding and remainders
TRUNC Truncates a number by removing decimal places.
ROUND Rounds a number to a certain precision.
ROUNDDOWN Rounds a number down, toward zero, to a certain precision.
ROUNDUP Rounds a number up, away from zero, to a certain precision.
CEILING Returns a number rounded up to a multiple of another number.
FLOOR Rounds a number down to the nearest multiple of another number.
EVEN Rounds a number to the next even integer away from zero.
ODD Rounds a number up to the next highest odd integer.
MROUND Returns a number rounded to the nearest multiple of another number.
INT Rounds a number down to the nearest integer.
QUOTIENT Returns the integer result of a division operation.
MOD Returns the remainder when one integer is divided by another.
Logarithm / powers
EXP Returns e raised to the power of a number.
POWER Returns a number raised to a power.
LOG Returns the natural logarithm of a number.
LN Returns the logarithm of a number to the specified base.
LOG10 Returns the base-10 logarithm of a number.
Bessel functions
BESSELI Calculates the modified Bessel function of the first kind.
BESSELJ Calculates the Bessel function of the first kind.
BESSELK Calculates the modified Bessel function of the second kind.
BESSELY Calculates the Bessel function of the second kind (the Neumann or Weber function).
ABS Returns the absolute value of a number.
COMBIN Returns the number of combinations of a subset of items.
COMBINA Returns the number of ordered combinations of a subset of items.
CONVERT Converts between legacy European currencies and Euros.
CONVERT_ADD Converts a number from one measurement system to another.
COUNTBLANK Returns the number of empty cells.
COUNTIF Counts the number of cells in a range that meet a specified condition.
DELTA Returns 1 if two numbers are equal, and 0 otherwise.
ERF Calculates the error function (Gauss error function).
ERFC Calculates the complementary error function (complementary Gauss error function).
FACT Returns the factorial of a number, n!.
FACTDOUBLE Returns the double factorial of a number, n!!.
GCD Returns the greatest common divisor of two or more integers.
GCD_ADD Returns the greatest common divisor of a list of numbers.
GESTEP Returns 1 if a number is greater than or equal to a step number, or 0 otherwise.
ISEVEN Returns TRUE if the value is an even number.
ISODD Returns TRUE if the value is an odd number.
LCM Returns the least common multiple of one or more integers.
LCM_ADD Returns the lowest common multiple of a list of numbers.
MULTINOMIAL Returns the factorial of the sum divided by the product of the factorials.
PRODUCT Multiplies all the numbers given as arguments and returns the product.
RAND Returns a random number between 0 and 1.
RANDBETWEEN Returns an integer random number in a specified range.
SERIESSUM Sums the first terms of a power series.
SIGN Returns the sign of a number.
SQRT Returns the positive square root of a number.
SQRTPI Returns the square root of (PI times a number).
SUBTOTAL Returns SUM, AVERAGE, STDDEV, etc. results for filtered data.
SUM Sums the contents of cells.
SUMIF Conditionally sums the contents of cells in a range.
SUMSQ Returns the sum of the squares of numbers.

See Also
Retrieved from ""
Personal tools
In other languages