Excel Math Functions

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

Excel Math Functions

Leave a Reply