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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
(32 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 +
{{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==
 
==List of Calc Mathematical functions==
  
 
{| 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: COS function|'''COS''']]
 
|Returns the cosine of an angle.
 
|Returns the cosine of an angle.
  
Line 49: Line 147:
 
|[[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 182:
 
|[[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 116: Line 220:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: MROUND function|'''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"
Line 124: Line 228:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: QUOTIENT function|'''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"
 
|[[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 256:
 
|[[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> Bessel functions</big>'''
 +
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: BESSELI function|'''BESSELI''']]
 +
|Calculates the modified Bessel function of the first kind.
 +
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: BESSELJ function|'''BESSELJ''']]
 +
|Calculates the Bessel function of the first kind.
 +
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: BESSELK function|'''BESSELK''']]
 +
|Calculates the modified Bessel function of the second kind.
 +
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: BESSELY function|'''BESSELY''']]
 +
|Calculates the Bessel function of the second kind (the Neumann or Weber function).
 +
 +
|-valign="top"
 +
|colspan="2"|'''<big> Miscellaneous</big>'''
  
 
|-valign="top"
 
|-valign="top"
Line 165: Line 294:
 
|[[Documentation/How_Tos/Calc: CONVERT function|'''CONVERT''']]
 
|[[Documentation/How_Tos/Calc: CONVERT function|'''CONVERT''']]
 
|Converts between legacy European currencies and Euros.
 
|Converts between legacy European currencies and Euros.
 +
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: CONVERT_ADD function|'''CONVERT_ADD''']]
 +
|Converts a number from one measurement system to another.
  
 
|-valign="top"
 
|-valign="top"
Line 173: Line 306:
 
|[[Documentation/How_Tos/Calc: COUNTIF function|'''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"
 +
|[[Documentation/How_Tos/Calc: DELTA function|'''DELTA''']]
 +
|Returns 1 if two numbers are equal, and 0 otherwise.
 +
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: ERF function|'''ERF''']]
 +
|Calculates the error function (Gauss error function).
 +
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: ERFC function|'''ERFC''']]
 +
|Calculates the complementary error function (complementary Gauss error function).
  
 
|-valign="top"
 
|-valign="top"
Line 188: Line 333:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: GCD_ADD function|'''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"
 +
|[[Documentation/How_Tos/Calc: GESTEP function|'''GESTEP''']]
 +
|Returns 1 if a number is greater than or equal to a step number, or 0 otherwise.
  
 
|-valign="top"
 
|-valign="top"
Line 204: Line 353:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: LCM_ADD function|'''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"
 
|[[Documentation/How_Tos/Calc: MULTINOMIAL function|'''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"
Line 220: Line 369:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: RANDBETWEEN function|'''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"
 
|[[Documentation/How_Tos/Calc: SERIESSUM function|'''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"
Line 236: Line 385:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: SQRTPI function|'''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"
Line 258: Line 407:
 
<!-- why on earth is this necessary? -->
 
<!-- why on earth is this necessary? -->
  
−
 
+
{{SeeAlso|EN|
−
==See also==
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]],
−
 
+
* [[Documentation/How_Tos/Calc: 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