Difference between revisions of "Documentation/How Tos/Calc: Mathematical functions"

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.

Difference between revisions of "Documentation/How Tos/Calc: Mathematical functions"

Revision as of 19:35, 13 April 2008

List of Calc Mathematicals

See also

Views

Personal tools

Navigation

Search

Tools

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