Google Sheets math functions
Math functions in Google Sheets, explained with live examples.
84 math functions in Google Sheets — 84 documented in depth so far, the rest indexed below and landing every week.
Documented math functions
Syntax, examples, and the equivalent — ready now.
- ABSReturns the absolute value of a number.MathExcel
- ACOSReturns the inverse cosine of a value, in radians.MathExcel
- ACOSHReturns the inverse hyperbolic cosine of a number.MathExcel
- ACOTReturns the inverse cotangent of a value, in radians.MathExcel
- ACOTHReturns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive..MathExcel
- ASINReturns the inverse sine of a value, in radians.MathExcel
- ASINHReturns the inverse hyperbolic sine of a number.MathExcel
- ATANReturns the inverse tangent of a value, in radians.MathExcel
- ATAN2Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians.MathExcel
- ATANHReturns the inverse hyperbolic tangent of a number.MathExcel
- BASEConverts a number into a text representation in another base, for example, base 2 for binary.MathExcel
- CEILINGRounds a number up to the nearest integer multiple of specified significance.MathExcel
- CEILING.MATHRounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.MathExcel
- CEILING.PRECISERounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up.MathExcel
- COMBINReturns the number of ways to choose some number of objects from a pool of a given size of objects.MathExcel
- COMBINAReturns 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.MathExcel
- COSReturns the cosine of an angle provided in radians.MathExcel
- COSHReturns the hyperbolic cosine of any real number.MathExcel
- COTCotangent of an angle provided in radians.MathExcel
- COTHReturns the hyperbolic cotangent of any real number.MathExcel
- COUNTBLANKReturns the number of empty cells in a given range.MathExcel
- COUNTIFReturns a conditional count across a range.MathExcel
- COUNTIFSReturns the count of a range depending on multiple criteria.MathExcel
- COUNTUNIQUECounts the number of unique values in a list of specified values and ranges.MathNo Excel equivalent
- CSCReturns the cosecant of an angle provided in radians.MathExcel
- CSCHThe CSCH function returns the hyperbolic cosecant of any real number.MathExcel
- DECIMALThe DECIMAL function converts the text representation of a number in another base, to base 10 (decimal).MathExcel
- DEGREESConverts an angle value in radians to degrees.MathExcel
- ERFCReturns the complementary Gauss error function of a value.MathExcel
- ERFC.PRECISEReturns the complementary Gauss error function of a value.MathExcel
- EVENRounds a number up to the nearest even integer.MathExcel
- EXPReturns Euler's number, e (~2.718) raised to a power.MathExcel
- FACTReturns the factorial of a number.MathExcel
- FACTDOUBLEReturns the "double factorial" of a number.MathExcel
- FLOORRounds a number down to the nearest integer multiple of specified significance.MathExcel
- FLOOR.MATHRounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.MathExcel
- FLOOR.PRECISEThe FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance.MathExcel
- GAMMALNReturns the logarithm of a specified Gamma function, base e (Euler's number).MathExcel
- GAMMALN.PRECISEReturns the logarithm of a specified Gamma function, base e (Euler's number).MathExcel
- GCDReturns the greatest common divisor of one or more integers.MathExcel
- IMLNReturns the logarithm of a complex number, base e (Euler's number).MathExcel
- IMPOWERReturns a complex number raised to a power.MathExcel
- IMSQRTComputes the square root of a complex number.MathExcel
- INTRounds a number down to the nearest integer that is less than or equal to it.MathExcel
- ISEVENChecks whether the provided value is even.MathExcel
- ISO.CEILINGRounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up.MathExcel
- ISODDChecks whether the provided value is odd.MathExcel
- LCMReturns the least common multiple of one or more integers.MathExcel
- LNReturns the logarithm of a number, base e (Euler's number).MathExcel
- LOGReturns the logarithm of a number given a base.MathExcel
- LOG10Returns the logarithm of a number, base 10.MathExcel
- MODReturns the result of the modulo operator, the remainder after a division operation.MathExcel
- MROUNDRounds one number to the nearest integer multiple of another.MathExcel
- MULTINOMIALReturns the factorial of the sum of values divided by the product of the values' factorials.MathExcel
- MUNITReturns a unit matrix of size dimension x dimension.MathExcel
- ODDRounds a number up to the nearest odd integer.MathExcel
- PIReturns the value of Pi to 14 decimal places.MathExcel
- POWERReturns a number raised to a power.MathExcel
- PRODUCTReturns the result of multiplying a series of numbers together.MathExcel
- QUOTIENTReturns one number divided by another.MathExcel
- RADIANSConverts an angle value in degrees to radians.MathExcel
- RANDReturns a random number between 0 inclusive and 1 exclusive.MathExcel
- RANDARRAYGenerates an array of random numbers between 0 and 1.MathExcel
- RANDBETWEENReturns a uniformly random integer between two values, inclusive.MathExcel
- ROUNDRounds a number to a certain number of decimal places according to standard rules.MathExcel
- ROUNDDOWNRounds a number to a certain number of decimal places, always rounding down to the next valid increment.MathExcel
- ROUNDUPRounds a number to a certain number of decimal places, always rounding up to the next valid increment.MathExcel
- SECThe SEC function returns the secant of an angle, measured in radians.MathExcel
- SECHThe SECH function returns the hyperbolic secant of an angle.MathExcel
- SEQUENCEReturns an array of sequential numbers, such as 1, 2, 3, 4.MathExcel
- SERIESSUMGiven parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`.MathExcel
- SIGNGiven an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.MathExcel
- SINReturns the sine of an angle provided in radians.MathExcel
- SINHReturns the hyperbolic sine of any real number.MathExcel
- SQRTReturns the positive square root of a positive number.MathExcel
- SQRTPIReturns the positive square root of the product of Pi and the given positive number.MathExcel
- SUBTOTALReturns a subtotal for a vertical range of cells using a specified aggregation function.MathExcel
- SUMReturns the sum of a series of numbers and/or cells.MathExcel
- SUMIFReturns a conditional sum across a range.MathExcel
- SUMIFSReturns the sum of a range depending on multiple criteria.MathExcel
- SUMSQReturns the sum of the squares of a series of numbers and/or cells.MathExcel
- TANReturns the tangent of an angle provided in radians.MathExcel
- TANHReturns the hyperbolic tangent of any real number.MathExcel
- TRUNCTruncates a number to a certain number of significant digits by omitting less significant digits.MathExcel
More Google Sheets function categories