Difference between revisions of "Documentation/How Tos/Calc: Mathematical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
|||
| (11 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
{{Documentation/MasterTOC | {{Documentation/MasterTOC | ||
|bookid=1234''' | |bookid=1234''' | ||
| − | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;"> | + | |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]] | |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 | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_COS_function | ||
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_TRUE_function | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_TRUE_function | ||
| − | |ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc: | + | |ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Logical_functions |
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Number_Conversion_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> | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div> | ||
| Line 99: | Line 31: | ||
* [[Documentation/How_Tos/Calc:_ACOTH_function|<div style="font-size: 120%;">Acoth]] | * [[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:_ASINH_function|<div style="font-size: 120%;">Asinh]] | ||
| − | * [[Documentation/How_Tos/Calc:_ATANH_function|<div style="font-size: 120%;">Atanh]] | + | * [[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> | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Rounding and remainders</div> | ||
| Line 115: | Line 47: | ||
* [[Documentation/How_Tos/Calc:_MOD_function|<div style="font-size: 120%;">Mod]] | * [[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> | + | <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:_EXP_function|<div style="font-size: 120%;">Exp]] | ||
* [[Documentation/How_Tos/Calc:_POWER_function|<div style="font-size: 120%;">Power]] | * [[Documentation/How_Tos/Calc:_POWER_function|<div style="font-size: 120%;">Power]] | ||
| Line 125: | Line 57: | ||
* [[Documentation/How_Tos/Calc:_BESSELI_function|<div style="font-size: 120%;">Besseli]] | * [[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:_BESSELJ_function|<div style="font-size: 120%;">Besselj]] | ||
| − | * [[Documentation/How_Tos/Calc:_BESSELK_function|<div style="font-size: 120%;">Besselk] | + | * [[Documentation/How_Tos/Calc:_BESSELK_function|<div style="font-size: 120%;">Besselk]] |
* [[Documentation/How_Tos/Calc:_BESSELY_function|<div style="font-size: 120%;">Bessely]] | * [[Documentation/How_Tos/Calc:_BESSELY_function|<div style="font-size: 120%;">Bessely]] | ||
| Line 131: | Line 63: | ||
* [[Documentation/How_Tos/Calc:_ABS_function|<div style="font-size: 120%;">Abs]] | * [[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:_COMBIN_function|<div style="font-size: 120%;">Combin]] | ||
| − | * [[Documentation/How_Tos/Calc: | + | * [[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_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:_CONVERT_ADD_function|<div style="font-size: 120%;">Convert Add]] | ||
| − | * [[Documentation/How_Tos/Calc: | + | * [[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:_COUNTIF_function|<div style="font-size: 120%;">Countif]] | ||
* [[Documentation/How_Tos/Calc:_DELTA_function|<div style="font-size: 120%;">Delta]] | * [[Documentation/How_Tos/Calc:_DELTA_function|<div style="font-size: 120%;">Delta]] | ||
| Line 141: | Line 73: | ||
* [[Documentation/How_Tos/Calc:_FACT_function|<div style="font-size: 120%;">Fact]] | * [[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:_FACTDOUBLE_function|<div style="font-size: 120%;">Factdouble]] | ||
| − | * [[Documentation/How_Tos/Calc: | + | * [[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:_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:_GESTEP_function|<div style="font-size: 120%;">Gestep]] | ||
| Line 148: | Line 80: | ||
* [[Documentation/How_Tos/Calc:_LCM_function|<div style="font-size: 120%;">Lcm]] | * [[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:_LCM_ADD_function|<div style="font-size: 120%;">Lcm Add]] | ||
| − | * [[Documentation/How_Tos/Calc: | + | * [[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:_PRODUCT_function|<div style="font-size: 120%;">Product]] | ||
* [[Documentation/How_Tos/Calc:_RAND_function|<div style="font-size: 120%;">Rand]] | * [[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:_RANDBETWEEN_function|<div style="font-size: 120%;">Randbetween]] | ||
* [[Documentation/How_Tos/Calc:_SERIESSUM_function|<div style="font-size: 120%;">Seriessum]] | * [[Documentation/How_Tos/Calc:_SERIESSUM_function|<div style="font-size: 120%;">Seriessum]] | ||
| − | * [[Documentation/How_Tos/Calc: | + | * [[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:_SQRT_function|<div style="font-size: 120%;">Sqrt]] | ||
* [[Documentation/How_Tos/Calc:_SQRTPI_function|<div style="font-size: 120%;">Sqrtpi]] | * [[Documentation/How_Tos/Calc:_SQRTPI_function|<div style="font-size: 120%;">Sqrtpi]] | ||
| Line 160: | Line 92: | ||
* [[Documentation/How_Tos/Calc:_SUMIF_function|<div style="font-size: 120%;">Sumif]] | * [[Documentation/How_Tos/Calc:_SUMIF_function|<div style="font-size: 120%;">Sumif]] | ||
* [[Documentation/How_Tos/Calc:_SUMSQ_function|<div style="font-size: 120%;">Sumsq]] | * [[Documentation/How_Tos/Calc:_SUMSQ_function|<div style="font-size: 120%;">Sumsq]] | ||
| − | }} | + | }}__NOTOC__ |
==List of Calc Mathematical functions== | ==List of Calc Mathematical functions== | ||
| Line 475: | Line 407: | ||
<!-- why on earth is this necessary? --> | <!-- why on earth is this necessary? --> | ||
| − | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]], | * [[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]] | [[Category: Documentation/Reference/Calc]] | ||
Revision as of 12:32, 16 July 2018
- Mathematical FunctionsTrigonometric
- CosSinTanCotAcosAcotAsinAtanAtan2DegreesRadiansPiHyperbolic
- CoshSinhTanhCothAcoshAcothAsinhAtanhRounding and remainders
- TruncRoundRounddownRoundupCeilingFloorEvenOddMroundIntQuotientModLogarithm/Powers
- ExpPowerLogLnLog10Bessel functions
- BesseliBesseljBesselkBesselyMiscellaneous
- AbsCombinCombinaConvertConvert AddCountblankCountifDeltaErfErfcFactFactdoubleGcdGcd AddGestepIsevenIsoddLcmLcm AddMultinomialProductRandRandbetweenSeriessumSignSqrtSqrtpiSubtotal
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
-
