Documentation/How Tos/Calc: Mathematical functions
From Apache OpenOffice Wiki
< Documentation | How Tos
- Mathematical Functions
Trigonometric
Hyperbolic
Rounding and remainders
Logarithm/Powers
Bessel functions
Miscellaneous
List of Calc Mathematical functions
Trigonometric | |
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. |
Hyperbolic | |
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). |
Miscellaneous | |
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