Difference between revisions of "Documentation/How Tos/Calc: Mathematical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
Line 2: | Line 2: | ||
{| border="0" cellpadding="0" cellspacing="10" align="left" | {| border="0" cellpadding="0" cellspacing="10" align="left" | ||
+ | |||
+ | |-valign="top" | ||
+ | |colspan="2"|'''<big> Trigonometric</big>''' | ||
+ | |||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: COSfunction|'''COS''']] | |[[Documentation/How_Tos/Calc: COSfunction|'''COS''']] | ||
Line 49: | Line 53: | ||
|[[Documentation/How_Tos/Calc: PI function|'''PI''']] | |[[Documentation/How_Tos/Calc: PI function|'''PI''']] | ||
|Returns the value of PI. | |Returns the value of PI. | ||
+ | |||
+ | |-valign="top" | ||
+ | |colspan="2"|'''<big> Hyperbolic</big>''' | ||
|-valign="top" | |-valign="top" | ||
Line 81: | Line 88: | ||
|[[Documentation/How_Tos/Calc: ATANH function|'''ATANH''']] | |[[Documentation/How_Tos/Calc: ATANH function|'''ATANH''']] | ||
|Returns the inverse hyperbolic tangent of a number. | |Returns the inverse hyperbolic tangent of a number. | ||
+ | |||
+ | |-valign="top" | ||
+ | |colspan="2"|'''<big> Rounding and remainders</big>''' | ||
|-valign="top" | |-valign="top" | ||
Line 129: | Line 139: | ||
|[[Documentation/How_Tos/Calc: MOD function|'''MOD''']] | |[[Documentation/How_Tos/Calc: MOD function|'''MOD''']] | ||
|Returns the remainder when one integer is divided by another. | |Returns the remainder when one integer is divided by another. | ||
+ | |||
+ | |-valign="top" | ||
+ | |colspan="2"|'''<big> Logarithm / powers</big>''' | ||
|-valign="top" | |-valign="top" | ||
Line 149: | Line 162: | ||
|[[Documentation/How_Tos/Calc: LOG10 function|'''LOG10''']] | |[[Documentation/How_Tos/Calc: LOG10 function|'''LOG10''']] | ||
|Returns the base-10 logarithm of a number. | |Returns the base-10 logarithm of a number. | ||
+ | |||
+ | |-valign="top" | ||
+ | |colspan="2"|'''<big> Miscellaneous</big>''' | ||
|-valign="top" | |-valign="top" |
Revision as of 22:09, 6 December 2007
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. |
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. |
COUNTBLANK | Returns the number of empty cells. |
COUNTIF | Counts the number of cells in a range that meet a specified condition. |
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*. |
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. |