Difference between revisions of "Documentation/How Tos/Calc: Mathematical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also) |
|||
| Line 315: | Line 315: | ||
==See also== | ==See also== | ||
| − | '''[[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category | + | [[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']], |
| + | [[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']] | ||
Revision as of 16:12, 13 September 2008
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
Functions listed alphabetically, Functions listed by category
