Returns the Multinomial of a given set of numbers
Returns the result of a given number raised to a supplied power
Returns the matrix determinant of a supplied array
Returns the inverse hyperbolic cosine of a number
Returns the natural logarithm of a given number
Returns the hyperbolic arccotangent of a number
Converts a text representation of a number in a specified base into a decimal number
Returns a random number between 0 and 1
Returns the absolute value (i.e. the modulus) of a supplied number
Returns the Hyperbolic Sine of a number
Returns a random number between two given integers
Returns the sum of squares of differences of corresponding values in two supplied arrays
Returns the hyperbolic cosine of a number
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
Rounds a number up to the nearest integer or to the nearest multiple of significance
Returns the arccotangent of a number
Performs a specified calculation (e.g. the sum, product, average, etc.) for a supplied set of values
Returns the positive square root of a given number
Returns the number of combinations (without repititions) for a given number of objects
Returns the sum of the squares of a supplied list of numbers
Adds the cells in a supplied range, that satisfy multiple criteria
HomeExcel-Built-In-Functions Excel-Math-Functions
Adds the cells in a supplied range, that satisfy a given criteria
Returns the number of combinations (with repetitions) for a given number of items
, regardless of the sign of the number, to a multiple of significance
Returns the Factorial of a given number
Converts a number into a text representation, with the supplied base
Converts a Roman numeral to an Arabic numeral
, to the nearest multiple of significance
, (i.e. rounds a positive number down and a negative number up), to a multiple of significance
(i.e. rounds a positive number up and a negative number down), to the next even number
, regardless of the sign of the number, to a multiple of significance.
Returns the Inverse Hyperbolic Sine of a number
Returns the hyperbolic cotangent of an angle
Returns the sum of a supplied list of numbers
Note that some of the Excel math functions listed below were introduced in recent versions of Excel, and so are not available in earlier versions.
Returns the product of a supplied list of numbers
(i.e. rounds a positive number up and a negative number down), to the next odd number
Further details of each of the Excel Math and Trig functions are provided on theMicrosoft Office Website.
Returns the Arctangent of a given pair of x and y coordinates
Returns the unit matrix for a specified dimension
Returns the square root of a supplied number multiplied by pi
Returns the sign (+1, -1 or 0) of a supplied number
(i.e. rounds a positive number up and a negative number down), to a multiple of significance
Rounds a number down, to the nearest integer or to the nearest multiple of significance
(i.e. rounds a positive number up and a negative number down), to a given number of digits
Returns the sum of the sum of squares of corresponding values in two supplied arrays
Returns the sum of the products of corresponding values in two or more supplied arrays
The Excel Math Functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios. Note that further math-related Excel functions are also provided in theExcel Statistical FunctionsandExcel Engineering Functionscategories.
Returns the Cosine of a given angle
, regardless of the sign of the number, to a multiple of significance
Returns the Tangent of a given angle
Returns the Double Factorial of a given number
Returns the hyperbolic cosecant of an angle
(i.e. rounds a positive number down and a negative number up), to the next integer.
Returns the Hyperbolic Tangent of a given number
, (i.e. rounds a positive number down and a negative number up), to a given number of digits
Returns the remainder from a division between two supplied numbers
Returns the Inverse Hyperbolic Tangent of a given number
Returns the matrix product of two supplied arrays
Returns the logarithm of a given number, to a specified base
Returns the sum of the difference of squares of corresponding values in two supplied arrays
Returns the integer portion of a division between two supplied numbers
Returns the base 10 logarithm of a given number
The tables below list all the current built-in Excel math functions, grouped by category, to help you to find the function you need. Selecting a function link will take you to a full description of the function, with examples of use and common errors.
Returns the Arctangent of a given number
Returns a text string depicting the roman numeral for a given number
Returns the hyperbolic secant of an angle
Returns the Least Common Multiple of two or more supplied numbers
Returns the Greatest Common Divisor of two or more supplied numbers
Returns the matrix inverse of a supplied array
