# Complete List of Excel Math and Trig Functions, References and Examples

Excel Math Functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.

## Here’s a full list of Built-In Math and Trig Functions in Excel and their Descriptions below:

Click each of the function link to see detailed example.

 Basic Numeric Information ABS Returns the absolute value (i.e. the modulus) of a supplied number GCD Returns the Greatest Common Divisor of two or more supplied numbers LCM Returns the Least Common Multiple of two or more supplied numbers SIGN Returns the sign (+1, -1 or 0) of a supplied number Basic Mathematical Operations AGGREGATE Performs a specified calculation (e.g. the sum, product, average, etc.) for a list or database, with the option to ignore hidden rows and error values (New in Excel 2010) SUBTOTAL Performs a specified calculation (e.g. the sum, product, average, etc.) for a supplied set of values QUOTIENT Returns the integer portion of a division between two supplied numbers SQRT Returns the positive square root of a given number PRODUCT Returns the product of a supplied list of numbers MOD Returns the remainder from a division between two supplied numbers POWER Returns the result of a given number raised to a supplied power SUM Returns the sum of a supplied list of numbers Rounding Functions FLOOR.MATH Rounds a number down, to the nearest integer or to the nearest multiple of significance (New in Excel 2013) CEILING.MATH Rounds a number up to the nearest integer or to the nearest multiple of significance (New in Excel 2013) ROUNDUP Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a given number of digits CEILING Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a multiple of significance EVEN Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next even number ODD Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next odd number INT Rounds a number down to the next integer FLOOR.PRECISE Rounds a number down, regardless of the sign of the number, to a multiple of significance (New in Excel 2010) ROUNDDOWN Rounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a given number of digits FLOOR Rounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a multiple of significance ROUND Rounds a number up or down, to a given number of digits MROUND Rounds a number up or down, to the nearest multiple of significance CEILING.PRECISE Rounds a number up, regardless of the sign of the number, to a multiple of significance (New in Excel 2010) ISO.CEILING Rounds a number up, regardless of the sign of the number, to a multiple of significance. (New in Excel 2010) TRUNC Truncates a number towards zero (i.e. rounds a positive number down and a negative number up), to the next integer. Matrix Functions MDETERM Returns the matrix determinant of a supplied array MINVERSE Returns the matrix inverse of a supplied array MMULT Returns the matrix product of two supplied arrays MUNIT Returns the unit matrix for a specified dimension (New in Excel 2013) Random Numbers RAND Returns a random number between 0 and 1 RANDBETWEEN Returns a random number between two given integers Conditional Sums SUMIF Adds the cells in a supplied range, that satisfy a given criteria SUMIFS Adds the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007) Advanced Mathematical Operations SERIESSUM Returns the sum of a power series SUMXMY2 Returns the sum of squares of differences of corresponding values in two supplied arrays SUMX2MY2 Returns the sum of the difference of squares of corresponding values in two supplied arrays SUMPRODUCT Returns the sum of the products of corresponding values in two or more supplied arrays SUMSQ Returns the sum of the squares of a supplied list of numbers SUMX2PY2 Returns the sum of the sum of squares of corresponding values in two supplied arrays Trigonometry Functions RADIANS Converts Degrees to Radians DEGREES Converts Radians to Degrees ACOS Returns the Arccosine of a number ACOT Returns the arccotangent of a number (New in Excel 2013) ASIN Returns the Arcsine of a number ATAN Returns the Arctangent of a given number ATAN2 Returns the Arctangent of a given pair of x and y coordinates PI Returns the constant value of pi CSC Returns the cosecant of an angle (New in Excel 2013) COS Returns the Cosine of a given angle COT Returns the cotangent of an angle (New in Excel 2013) ACOTH Returns the hyperbolic arccotangent of a number (New in Excel 2013) CSCH Returns the hyperbolic cosecant of an angle (New in Excel 2013) COSH Returns the hyperbolic cosine of a number COTH Returns the hyperbolic cotangent of an angle (New in Excel 2013) SECH Returns the hyperbolic secant of an angle (New in Excel 2013) SINH Returns the Hyperbolic Sine of a number TANH Returns the Hyperbolic Tangent of a given number ACOSH Returns the inverse hyperbolic cosine of a number ASINH Returns the Inverse Hyperbolic Sine of a number ATANH Returns the Inverse Hyperbolic Tangent of a given number SEC Returns the secant of an angle (New in Excel 2013) SIN Returns the Sine of a given angle SQRTPI Returns the square root of a supplied number multiplied by pi TAN Returns the Tangent of a given angle Exponents & Logarithms LOG10 Returns the base 10 logarithm of a given number LOG Returns the logarithm of a given number, to a specified base LN Returns the natural logarithm of a given number EXP Returns e raised to a given power Factorials FACTDOUBLE Returns the Double Factorial of a given number FACT Returns the Factorial of a given number MULTINOMIAL Returns the Multinomial of a given set of numbers Miscellaneous BASE Converts a number into a text representation, with the supplied base (New in Excel 2013) ARABIC Converts a Roman numeral to an Arabic numeral (New in Excel 2013) DECIMAL Converts a text representation of a number in a specified base into a decimal number (New in Excel 2013) ROMAN Returns a text string depicting the roman numeral for a given number COMBINA Returns the number of combinations (with repetitions) for a given number of items (New in Excel 2013) COMBIN Returns the number of combinations (without repititions) for a given number of objects

Note: Further math-related Excel functions are also provided in the Excel Statistical Functions and Excel Engineering Functions categories.