Mathematical Functions

When working with formulas, the user can use predefined math functions listed in the table below:

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