The following table presents a brief description of predefined math functions:
Function | Brief description |
Abs | It returns the module (absolute value) of a number. |
ACos | It returns the number arccosine. |
ACosH | It returns hyperbolic arccosine of a number. |
ACot | It returns the arccotangent of the number. |
ACotH | It returns the hyperbolic arccotangent of the number. |
Aggregate | It returns result of aggregation with the specified method with a possibility to not take into account hidden values on calculation. |
ASin | It returns the number arcsine. |
ASinH | It returns the hyperbolic arcsine of a number. |
ATan | It returns the number arctangent. |
ATan2 | It returns the arctangent for the specified X and Y coordinates. |
ATanH | It returns the hyperbolic arctangent of the number. |
Average | It returns the average of an array of cells. |
AverageIf | It returns the average of cells that satisfy the specified condition. |
AverageIfS | It returns the average of cells that satisfy the specified set of conditions. |
Ceiling | It returns the result of rounding the value up, to the nearest integer or to the nearest multiple of significance. |
Combin | It returns the number of combinations for the specified number of objects. |
Cos | It returns the cosine of the specified angle. |
CosH | It returns the hyperbolic cosine of a number |
Cot | It returns the cotangent of an angle. |
CotH | It returns the hyperbolic cotangent of a number. |
Count | It returns the number of elements in an array of cells. |
CountIf | It returns the number of cells that satisfy the specified condition. |
CountIfS | It returns the number of cells that satisfy the specified set of conditions. |
Degrees | It returns a value converted from radians to degrees. |
Even | It returns the result of rounding the value to the nearest even integer. |
Exp | It returns the result of raising the number "e" to the specified power. |
Fact | It returns the factorial of the specified number. |
Floor | It returns the result of rounding the number to the nearest integer smaller in modulus. |
Gcd | It returns the greatest common divisor for two or more integers. |
Int | It returns the result of rounding the value to the nearest smaller integer. |
Lcm | It returns the least common multiple for two or more integers. |
Ln | It returns the natural logarithm of a number. |
Log | It returns the number logarithm based on the specified base. |
Log10 | It returns the base-10 logarithm of the specified number. |
Max | It returns the maximum number in the cell array. |
MDeterm | It returns the matrix determinant of a cell array. |
Min | It returns the minimum number in the cell array. |
MInverse | It returns an inverse matrix for the specified matrix. |
MMult | It returns the number matrix equal to the product of the two matrixes. |
Mod_ | It returns the remainder from dividing a number by a denominator. |
MRound | It returns a number rounded with desired precision. |
Multinomial | It returns the multinomial of a set of numbers, for which you want the multinomial |
Odd | It returns the result of rounding the value to the nearest odd integer. |
Power | It returns the result of raising a real number to real power. |
Product | It returns the product of cell array values. |
Quotient | It returns the integer part of the result of division with a remainder. |
Radians | It returns a value converted from degrees to radians. |
Rand | It returns a random number greater than or equal to 0 and less than 1, evenly distributed. |
RandBetween | It returns a random number between two specified numbers |
RndPermutation | It returns an array that is an arbitrary permutation of another array, which elements are integers ranging from 1 to the value of the passed parameter. |
RndSample | It returns the random sample of M elements from the elements array, which are integers from 1 to N. |
Roman | It returns the result of converting an Arabic number into a Roman as text. |
Round | It returns the result of rounding a number to the specified number of decimal places. |
RoundDown | It returns the result of rounding the number to the nearest value smaller in modulus. |
RoundUp | It returns the result of rounding the number to a nearest value greater in modulus. |
SeriesSum | It returns the sum of a power series. |
Sign | It returns the number sign. |
Sin | It returns the sine of the specified angle. |
SinH | It returns hyperbolic sine of the specified number. |
Sqrt | It returns positive value of a square root. |
SqrtPi | It returns the square root from the expression value: Number * Pi. |
Sum | It returns the sum of real numbers from the specified cell range. |
Sumif | It returns the sum of numbers in the specified cell range that satisfy the specified condition. |
SumIfS | It returns the sum of numbers in the specified cell range that satisfy the specified set of conditions. |
SumSq | It returns the sum of squares of numbers from the specified cell range. |
SumX2MY2 | It returns the sum of differences of squares of corresponding values in two arrays. |
SumX2PY2 | It returns the sum of sums of squares of corresponding values in two arrays. |
SumXMY2 | It returns the sum of squares of the differences of corresponding values in two arrays. |
Tan | It returns the tangent of the specified angle. |
TanH | It returns the hyperbolic tangent of the specified angle. |
Trunc | Truncates a number to the specified number of decimal places. |
See also: