Type in Google’s function list

Math functions

Arithmetic, rounding, trigonometry and complex numbers. Google prints 84 Math function(s) in its Google Sheets function list.

Function	Syntax as printed	Description from Google Docs Editors Help
ABS	`ABS(value)`	Returns the absolute value of a number.
ACOS	`ACOS(value)`	Returns the inverse cosine of a value, in radians.
ACOSH	`ACOSH(value)`	Returns the inverse hyperbolic cosine of a number.
ACOT	`ACOT(value)`	Returns the inverse cotangent of a value, in radians.
ACOTH	`ACOTH(value)`	Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive.
ASIN	`ASIN(value)`	Returns the inverse sine of a value, in radians.
ASINH	`ASINH(value)`	Returns the inverse hyperbolic sine of a number.
ATAN	`ATAN(value)`	Returns the inverse tangent of a value, in radians.
ATAN2	`ATAN2(x, y)`	Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians.
ATANH	`ATANH(value)`	Returns the inverse hyperbolic tangent of a number.
BASE	`BASE(value, base, [min_length])`	Converts a number into a text representation in another base, for example, base 2 for binary.
CEILING	`CEILING(value, [factor])`	Rounds a number up to the nearest integer multiple of specified significance.
CEILING.MATH	`CEILING.MATH(number, [significance], [mode])`	Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.
CEILING.PRECISE	`CEILING.PRECISE(number, [significance])`	Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up.
COMBIN	`COMBIN(n, k)`	Returns the number of ways to choose some number of objects from a pool of a given size of objects.
COMBINA	`COMBINA(n, k)`	Returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways that choose the same object multiple times.
COS	`COS(angle)`	Returns the cosine of an angle provided in radians.
COSH	`COSH(value)`	Returns the hyperbolic cosine of any real number.
COT	`COT(angle)`	Cotangent of an angle provided in radians.
COTH	`COTH(value)`	Returns the hyperbolic cotangent of any real number.
COUNTBLANK	`COUNTBLANK(range)`	Returns the number of empty cells in a given range.
COUNTIF	`COUNTIF(range, criterion)`	Returns a conditional count across a range.
COUNTIFS	`COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])`	Returns the count of a range depending on multiple criteria.
COUNTUNIQUE	`COUNTUNIQUE(value1, [value2, ...])`	Counts the number of unique values in a list of specified values and ranges.
CSC	`CSC(angle)`	Returns the cosecant of an angle provided in radians.
CSCH	`CSCH(value)`	The CSCH function returns the hyperbolic cosecant of any real number.
DECIMAL	`DECIMAL(value, base)`	The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal).
DEGREES	`DEGREES(angle)`	Converts an angle value in radians to degrees.
ERFC	`ERFC(z)`	Returns the complementary Gauss error function of a value.
ERFC.PRECISE	`ERFC.PRECISE(z)`	See ERFC
EVEN	`EVEN(value)`	Rounds a number up to the nearest even integer.
EXP	`EXP(exponent)`	Returns Euler's number, e (~2.718) raised to a power.
FACT	`FACT(value)`	Returns the factorial of a number.
FACTDOUBLE	`FACTDOUBLE(value)`	Returns the "double factorial" of a number.
FLOOR	`FLOOR(value, [factor])`	Rounds a number down to the nearest integer multiple of specified significance.
FLOOR.MATH	`FLOOR.MATH(number, [significance], [mode])`	Rounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.
FLOOR.PRECISE	`FLOOR.PRECISE(number, [significance])`	The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance.
GAMMALN	`GAMMALN(value)`	Returns the the logarithm of a specified Gamma function, base e (Euler's number).
GAMMALN.PRECISE	`GAMMALN.PRECISE(value)`	See GAMMALN
GCD	`GCD(value1, value2)`	Returns the greatest common divisor of one or more integers.
IMLN	`IMLN(complex_value)`	Returns the logarithm of a complex number, base e (Euler's number).
IMPOWER	`IMPOWER(complex_base, exponent)`	Returns a complex number raised to a power.
IMSQRT	`IMSQRT(complex_number)`	Computes the square root of a complex number.
INT	`INT(value)`	Rounds a number down to the nearest integer that is less than or equal to it.
ISEVEN	`ISEVEN(value)`	Checks whether the provided value is even.
ISO.CEILING	`ISO.CEILING(number, [significance])`	See CEILING.PRECISE
ISODD	`ISODD(value)`	Checks whether the provided value is odd.
LCM	`LCM(value1, value2)`	Returns the least common multiple of one or more integers.
LN	`LN(value)`	Returns the the logarithm of a number, base e (Euler's number).
LOG	`LOG(value, base)`	Returns the the logarithm of a number given a base.
LOG10	`LOG10(value)`	Returns the the logarithm of a number, base 10.
MOD	`MOD(dividend, divisor)`	Returns the result of the modulo operator, the remainder after a division operation.
MROUND	`MROUND(value, factor)`	Rounds one number to the nearest integer multiple of another.
MULTINOMIAL	`MULTINOMIAL(value1, value2)`	Returns the factorial of the sum of values divided by the product of the values' factorials.
MUNIT	`MUNIT(dimension)`	Returns a unit matrix of size dimension x dimension.
ODD	`ODD(value)`	Rounds a number up to the nearest odd integer.
PI	`PI()`	Returns the value of Pi to 14 decimal places.
POWER	`POWER(base, exponent)`	Returns a number raised to a power.
PRODUCT	`PRODUCT(factor1, [factor2, ...])`	Returns the result of multiplying a series of numbers together.
QUOTIENT	`QUOTIENT(dividend, divisor)`	Returns one number divided by another.
RADIANS	`RADIANS(angle)`	Converts an angle value in degrees to radians.
RAND	`RAND()`	Returns a random number between 0 inclusive and 1 exclusive.
RANDARRAY	`RANDARRAY(rows, columns)`	Generates an array of random numbers between 0 and 1.
RANDBETWEEN	`RANDBETWEEN(low, high)`	Returns a uniformly random integer between two values, inclusive.
ROUND	`ROUND(value, [places])`	Rounds a number to a certain number of decimal places according to standard rules.
ROUNDDOWN	`ROUNDDOWN(value, [places])`	Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.
ROUNDUP	`ROUNDUP(value, [places])`	Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
SEC	`SEC(angle)`	The SEC function returns the secant of an angle, measured in radians.
SECH	`SECH(value)`	The SECH function returns the hyperbolic secant of an angle.
SEQUENCE	`SEQUENCE(rows, columns, start, step)`	Returns an array of sequential numbers, such as 1, 2, 3, 4.
SERIESSUM	`SERIESSUM(x, n, m, a)`	Given parameters x , n , m , and a , returns the power series sum a 1 x n + a 2 x (n+m) + ... + a i x (n+(i-1)m) , where i is the number of entries in range `a`.
SIGN	`SIGN(value)`	Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.
SIN	`SIN(angle)`	Returns the sine of an angle provided in radians.
SINH	`SINH(value)`	Returns the hyperbolic sine of any real number.
SQRT	`SQRT(value)`	Returns the positive square root of a positive number.
SQRTPI	`SQRTPI(value)`	Returns the positive square root of the product of Pi and the given positive number.
SUBTOTAL	`SUBTOTAL(function_code, range1, [range2, ...])`	Returns a subtotal for a vertical range of cells using a specified aggregation function.
SUM	`SUM(value1, [value2, ...])`	Returns the sum of a series of numbers and/or cells.
SUMIF	`SUMIF(range, criterion, [sum_range])`	Returns a conditional sum across a range.
SUMIFS	`SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])`	Returns the sum of a range depending on multiple criteria.
SUMSQ	`SUMSQ(value1, [value2, ...])`	Returns the sum of the squares of a series of numbers and/or cells.
TAN	`TAN(angle)`	Returns the tangent of an angle provided in radians.
TANH	`TANH(value)`	Returns the hyperbolic tangent of any real number.
TRUNC	`TRUNC(value, [places])`	Truncates a number to a certain number of significant digits by omitting less significant digits.

Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026. Every function name in Google’s list is placed under one type; a function carries the type the list prints for it.