Math Functions

Column 1	Title	Column 2
Function	Description
ABS	Returns the absolute value of a number
ACOS	Returns the arccosine of a number
ACOSH	Returns the inverse hyperbolic cosine of a number
ACOT (2013)	Returns the arccotangent of a number
ACOTH (2013)	Returns the hyperbolic arccotangent of a number
AGGREGATE	Returns an aggregate in a list or database
ARABIC	Converts a Roman number to Arabic, as a number
ASIN	Returns the arcsine of a number
ASINH	Returns the inverse hyperbolic sine of a number
ATAN	Returns the arctangent of a number
ATAN2	Returns the arctangent from x- and y-coordinates
ATANH	Returns the inverse hyperbolic tangent of a number
BASE (2013)	Converts a number into a text representation with the given radix (base)
CEILING	Rounds a number to the nearest integer or to the nearest multiple of significance
CEILING.MATH (2013)	Rounds a number up, to the nearest integer or to the nearest multiple of significance
CEILING.PRECISE	Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
COMBIN	Returns the number of combinations for a given number of objects
COMBINA (2013)	Returns the number of combinations with repetitions for a given number of items
COS	Returns the cosine of a number
COSH	Returns the hyperbolic cosine of a number
COT (2013)	Returns the cotangent of an angle
COTH (2013)	Returns the hyperbolic cotangent of a number
CSC (2013)	Returns the cosecant of an angle
CSCH (2013)	Returns the hyperbolic cosecant of an angle
DECIMAL (2013)	Converts a text representation of a number in a given base into a decimal number
DEGREES	Converts radians to degrees
EVEN	Rounds a number up to the nearest even integer
EXP	Returns e raised to the power of a given number
FACT	Returns the factorial of a number
FACTDOUBLE	Returns the double factorial of a number
FLOOR	Rounds a number down, toward zero
FLOOR.MATH (2013)	Rounds a number down, to the nearest integer or to the nearest multiple of significance
FLOOR.PRECISE	Rounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.
GCD	Returns the greatest common divisor
INT	Rounds a number down to the nearest integer	`INT(number)`
ISO.CEILING (2013)	Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance
LCM	Returns the least common multiple
LET (2021)	Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
LN	Returns the natural logarithm of a number
LOG	Returns the logarithm of a number to a specified base
LOG10	Returns the base-10 logarithm of a number
MDETERM	Returns the matrix determinant of an array
MINVERSE	Returns the matrix inverse of an array
MMULT	Returns the matrix product of two arrays
MOD	Returns the remainder from division	`MOD(number, divisor)`
MROUND	Returns a number rounded to the desired multiple
MULTINOMIAL	Returns the multinomial of a set of numbers
MUNIT (2013)	Returns the unit matrix or the specified dimension
ODD	Rounds a number up to the nearest odd integer
PERCENTOF (Microsoft 365)	Sums the values in the subset and divides it by all the values
PI	Returns the value of pi
POWER	Returns the result of a number raised to a power
PRODUCT	Multiplies its arguments
QUOTIENT	Returns the integer portion of a division
RADIANS	Converts degrees to radians
RAND	Returns a random number between 0 and 1
RANDARRA (2021)	Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.
RANDBETWEEN	Returns a random number between the numbers you specify	`RANDBETWEEN`(bottom, top)
ROMAN	Converts an Arabic numeral to Roman, as text
ROUND	Rounds a number to a specified number of digits	`ROUND`(number, num_digits)
ROUNDDOWN	Rounds a number down, toward zero
ROUNDUP	Rounds a number up, away from zero
SEC (2013)	Returns the secant of an angle
SECH (2013)	Returns the hyperbolic secant of an angle
SERIESSUM	Returns the sum of a power series based on the formula
SEQUENCE(2021)	Generates a list of sequential numbers in an array, such as 1, 2, 3, 4
SIGN	Returns the sign of a number
SIN	Returns the sine of the given angle
SINH	Returns the hyperbolic sine of a number
SQRT	Returns a positive square root
SQRTPI	Returns the square root of (number * pi)
SUBTOTAL	Returns a subtotal in a list or database
SUM	Adds its arguments
SUMIF	Adds the cells specified by a given criteria	`SUMIF(range, criteria, [sum_range])`
SUMIFS (2019)	Adds the cells in a range that meet multiple criteria	`SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)`
SUMPRODUCT	Returns the sum of the products of corresponding array components
SUMSQ	Returns the sum of the squares of the arguments
SUMX2MY2	Returns the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2	Returns the sum of the sum of squares of corresponding values in two arrays
SUMXMY2	Returns the sum of squares of differences of corresponding values in two arrays
TAN	Returns the tangent of a number
TANH	Returns the hyperbolic tangent of a number
TRUNC	Truncates a number to an integer

Math Functions

Untitled