Difference between revisions of "Documentation/How Tos/Calc: Mathematical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
Line 1: | Line 1: | ||
− | ==List of Calc | + | ==List of Calc Mathematicals== |
{| border="0" cellpadding="0" cellspacing="10" align="left" | {| border="0" cellpadding="0" cellspacing="10" align="left" | ||
Line 7: | Line 7: | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion COS|'''COS''']] |
|Returns the cosine of an angle. | |Returns the cosine of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion SIN|'''SIN''']] |
|Returns the sine of an angle. | |Returns the sine of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion TAN|'''TAN''']] |
|Returns the tangent of an angle. | |Returns the tangent of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion COT|'''COT''']] |
|Returns the cotangent of an angle. | |Returns the cotangent of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ACOS|'''ACOS''']] |
|Returns the inverse cosine of a number. | |Returns the inverse cosine of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ACOT|'''ACOT''']] |
|Returns the inverse cotangent of a number. | |Returns the inverse cotangent of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ASIN|'''ASIN''']] |
|Returns the inverse sine of a number. | |Returns the inverse sine of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ATAN|'''ATAN''']] |
|Returns the inverse tangent of a number. | |Returns the inverse tangent of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ATAN2|'''ATAN2''']] |
|Returns the inverse tangent for specified x and y coordinates. | |Returns the inverse tangent for specified x and y coordinates. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion DEGREES|'''DEGREES''']] |
|Converts radians into degrees. | |Converts radians into degrees. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion RADIANS|'''RADIANS''']] |
|Converts degrees into radians. | |Converts degrees into radians. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion PI|'''PI''']] |
|Returns the value of PI. | |Returns the value of PI. | ||
Line 58: | Line 58: | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion COSH|'''COSH''']] |
|Returns the hyperbolic cosine of an angle. | |Returns the hyperbolic cosine of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion SINH|'''SINH''']] |
|Returns the hyperbolic sine of an angle. | |Returns the hyperbolic sine of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion TANH|'''TANH''']] |
|Returns the hyperbolic tangent of an angle. | |Returns the hyperbolic tangent of an angle. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion COTH|'''COTH''']] |
|Returns the hyperbolic cotangent of a given number (angle). | |Returns the hyperbolic cotangent of a given number (angle). | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ACOSH|'''ACOSH''']] |
|Returns the inverse hyperbolic cosine of a number. | |Returns the inverse hyperbolic cosine of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ACOTH|'''ACOTH''']] |
|Returns the inverse hyperbolic cotangent of the given number. | |Returns the inverse hyperbolic cotangent of the given number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ASINH|'''ASINH''']] |
|Returns the inverse hyperbolic sine of a number. | |Returns the inverse hyperbolic sine of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ATANH|'''ATANH''']] |
|Returns the inverse hyperbolic tangent of a number. | |Returns the inverse hyperbolic tangent of a number. | ||
Line 93: | Line 93: | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion TRUNC|'''TRUNC''']] |
|Truncates a number by removing decimal places. | |Truncates a number by removing decimal places. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ROUND|'''ROUND''']] |
|Rounds a number to a certain precision. | |Rounds a number to a certain precision. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ROUNDDOWN|'''ROUNDDOWN''']] |
|Rounds a number down, toward zero, to a certain precision. | |Rounds a number down, toward zero, to a certain precision. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ROUNDUP|'''ROUNDUP''']] |
|Rounds a number up, away from zero, to a certain precision. | |Rounds a number up, away from zero, to a certain precision. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion CEILING|'''CEILING''']] |
|Returns a number rounded up to a multiple of another number. | |Returns a number rounded up to a multiple of another number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion FLOOR|'''FLOOR''']] |
|Rounds a number down to the nearest multiple of another number. | |Rounds a number down to the nearest multiple of another number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion EVEN|'''EVEN''']] |
|Rounds a number to the next even integer away from zero. | |Rounds a number to the next even integer away from zero. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ODD|'''ODD''']] |
|Rounds a number up to the next highest odd integer. | |Rounds a number up to the next highest odd integer. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion MROUND|'''MROUND''']] |
|Returns a number rounded to the nearest multiple of another number. | |Returns a number rounded to the nearest multiple of another number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion INT|'''INT''']] |
|Rounds a number down to the nearest integer. | |Rounds a number down to the nearest integer. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion QUOTIENT|'''QUOTIENT''']] |
|Returns the integer result of a division operation. | |Returns the integer result of a division operation. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion MOD|'''MOD''']] |
|Returns the remainder when one integer is divided by another. | |Returns the remainder when one integer is divided by another. | ||
Line 144: | Line 144: | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion EXP|'''EXP''']] |
|Returns e raised to the power of a number. | |Returns e raised to the power of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion POWER|'''POWER''']] |
|Returns a number raised to a power. | |Returns a number raised to a power. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion LOG|'''LOG''']] |
|Returns the natural logarithm of a number. | |Returns the natural logarithm of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion LN|'''LN''']] |
|Returns the logarithm of a number to the specified base. | |Returns the logarithm of a number to the specified base. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion LOG10|'''LOG10''']] |
|Returns the base-10 logarithm of a number. | |Returns the base-10 logarithm of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |colspan="2"|'''<big> | + | |colspan="2"|'''<big> Bessels</big>''' |
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion BESSELI|'''BESSELI''']] |
− | |Calculates the modified Bessel | + | |Calculates the modified Bessel of the first kind. |
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion BESSELJ|'''BESSELJ''']] |
− | |Calculates the Bessel | + | |Calculates the Bessel of the first kind. |
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion BESSELK|'''BESSELK''']] |
− | |Calculates the modified Bessel | + | |Calculates the modified Bessel of the second kind. |
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion BESSELY|'''BESSELY''']] |
− | |Calculates the Bessel | + | |Calculates the Bessel of the second kind (the Neumann or Weber). |
|-valign="top" | |-valign="top" | ||
Line 186: | Line 186: | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ABS|'''ABS''']] |
|Returns the absolute value of a number. | |Returns the absolute value of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion COMBIN|'''COMBIN''']] |
|Returns the number of combinations of a subset of items. | |Returns the number of combinations of a subset of items. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion COMBINA|'''COMBINA''']] |
|Returns the number of ordered combinations of a subset of items. | |Returns the number of ordered combinations of a subset of items. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion CONVERT|'''CONVERT''']] |
|Converts between legacy European currencies and Euros. | |Converts between legacy European currencies and Euros. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion CONVERT_ADD|'''CONVERT_ADD''']] |
|Converts a number from one measurement system to another. | |Converts a number from one measurement system to another. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion COUNTBLANK|'''COUNTBLANK''']] |
|Returns the number of empty cells. | |Returns the number of empty cells. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion COUNTIF|'''COUNTIF''']] |
|Counts the number of cells in a range that meet a specified condition. | |Counts the number of cells in a range that meet a specified condition. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion DELTA|'''DELTA''']] |
|Returns 1 if two numbers are equal, and 0 otherwise. | |Returns 1 if two numbers are equal, and 0 otherwise. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ERF|'''ERF''']] |
− | |Calculates the error | + | |Calculates the error (Gauss error). |
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ERFC|'''ERFC''']] |
− | |Calculates the complementary error | + | |Calculates the complementary error (complementary Gauss error). |
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion FACT|'''FACT''']] |
|Returns the factorial of a number, n!. | |Returns the factorial of a number, n!. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion FACTDOUBLE|'''FACTDOUBLE''']] |
|Returns the double factorial of a number, n!!. | |Returns the double factorial of a number, n!!. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion GCD|'''GCD''']] |
|Returns the greatest common divisor of two or more integers. | |Returns the greatest common divisor of two or more integers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion GCD_ADD|'''GCD_ADD''']] |
|Returns the greatest common divisor of a list of numbers. | |Returns the greatest common divisor of a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion GESTEP|'''GESTEP''']] |
|Returns 1 if a number is greater than or equal to a step number, or 0 otherwise. | |Returns 1 if a number is greater than or equal to a step number, or 0 otherwise. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ISEVEN|'''ISEVEN''']] |
|Returns TRUE if the value is an even number. | |Returns TRUE if the value is an even number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion ISODD|'''ISODD''']] |
|Returns TRUE if the value is an odd number. | |Returns TRUE if the value is an odd number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion LCM|'''LCM''']] |
|Returns the least common multiple of one or more integers. | |Returns the least common multiple of one or more integers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion LCM_ADD|'''LCM_ADD''']] |
|Returns the lowest common multiple of a list of numbers. | |Returns the lowest common multiple of a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion MULTINOMIAL|'''MULTINOMIAL''']] |
|Returns the factorial of the sum divided by the product of the factorials. | |Returns the factorial of the sum divided by the product of the factorials. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion PRODUCT|'''PRODUCT''']] |
|Multiplies all the numbers given as arguments and returns the product. | |Multiplies all the numbers given as arguments and returns the product. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion RAND|'''RAND''']] |
|Returns a random number between 0 and 1. | |Returns a random number between 0 and 1. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion RANDBETWEEN|'''RANDBETWEEN''']] |
|Returns an integer random number in a specified range. | |Returns an integer random number in a specified range. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion SERIESSUM|'''SERIESSUM''']] |
|Sums the first terms of a power series. | |Sums the first terms of a power series. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion SIGN|'''SIGN''']] |
|Returns the sign of a number. | |Returns the sign of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion SQRT|'''SQRT''']] |
|Returns the positive square root of a number. | |Returns the positive square root of a number. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion SQRTPI|'''SQRTPI''']] |
|Returns the square root of (PI times a number). | |Returns the square root of (PI times a number). | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion SUBTOTAL|'''SUBTOTAL''']] |
|Returns SUM, AVERAGE, STDDEV, etc. results for filtered data. | |Returns SUM, AVERAGE, STDDEV, etc. results for filtered data. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion SUM|'''SUM''']] |
|Sums the contents of cells. | |Sums the contents of cells. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion SUMIF|'''SUMIF''']] |
|Conditionally sums the contents of cells in a range. | |Conditionally sums the contents of cells in a range. | ||
|-valign="top" | |-valign="top" | ||
− | |[[ | + | |[[OOoES/Traduccion/Calc: Funcion SUMSQ|'''SUMSQ''']] |
|Returns the sum of the squares of numbers. | |Returns the sum of the squares of numbers. | ||
Line 315: | Line 315: | ||
==See also== | ==See also== | ||
− | '''[[ | + | '''[[OOoES/Traduccion/Calc: Funcion Functions listed by category|Functions listed by category]]''' |
Revision as of 19:35, 13 April 2008
List of Calc Mathematicals
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. |
Bessels | |
BESSELI | Calculates the modified Bessel of the first kind. |
BESSELJ | Calculates the Bessel of the first kind. |
BESSELK | Calculates the modified Bessel of the second kind. |
BESSELY | Calculates the Bessel of the second kind (the Neumann or Weber). |
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 (Gauss error). |
ERFC | Calculates the complementary error (complementary Gauss error). |
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. |