Excel math functions
Math functions in Excel, explained with live examples.
80 math functions in Excel — 80 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 numberMathGoogle Sheets
- ACOSReturns the arccosine of a numberMathGoogle Sheets
- ACOSHReturns the inverse hyperbolic cosine of a numberMathGoogle Sheets
- ACOTReturns the arccotangent of a numberMathGoogle Sheets
- ACOTHReturns the hyperbolic arccotangent of a numberMathGoogle Sheets
- AGGREGATEReturns an aggregate in a list or databaseMathNo Google Sheets equivalent
- ARABICConverts a Roman number to Arabic, as a numberMathGoogle Sheets
- ASINReturns the arcsine of a numberMathGoogle Sheets
- ASINHReturns the inverse hyperbolic sine of a numberMathGoogle Sheets
- ATANReturns the arctangent of a numberMathGoogle Sheets
- ATAN2Returns the arctangent from x- and y-coordinatesMathGoogle Sheets
- ATANHReturns the inverse hyperbolic tangent of a numberMathGoogle Sheets
- BASEConverts a number into a text representation with the given radix (base)MathGoogle Sheets
- CEILING.MATHRounds a number up, to the nearest integer or to the nearest multiple of significanceMathGoogle Sheets
- CEILING.PRECISERounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.MathGoogle Sheets
- COMBINReturns the number of combinations for a given number of objectsMathGoogle Sheets
- COMBINAReturns the number of combinations with repetitions for a given number of itemsMathGoogle Sheets
- COSReturns the cosine of a numberMathGoogle Sheets
- COSHReturns the hyperbolic cosine of a numberMathGoogle Sheets
- COTReturns the hyperbolic cosine of a numberMathGoogle Sheets
- COTHReturns the cotangent of an angleMathGoogle Sheets
- CSCReturns the cosecant of an angleMathGoogle Sheets
- CSCHReturns the hyperbolic cosecant of an angleMathGoogle Sheets
- DECIMALConverts a text representation of a number in a given base into a decimal numberMathGoogle Sheets
- DEGREESConverts radians to degreesMathGoogle Sheets
- EVENRounds a number up to the nearest even integerMathGoogle Sheets
- EXPReturns e raised to the power of a given numberMathGoogle Sheets
- FACTReturns the factorial of a numberMathGoogle Sheets
- FACTDOUBLEReturns the double factorial of a numberMathGoogle Sheets
- FLOOR.MATHRounds a number down, to the nearest integer or to the nearest multiple of significanceMathGoogle Sheets
- FLOOR.PRECISERounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.MathGoogle Sheets
- GCDReturns the greatest common divisorMathGoogle Sheets
- INTRounds a number down to the nearest integerMathGoogle Sheets
- ISO.CEILINGReturns a number that is rounded up to the nearest integer or to the nearest multiple of significanceMathGoogle Sheets
- LCMReturns the least common multipleMathGoogle Sheets
- LNReturns the natural logarithm of a numberMathGoogle Sheets
- LOGReturns the logarithm of a number to a specified baseMathGoogle Sheets
- LOG10Returns the base-10 logarithm of a numberMathGoogle Sheets
- MDETERMReturns the matrix determinant of an arrayMathGoogle Sheets
- MINVERSEReturns the matrix inverse of an arrayMathGoogle Sheets
- MMULTReturns the matrix product of two arraysMathGoogle Sheets
- MODReturns the remainder from divisionMathGoogle Sheets
- MROUNDReturns a number rounded to the desired multipleMathGoogle Sheets
- MULTINOMIALReturns the multinomial of a set of numbersMathGoogle Sheets
- MUNITReturns the unit matrix or the specified dimensionMathGoogle Sheets
- ODDRounds a number up to the nearest odd integerMathGoogle Sheets
- PERCENTOFSums the values in the subset and divides it by all the valuesMathNo Google Sheets equivalent
- PIReturns the value of piMathGoogle Sheets
- POWERReturns the result of a number raised to a powerMathGoogle Sheets
- PRODUCTMultiplies its argumentsMathGoogle Sheets
- QUOTIENTReturns the integer portion of a divisionMathGoogle Sheets
- RADIANSConverts degrees to radiansMathGoogle Sheets
- RANDReturns a random number between 0 and 1MathGoogle Sheets
- RANDARRAYReturns 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.MathGoogle Sheets
- RANDBETWEENReturns a random number between the numbers you specifyMathGoogle Sheets
- ROMANConverts an arabic numeral to roman, as textMathGoogle Sheets
- ROUNDRounds a number to a specified number of digitsMathGoogle Sheets
- ROUNDDOWNRounds a number down, toward zeroMathGoogle Sheets
- ROUNDUPRounds a number up, away from zeroMathGoogle Sheets
- SECReturns the secant of an angleMathGoogle Sheets
- SECHReturns the hyperbolic secant of an angleMathGoogle Sheets
- SEQUENCEGenerates a list of sequential numbers in an array, such as 1, 2, 3, 4MathGoogle Sheets
- SERIESSUMReturns the sum of a power series based on the formulaMathGoogle Sheets
- SIGNReturns the sign of a numberMathGoogle Sheets
- SINReturns the sine of the given angleMathGoogle Sheets
- SINHReturns the hyperbolic sine of a numberMathGoogle Sheets
- SQRTReturns a positive square rootMathGoogle Sheets
- SQRTPIReturns the square root of (number * pi)MathGoogle Sheets
- SUBTOTALReturns a subtotal in a list or databaseMathGoogle Sheets
- SUMAdds its argumentsMathGoogle Sheets
- SUMIFAdds the cells specified by a given criteriaMathGoogle Sheets
- SUMIFSAdds the cells in a range that meet multiple criteriaMathGoogle Sheets
- SUMPRODUCTReturns the sum of the products of corresponding array componentsMathGoogle Sheets
- SUMSQReturns the sum of the squares of the argumentsMathGoogle Sheets
- SUMX2MY2Returns the sum of the difference of squares of corresponding values in two arraysMathGoogle Sheets
- SUMX2PY2Returns the sum of the sum of squares of corresponding values in two arraysMathGoogle Sheets
- SUMXMY2Returns the sum of squares of differences of corresponding values in two arraysMathGoogle Sheets
- TANReturns the tangent of a numberMathGoogle Sheets
- TANHReturns the hyperbolic tangent of a numberMathGoogle Sheets
- TRUNCTruncates a number to an integerMathGoogle Sheets
More Excel function categories