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.

Function | Category | Description |
---|---|---|

ABS | Basic Information | Returns the absolute value of a number |

ACOS | Trig Functions | Returns the arccosine of a number |

ACOSH | Trig Functions | Returns the inverse hyperbolic cosine of a number |

ACOT | Trig Functions | Returns the arccotangent of a number (New in Excel 2013) |

ACOTH | Trig Functions | Returns the hyperbolic arccotangent of a number (New in Excel 2013) |

AGGREGATE | Basic Math Operations | Returns an aggregate in a list or database (New in Excel 2010) |

ARABIC | Miscellaneous | Converts a Roman number to Arabic, as a number (New in Excel 2013) |

ASIN | Trig Functions | Returns the arcsine of a number |

ASINH | Trig Functions | Returns the inverse hyperbolic sine of a number |

ATAN | Trig Functions | Returns the arctangent of a number |

ATAN2 | Trig Functions | Returns the arctangent from x- and y-coordinates |

ATANH | Trig Functions | Returns the inverse hyperbolic tangent of a number |

BASE | Miscellaneous | Converts a number into a text representation with the given radix (base) (New in Excel 2013) |

CEILING | Rounding | Rounds a number to the nearest integer or to the nearest multiple of significance |

CEILING.MATH | Rounding | Rounds a number up, to the nearest integer or to the nearest multiple of significance (New in Excel 2013) |

CEILING.PRECISE | Rounding | Rounds 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) |

COMBIN | Miscellaneous | Returns the number of combinations for a given number of objects |

COMBINA | Miscellaneous | Returns the number of combinations with repetitions for a given number of items (New in Excel 2013) |

COS | Trig Functions | Returns the cosine of a number |

COSH | Trig Functions | Returns the hyperbolic cosine of a number |

COT | Trig Functions | Returns the cotangent of an angle (New in Excel 2013) |

COTH | Trig Functions | Returns the hyperbolic cotangent of a number (New in Excel 2013) |

CSC | Trig Functions | Returns the cosecant of an angle (New in Excel 2013) |

CSCH | Trig Functions | Returns the hyperbolic cosecant of an angle (New in Excel 2013) |

DECIMAL | Miscellaneous | Converts a text representation of a number in a given base into a decimal number (New in Excel 2013) |

DEGREES | Trig Functions | Converts radians to degrees |

EVEN | Rounding | Rounds a number up to the nearest even integer |

EXP | Exponents & Logs | Returns e raised to the power of a given number |

FACT | Factorials | Returns the factorial of a number |

FACTDOUBLE | Factorials | Returns the double factorial of a number |

FLOOR | Rounding | Rounds a number down, toward zero |

FLOOR.MATH | Rounding | Rounds a number down, to the nearest integer or to the nearest multiple of significance (New in Excel 2013) |

FLOOR.PRECISE | Rounding | Rounds 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) |

GCD | Basic Information | Returns the greatest common divisor |

INT | Rounding | Rounds a number down to the nearest integer |

ISO.CEILING | Rounding | Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance (New in Excel 2010) |

LCM | Basic Information | Returns the least common multiple |

LN | Exponents & Logs | Returns the natural logarithm of a number |

LOG | Exponents & Logs | Returns the logarithm of a number to a specified base |

LOG10 | Exponents & Logs | Returns the base-10 logarithm of a number |

MDETERM | Matrix Function | Returns the matrix determinant of an array |

MINVERSE | Matrix Function | Returns the matrix inverse of an array |

MMULT | Matrix Function | Returns the matrix product of two arrays |

MOD | Basic Math Operations | Returns the remainder from division |

MROUND | Rounding | Returns a number rounded to the desired multiple |

MULTINOMIAL | Factorials | Returns the multinomial of a set of numbers |

MUNIT | Matrix Function | Returns the unit matrix or the specified dimension (New in Excel 2013) |

ODD | Rounding | Rounds a number up to the nearest odd integer |

PI | Trig Functions | Returns the value of pi |

POWER | Basic Math Operations | Returns the result of a number raised to a power |

PRODUCT | Basic Math Operations | Multiplies its arguments |

QUOTIENT | Basic Math Operations | Returns the integer portion of a division |

RADIANS | Trig Functions | Converts degrees to radians |

RAND | Random Numbers | Returns a random number between 0 and 1 |

RANDBETWEEN | Random Numbers | Returns a random number between the numbers you specify |

ROMAN | Miscellaneous | Converts an Arabic numeral to Roman, as text |

ROUND | Rounding | Rounds a number to a specified number of digits |

ROUNDDOWN | Rounding | Rounds a number down, toward zero |

ROUNDUP | Rounding | Rounds a number up, away from zero |

SEC | Trig Functions | Returns the secant of an angle (New in Excel 2013) |

SECH | Trig Functions | Returns the hyperbolic secant of an angle (New in Excel 2013) |

SERIESSUM | Advanced Math Operations | Returns the sum of a power series based on the formula |

SIGN | Basic Information | Returns the sign of a number |

SIN | Trig Functions | Returns the sine of the given angle |

SINH | Trig Functions | Returns the hyperbolic sine of a number |

SQRT | Basic Math Operations | Returns a positive square root |

SQRTPI | Trig Functions | Returns the square root of (number * pi) |

SUBTOTAL | Basic Math Operations | Returns a subtotal in a list or database |

SUM | Basic Math Operations | Adds its arguments |

SUMIF | Conditional Sums | Adds the cells specified by a given criteria |

SUMIFS | Conditional Sums | Adds the cells in a range that meet multiple criteria. (New in Excel 2007) |

SUMPRODUCT | Advanced Math Operations | Returns the sum of the products of corresponding array components |

SUMSQ | Advanced Math Operations | Returns the sum of the squares of the arguments |

SUMX2MY2 | Advanced Math Operations | Returns the sum of the difference of squares of corresponding values in two arrays |

SUMX2PY2 | Advanced Math Operations | Returns the sum of the sum of squares of corresponding values in two arrays |

SUMXMY2 | Advanced Math Operations | Returns the sum of squares of differences of corresponding values in two arrays |

TAN | Trig Functions | Returns the tangent of a number |

TANH | Trig Functions | Returns the hyperbolic tangent of a number |

TRUNC | Rounding | Truncates a number to an integer |