English: Plot of y=x 2 made in Microsoft Excel...

Math Functions are provided by Excel, to carry out many of the common mathematical calculations, including basic arithmetic, conditional sums & products, and the trigonometric ratios. Mathematicians may also find the Statistical Functions and Engineering Functions useful.

The tables below list all the current built-in Excel math functions, grouped into categories, to help you to find the function you need. Note that some of the functions are new to Excel 2007 or Excel 2010, so are not available in earlier versions of Excel.

FunctionCategoryDescription
ABSBasic InformationReturns the absolute value of a number
ACOSTrig FunctionsReturns the arccosine of a number
ACOSHTrig FunctionsReturns the inverse hyperbolic cosine of a number
ACOTTrig FunctionsReturns the arccotangent of a number (New in Excel 2013)
ACOTHTrig FunctionsReturns the hyperbolic arccotangent of a number (New in Excel 2013)
AGGREGATEBasic Math OperationsReturns an aggregate in a list or database (New in Excel 2010)
ARABICMiscellaneousConverts a Roman number to Arabic, as a number (New in Excel 2013)
ASINTrig FunctionsReturns the arcsine of a number
ASINHTrig FunctionsReturns the inverse hyperbolic sine of a number
ATANTrig FunctionsReturns the arctangent of a number
ATAN2Trig FunctionsReturns the arctangent from x- and y-coordinates
ATANHTrig FunctionsReturns the inverse hyperbolic tangent of a number
BASEMiscellaneousConverts a number into a text representation with the given radix (base) (New in Excel 2013)
CEILINGRoundingRounds a number to the nearest integer or to the nearest multiple of significance
CEILING.MATHRoundingRounds a number up, to the nearest integer or to the nearest multiple of significance (New in Excel 2013)
CEILING.PRECISERoundingRounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. (New in Excel 2010)
COMBINMiscellaneousReturns the number of combinations for a given number of objects
COMBINAMiscellaneousReturns the number of combinations with repetitions for a given number of items (New in Excel 2013)
COSTrig FunctionsReturns the cosine of a number
COSHTrig FunctionsReturns the hyperbolic cosine of a number
COTTrig FunctionsReturns the cotangent of an angle (New in Excel 2013)
COTHTrig FunctionsReturns the hyperbolic cotangent of a number (New in Excel 2013)
CSCTrig FunctionsReturns the cosecant of an angle (New in Excel 2013)
CSCH Trig FunctionsReturns the hyperbolic cosecant of an angle (New in Excel 2013)
DECIMALMiscellaneousConverts a text representation of a number in a given base into a decimal number (New in Excel 2013)
DEGREESTrig FunctionsConverts radians to degrees
EVENRoundingRounds a number up to the nearest even integer
EXPExponents & LogsReturns e raised to the power of a given number
FACTFactorialsReturns the factorial of a number
FACTDOUBLEFactorialsReturns the double factorial of a number
FLOORRoundingRounds a number down, toward zero
FLOOR.MATHRoundingRounds a number down, to the nearest integer or to the nearest multiple of significance (New in Excel 2013)
FLOOR.PRECISERoundingRounds 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. (New in Excel 2010)
GCDBasic InformationReturns the greatest common divisor
INTRoundingRounds a number down to the nearest integer
ISO.CEILINGRoundingReturns a number that is rounded up to the nearest integer or to the nearest multiple of significance (New in Excel 2010)
LCMBasic InformationReturns the least common multiple
LNExponents & LogsReturns the natural logarithm of a number
LOGExponents & LogsReturns the logarithm of a number to a specified base
LOG10Exponents & LogsReturns the base-10 logarithm of a number
MDETERMMatrix FunctionReturns the matrix determinant of an array
MINVERSEMatrix FunctionReturns the matrix inverse of an array
MMULTMatrix FunctionReturns the matrix product of two arrays
MODBasic Math OperationsReturns the remainder from division
MROUNDRoundingReturns a number rounded to the desired multiple
MULTINOMIALFactorialsReturns the multinomial of a set of numbers
MUNITMatrix FunctionReturns the unit matrix or the specified dimension (New in Excel 2013)
ODDRoundingRounds a number up to the nearest odd integer
PITrig FunctionsReturns the value of pi
POWERBasic Math OperationsReturns the result of a number raised to a power
PRODUCTBasic Math OperationsMultiplies its arguments
QUOTIENTBasic Math OperationsReturns the integer portion of a division
RADIANSTrig FunctionsConverts degrees to radians
RANDRandom NumbersReturns a random number between 0 and 1
RANDBETWEENRandom NumbersReturns a random number between the numbers you specify
ROMANMiscellaneousConverts an Arabic numeral to Roman, as text
ROUNDRoundingRounds a number to a specified number of digits
ROUNDDOWNRoundingRounds a number down, toward zero
ROUNDUPRoundingRounds a number up, away from zero
SECTrig FunctionsReturns the secant of an angle (New in Excel 2013)
SECHTrig FunctionsReturns the hyperbolic secant of an angle (New in Excel 2013)
SERIESSUMAdvanced Math OperationsReturns the sum of a power series based on the formula
SIGNBasic InformationReturns the sign of a number
SINTrig FunctionsReturns the sine of the given angle
SINHTrig FunctionsReturns the hyperbolic sine of a number
SQRTBasic Math OperationsReturns a positive square root
SQRTPITrig FunctionsReturns the square root of (number * pi)
SUBTOTALBasic Math OperationsReturns a subtotal in a list or database
SUMBasic Math OperationsAdds its arguments
SUMIFConditional SumsAdds the cells specified by a given criteria
SUMIFSConditional SumsAdds the cells in a range that meet multiple criteria. (New in Excel 2007)
SUMPRODUCTAdvanced Math OperationsReturns the sum of the products of corresponding array components
SUMSQAdvanced Math OperationsReturns the sum of the squares of the arguments
SUMX2MY2Advanced Math OperationsReturns the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2Advanced Math OperationsReturns the sum of the sum of squares of corresponding values in two arrays
SUMXMY2Advanced Math OperationsReturns the sum of squares of differences of corresponding values in two arrays
TANTrig FunctionsReturns the tangent of a number
TANHTrig FunctionsReturns the hyperbolic tangent of a number
TRUNCRoundingTruncates a number to an integer