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

From Apache OpenOffice Wiki
Jump to: navigation, search
(23 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
==List of Calc Mathematicals==
+
{{Documentation/MasterTOC
 +
|bookid=1234'''
 +
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">[[Documentation/Reference/Calc_functions|CALC FUNCTIONS]]</div>
 +
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Mathematical_functions|<div style="font-size: 140%;">Mathematical Functions]]
 +
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_COS_function
 +
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_TRUE_function
 +
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Logical_functions
 +
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Number_Conversion_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Trigonometric</div>
 +
* [[Documentation/How_Tos/Calc:_COS_function|<div style="font-size: 120%;">Cos]]
 +
* [[Documentation/How_Tos/Calc:_SIN_function|<div style="font-size: 120%;">Sin]]
 +
* [[Documentation/How_Tos/Calc:_TAN_function|<div style="font-size: 120%;">Tan]]
 +
* [[Documentation/How_Tos/Calc:_COT_function|<div style="font-size: 120%;">Cot]]
 +
* [[Documentation/How_Tos/Calc:_ACOS_function|<div style="font-size: 120%;">Acos]]
 +
* [[Documentation/How_Tos/Calc:_ACOT_function|<div style="font-size: 120%;">Acot]]
 +
* [[Documentation/How_Tos/Calc:_ASIN_function|<div style="font-size: 120%;">Asin]]
 +
* [[Documentation/How_Tos/Calc:_ATAN_function|<div style="font-size: 120%;">Atan]]
 +
* [[Documentation/How_Tos/Calc:_ATAN2_function|<div style="font-size: 120%;">Atan2]]
 +
* [[Documentation/How_Tos/Calc:_DEGREES_function|<div style="font-size: 120%;">Degrees]]
 +
* [[Documentation/How_Tos/Calc:_RADIANS_function|<div style="font-size: 120%;">Radians]]
 +
* [[Documentation/How_Tos/Calc:_PI_function|<div style="font-size: 120%;">Pi]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Hyperbolic</div>
 +
* [[Documentation/How_Tos/Calc:_COSH_function|<div style="font-size: 120%;">Cosh]]
 +
* [[Documentation/How_Tos/Calc:_SINH_function|<div style="font-size: 120%;">Sinh]]
 +
* [[Documentation/How_Tos/Calc:_TANH_function|<div style="font-size: 120%;">Tanh]]
 +
* [[Documentation/How_Tos/Calc:_COTH_function|<div style="font-size: 120%;">Coth]]
 +
* [[Documentation/How_Tos/Calc:_ACOSH_function|<div style="font-size: 120%;">Acosh]]
 +
* [[Documentation/How_Tos/Calc:_ACOTH_function|<div style="font-size: 120%;">Acoth]]
 +
* [[Documentation/How_Tos/Calc:_ASINH_function|<div style="font-size: 120%;">Asinh]]
 +
* [[Documentation/How_Tos/Calc:_ATANH_function|<div style="font-size: 120%;">Atanh]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Rounding and remainders</div>
 +
* [[Documentation/How_Tos/Calc:_TRUNC_function|<div style="font-size: 120%;">Trunc]]
 +
* [[Documentation/How_Tos/Calc:_ROUND_function|<div style="font-size: 120%;">Round]]
 +
* [[Documentation/How_Tos/Calc:_ROUNDDOWN_function|<div style="font-size: 120%;">Rounddown]]
 +
* [[Documentation/How_Tos/Calc:_ROUNDUP_function|<div style="font-size: 120%;">Roundup]]
 +
* [[Documentation/How_Tos/Calc:_CEILING_function|<div style="font-size: 120%;">Ceiling]]
 +
* [[Documentation/How_Tos/Calc:_FLOOR_function|<div style="font-size: 120%;">Floor]]
 +
* [[Documentation/How_Tos/Calc:_EVEN_function|<div style="font-size: 120%;">Even]]
 +
* [[Documentation/How_Tos/Calc:_ODD_function|<div style="font-size: 120%;">Odd]]
 +
* [[Documentation/How_Tos/Calc:_MROUND_function|<div style="font-size: 120%;">Mround]]
 +
* [[Documentation/How_Tos/Calc:_INT_function|<div style="font-size: 120%;">Int]]
 +
* [[Documentation/How_Tos/Calc:_QUOTIENT_function|<div style="font-size: 120%;">Quotient]]
 +
* [[Documentation/How_Tos/Calc:_MOD_function|<div style="font-size: 120%;">Mod]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Logarithm/Powers</div>
 +
* [[Documentation/How_Tos/Calc:_EXP_function|<div style="font-size: 120%;">Exp]]
 +
* [[Documentation/How_Tos/Calc:_POWER_function|<div style="font-size: 120%;">Power]]
 +
* [[Documentation/How_Tos/Calc:_LOG_function|<div style="font-size: 120%;">Log]]
 +
* [[Documentation/How_Tos/Calc:_LN_function|<div style="font-size: 120%;">Ln]]
 +
* [[Documentation/How_Tos/Calc:_LOG10_function|<div style="font-size: 120%;">Log10]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Bessel functions</div>
 +
* [[Documentation/How_Tos/Calc:_BESSELI_function|<div style="font-size: 120%;">Besseli]]
 +
* [[Documentation/How_Tos/Calc:_BESSELJ_function|<div style="font-size: 120%;">Besselj]]
 +
* [[Documentation/How_Tos/Calc:_BESSELK_function|<div style="font-size: 120%;">Besselk]]
 +
* [[Documentation/How_Tos/Calc:_BESSELY_function|<div style="font-size: 120%;">Bessely]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Miscellaneous</div>
 +
* [[Documentation/How_Tos/Calc:_ABS_function|<div style="font-size: 120%;">Abs]]
 +
* [[Documentation/How_Tos/Calc:_COMBIN_function|<div style="font-size: 120%;">Combin]]
 +
* [[Documentation/How_Tos/Calc:_COMBINA_function|<div style="font-size: 120%;">Combina]]
 +
* [[Documentation/How_Tos/Calc:_CONVERT_function|<div style="font-size: 120%;">Convert]]
 +
* [[Documentation/How_Tos/Calc:_CONVERT_ADD_function|<div style="font-size: 120%;">Convert Add]]
 +
* [[Documentation/How_Tos/Calc:_COUNTBLANK_function|<div style="font-size: 120%;">Countblank]]
 +
* [[Documentation/How_Tos/Calc:_COUNTIF_function|<div style="font-size: 120%;">Countif]]
 +
* [[Documentation/How_Tos/Calc:_DELTA_function|<div style="font-size: 120%;">Delta]]
 +
* [[Documentation/How_Tos/Calc:_ERF_function|<div style="font-size: 120%;">Erf]]
 +
* [[Documentation/How_Tos/Calc:_ERFC_function|<div style="font-size: 120%;">Erfc]]
 +
* [[Documentation/How_Tos/Calc:_FACT_function|<div style="font-size: 120%;">Fact]]
 +
* [[Documentation/How_Tos/Calc:_FACTDOUBLE_function|<div style="font-size: 120%;">Factdouble]]
 +
* [[Documentation/How_Tos/Calc:_GCD_function|<div style="font-size: 120%;">Gcd]]
 +
* [[Documentation/How_Tos/Calc:_GCD_ADD_function|<div style="font-size: 120%;">Gcd Add]]
 +
* [[Documentation/How_Tos/Calc:_GESTEP_function|<div style="font-size: 120%;">Gestep]]
 +
* [[Documentation/How_Tos/Calc:_ISEVEN_function|<div style="font-size: 120%;">Iseven]]
 +
* [[Documentation/How_Tos/Calc:_ISODD_function|<div style="font-size: 120%;">Isodd]]
 +
* [[Documentation/How_Tos/Calc:_LCM_function|<div style="font-size: 120%;">Lcm]]
 +
* [[Documentation/How_Tos/Calc:_LCM_ADD_function|<div style="font-size: 120%;">Lcm Add]]
 +
* [[Documentation/How_Tos/Calc:_MULTINOMIAL_function|<div style="font-size: 120%;">Multinomial]]
 +
* [[Documentation/How_Tos/Calc:_PRODUCT_function|<div style="font-size: 120%;">Product]]
 +
* [[Documentation/How_Tos/Calc:_RAND_function|<div style="font-size: 120%;">Rand]]
 +
* [[Documentation/How_Tos/Calc:_RANDBETWEEN_function|<div style="font-size: 120%;">Randbetween]]
 +
* [[Documentation/How_Tos/Calc:_SERIESSUM_function|<div style="font-size: 120%;">Seriessum]]
 +
* [[Documentation/How_Tos/Calc:_SIGN_function|<div style="font-size: 120%;">Sign]]
 +
* [[Documentation/How_Tos/Calc:_SQRT_function|<div style="font-size: 120%;">Sqrt]]
 +
* [[Documentation/How_Tos/Calc:_SQRTPI_function|<div style="font-size: 120%;">Sqrtpi]]
 +
* [[Documentation/How_Tos/Calc:_SUBTOTAL_function|<div style="font-size: 120%;">Subtotal]]
 +
* [[Documentation/How_Tos/Calc:_SUM_function|<div style="font-size: 120%;">Sum]]
 +
* [[Documentation/How_Tos/Calc:_SUMIF_function|<div style="font-size: 120%;">Sumif]]
 +
* [[Documentation/How_Tos/Calc:_SUMSQ_function|<div style="font-size: 120%;">Sumsq]]
 +
}}__NOTOC__
 +
==List of Calc Mathematical functions==
  
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
Line 7: Line 101:
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion COS|'''COS''']]
+
|[[Documentation/How_Tos/Calc: COS function|'''COS''']]
 
|Returns the cosine of an angle.
 
|Returns the cosine of an angle.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion SIN|'''SIN''']]
+
|[[Documentation/How_Tos/Calc: SIN function|'''SIN''']]
 
|Returns the sine of an angle.
 
|Returns the sine of an angle.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion TAN|'''TAN''']]
+
|[[Documentation/How_Tos/Calc: TAN function|'''TAN''']]
 
|Returns the tangent of an angle.
 
|Returns the tangent of an angle.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion COT|'''COT''']]
+
|[[Documentation/How_Tos/Calc: COT function|'''COT''']]
 
|Returns the cotangent of an angle.
 
|Returns the cotangent of an angle.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion ACOS|'''ACOS''']]
+
|[[Documentation/How_Tos/Calc: ACOS function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ACOT function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ASIN function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ATAN function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ATAN2 function|'''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''']]
+
|[[Documentation/How_Tos/Calc: DEGREES function|'''DEGREES''']]
 
|Converts radians into degrees.
 
|Converts radians into degrees.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion RADIANS|'''RADIANS''']]
+
|[[Documentation/How_Tos/Calc: RADIANS function|'''RADIANS''']]
 
|Converts degrees into radians.
 
|Converts degrees into radians.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion PI|'''PI''']]
+
|[[Documentation/How_Tos/Calc: PI function|'''PI''']]
 
|Returns the value of PI.
 
|Returns the value of PI.
  
Line 58: Line 152:
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion COSH|'''COSH''']]
+
|[[Documentation/How_Tos/Calc: COSH function|'''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''']]
+
|[[Documentation/How_Tos/Calc: SINH function|'''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''']]
+
|[[Documentation/How_Tos/Calc: TANH function|'''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''']]
+
|[[Documentation/How_Tos/Calc: COTH function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ACOSH function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ACOTH function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ASINH function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ATANH function|'''ATANH''']]
 
|Returns the inverse hyperbolic tangent of a number.
 
|Returns the inverse hyperbolic tangent of a number.
  
Line 93: Line 187:
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion TRUNC|'''TRUNC''']]
+
|[[Documentation/How_Tos/Calc: TRUNC function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ROUND function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ROUNDDOWN function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ROUNDUP function|'''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''']]
+
|[[Documentation/How_Tos/Calc: CEILING function|'''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''']]
+
|[[Documentation/How_Tos/Calc: FLOOR function|'''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''']]
+
|[[Documentation/How_Tos/Calc: EVEN function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ODD function|'''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''']]
+
|[[Documentation/How_Tos/Calc: MROUND function|'''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''']]
+
|[[Documentation/How_Tos/Calc: INT function|'''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''']]
+
|[[Documentation/How_Tos/Calc: QUOTIENT function|'''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''']]
+
|[[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.
  
Line 144: Line 238:
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion EXP|'''EXP''']]
+
|[[Documentation/How_Tos/Calc: EXP function|'''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''']]
+
|[[Documentation/How_Tos/Calc: POWER function|'''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''']]
+
|[[Documentation/How_Tos/Calc: LOG function|'''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''']]
+
|[[Documentation/How_Tos/Calc: LN function|'''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''']]
+
|[[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"
 
|-valign="top"
−
|colspan="2"|'''<big> Bessels</big>'''
+
|colspan="2"|'''<big> Bessel functions</big>'''
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion BESSELI|'''BESSELI''']]
+
|[[Documentation/How_Tos/Calc: BESSELI function|'''BESSELI''']]
−
|Calculates the modified Bessel of the first kind.
+
|Calculates the modified Bessel function of the first kind.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion BESSELJ|'''BESSELJ''']]
+
|[[Documentation/How_Tos/Calc: BESSELJ function|'''BESSELJ''']]
−
|Calculates the Bessel of the first kind.
+
|Calculates the Bessel function of the first kind.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion BESSELK|'''BESSELK''']]
+
|[[Documentation/How_Tos/Calc: BESSELK function|'''BESSELK''']]
−
|Calculates the modified Bessel of the second kind.
+
|Calculates the modified Bessel function of the second kind.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion BESSELY|'''BESSELY''']]
+
|[[Documentation/How_Tos/Calc: BESSELY function|'''BESSELY''']]
−
|Calculates the Bessel of the second kind (the Neumann or Weber).
+
|Calculates the Bessel function of the second kind (the Neumann or Weber function).
  
 
|-valign="top"
 
|-valign="top"
Line 186: Line 280:
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion ABS|'''ABS''']]
+
|[[Documentation/How_Tos/Calc: ABS function|'''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''']]
+
|[[Documentation/How_Tos/Calc: COMBIN function|'''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''']]
+
|[[Documentation/How_Tos/Calc: COMBINA function|'''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''']]
+
|[[Documentation/How_Tos/Calc: CONVERT function|'''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''']]
+
|[[Documentation/How_Tos/Calc: CONVERT_ADD function|'''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''']]
+
|[[Documentation/How_Tos/Calc: COUNTBLANK function|'''COUNTBLANK''']]
 
|Returns the number of empty cells.
 
|Returns the number of empty cells.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion COUNTIF|'''COUNTIF''']]
+
|[[Documentation/How_Tos/Calc: COUNTIF function|'''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''']]
+
|[[Documentation/How_Tos/Calc: DELTA function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ERF function|'''ERF''']]
−
|Calculates the error (Gauss error).
+
|Calculates the error function (Gauss error function).
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion ERFC|'''ERFC''']]
+
|[[Documentation/How_Tos/Calc: ERFC function|'''ERFC''']]
−
|Calculates the complementary error (complementary Gauss error).
+
|Calculates the complementary error function (complementary Gauss error function).
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion FACT|'''FACT''']]
+
|[[Documentation/How_Tos/Calc: FACT function|'''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''']]
+
|[[Documentation/How_Tos/Calc: FACTDOUBLE function|'''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''']]
+
|[[Documentation/How_Tos/Calc: GCD function|'''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''']]
+
|[[Documentation/How_Tos/Calc: GCD_ADD function|'''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''']]
+
|[[Documentation/How_Tos/Calc: GESTEP function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ISEVEN function|'''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''']]
+
|[[Documentation/How_Tos/Calc: ISODD function|'''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''']]
+
|[[Documentation/How_Tos/Calc: LCM function|'''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''']]
+
|[[Documentation/How_Tos/Calc: LCM_ADD function|'''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''']]
+
|[[Documentation/How_Tos/Calc: MULTINOMIAL function|'''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''']]
+
|[[Documentation/How_Tos/Calc: PRODUCT function|'''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''']]
+
|[[Documentation/How_Tos/Calc: RAND function|'''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''']]
+
|[[Documentation/How_Tos/Calc: RANDBETWEEN function|'''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''']]
+
|[[Documentation/How_Tos/Calc: SERIESSUM function|'''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''']]
+
|[[Documentation/How_Tos/Calc: SIGN function|'''SIGN''']]
 
|Returns the sign of a number.
 
|Returns the sign of a number.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion SQRT|'''SQRT''']]
+
|[[Documentation/How_Tos/Calc: SQRT function|'''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''']]
+
|[[Documentation/How_Tos/Calc: SQRTPI function|'''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''']]
+
|[[Documentation/How_Tos/Calc: SUBTOTAL function|'''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''']]
+
|[[Documentation/How_Tos/Calc: SUM function|'''SUM''']]
 
|Sums the contents of cells.
 
|Sums the contents of cells.
  
 
|-valign="top"
 
|-valign="top"
−
|[[OOoES/Traduccion/Calc: Funcion SUMIF|'''SUMIF''']]
+
|[[Documentation/How_Tos/Calc: SUMIF function|'''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''']]
+
|[[Documentation/How_Tos/Calc: SUMSQ function|'''SUMSQ''']]
 
|Returns the sum of the squares of numbers.
 
|Returns the sum of the squares of numbers.
  
Line 313: Line 407:
 
<!-- why on earth is this necessary? -->
 
<!-- why on earth is this necessary? -->
  
−
==See also==
+
{{SeeAlso|EN|
−
 
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]],
−
'''[[OOoES/Traduccion/Calc: Funcion Functions listed by category|Functions listed by category]]'''
+
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]
 +
}}
 +
[[Category: Documentation/Reference/Calc]]

Revision as of 12:32, 16 July 2018


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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Mathematical_functions&oldid=243223"
Views
Personal tools
Navigation
Tools