Math

Arithmetic, rounding, trigonometry and aggregation.

Function	What it does
ABS	Returns absolute value of a number.
ACOS	Returns arccosine of a number.
ACOSH	Returns inverse hyperbolic cosine.
ACOT	Returns the arccotangent of a number.
ACOTH	Returns the inverse hyperbolic cotangent.
ADD	Adds two numbers: sheets exposes the + operator as a function.
AGGREGATE	Aggregates a range with a chosen function, optionally ignoring error values.
ARABIC	Converts roman numeral to arabic number.
ASIN	Returns arcsine of a number.
ASINH	Returns inverse hyperbolic sine.
ATAN	Returns arctangent of a number.
ATAN2	Returns arctangent from x and y coordinates.
ATANH	Returns inverse hyperbolic tangent.
AVERAGE	Calculates arithmetic mean.
BASE	Converts number to text in given base.
CEILING	Rounds up to the nearest multiple of significance.
CEILING.MATH	Rounds up with optional significance and mode.
CEILING.PRECISE	Rounds up to the nearest multiple, sign-independent.
CHOOSE	Chooses a value from a list by index.
COLUMN	Returns column number of a reference.
COLUMNS	Returns number of columns in a reference.
COMBIN	Number of combinations of n items taken k at a time.
COMBINA	Combinations with repetitions.
COS	Returns cosine of an angle.
COSH	Returns hyperbolic cosine.
COT	Returns cotangent of an angle.
COTH	Returns hyperbolic cotangent.
CSC	Returns cosecant of an angle.
CSCH	Returns hyperbolic cosecant.
DECIMAL	Converts text in given base to number.
DEGREES	Converts radians to degrees.
DIVIDE	Divides the first number by the second.
ECMA.CEILING	Rounds up to the nearest multiple of significance.
EVEN	Rounds up to the nearest even integer.
EXP	E raised to the power of a number.
FACT	Factorial of a number.
FACTDOUBLE	Returns double factorial of a number.
FLOOR	Rounds down to the nearest multiple of significance.
FLOOR.MATH	Rounds down with optional significance and mode.
FLOOR.PRECISE	Rounds down to the nearest multiple, sign-independent.
GAMMA	Returns the gamma function value.
GCD	Greatest common divisor.
INT	Rounds down to the nearest integer.
ISO.CEILING	Rounds up to the nearest multiple, sign-independent.
LCM	Least common multiple.
LN	Natural logarithm of a number.
LOG	Logarithm to a given base.
LOG10	Base-10 logarithm of a number.
MAX	Returns the largest value in a set.
MDETERM	Returns matrix determinant of an array.
MIN	Returns the smallest value in a set.
MINUS	Subtracts the second number from the first.
MINVERSE	Returns matrix inverse of an array.
MMULT	Returns the matrix product of two arrays.
MOD	Remainder after division.
MROUND	Rounds to the nearest multiple.
MULTINOMIAL	Returns the multinomial coefficient of a set of numbers.
MULTIPLY	Multiplies two numbers.
MUNIT	Returns identity matrix of given size.
ODD	Rounds up to the nearest odd integer.
PI	Returns the value of pi.
POW	Raises a number to a power.
POWER	Returns number raised to a power.
PRODUCT	Multiplies all numbers given as arguments.
QUOTIENT	Integer portion of a division.
RADIANS	Converts degrees to radians.
RAND	Returns a random number between 0 and 1.
RANDBETWEEN	Returns random integer between two values.
ROMAN	Converts arabic number to roman numeral.
ROUND	Rounds a number to specified digits.
ROUNDDOWN	Rounds a number down toward zero.
ROUNDUP	Rounds a number up away from zero.
SEC	Returns secant of an angle.
SECH	Returns hyperbolic secant.
SERIESSUM	Returns the sum of a power series.
SIGN	Sign of a number as -1, 0 or 1.
SIN	Returns sine of an angle.
SINH	Returns hyperbolic sine.
SQRT	Returns square root of a number.
SQRTPI	Returns square root of number times pi.
SUM	Adds numbers together.
SUMIF	Sums cells that match a condition.
SUMIFS	Sums cells that match multiple conditions.
SUMPRODUCT	Returns sum of products of array components.
SUMSQ	Sum of the squares of the arguments.
SUMX2MY2	Sum of the difference of squares of two ranges.
SUMX2PY2	Sum of the sum of squares of two ranges.
SUMXMY2	Sum of squared differences of two ranges.
TAN	Returns tangent of an angle.
TANH	Returns hyperbolic tangent.
TRUNC	Truncates a number to a given precision.
UMINUS	Negates a number.
UNARY_PERCENT	Divides a number by 100.
UPLUS	Returns its argument unchanged.