To get detailed information about a function, click its name in the first column.
Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.
Function  Description 

Returns the absolute value of a number 

Returns the arccosine of a number 

Returns the inverse hyperbolic cosine of a number 

Returns the arccotangent of a number 

Returns the hyperbolic arccotangent of a number 

Returns the aggregate in a list or database 

Converts a Roman number to Arabic, as a number 

Returns the arcsine of a number 

Returns the inverse hyperbolic sine of a number 

Returns the arctangent of a number 

Returns the arctangent from x and ycoordinates 

Returns the inverse hyperbolic tangent of a number 

Converts a number into a text representation with the given radix (base) 

Rounds a number to the nearest integer or to the nearest multiple of significance 

Rounds a number up, to the nearest integer or to the nearest multiple of significance 

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. 

Returns the number of combinations for a given number of objects 

Returns the number of combinations with repetitions for a given number of items 

Returns the cosine of a number 

Returns the hyperbolic cosine of a number 

Returns the cotangent of an angle 

Returns the hyperbolic cotangent of a number 

Returns the cosecant of an angle 

Returns the hyperbolic cosecant of an angle 

Converts a text representation of a number in a given base into a decimal number 

Converts radians to degrees 

Rounds a number up to the nearest even integer 

Returns e raised to the power of a given number 

Returns the factorial of a number 

Returns the double factorial of a number 

Rounds a number down, toward zero 

Rounds a number down, to the nearest integer or to the nearest multiple of significance 

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. 

Returns the greatest common divisor 

Rounds a number down to the nearest integer 

Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance 

Returns the least common multiple 

Returns the natural logarithm of a number 

Returns the logarithm of a number to a specified base 

Returns the base10 logarithm of a number 

Returns the matrix determinant of an array 

Returns the matrix inverse of an array 

Returns the matrix product of two arrays 

Returns the remainder from division 

Returns a number rounded to the desired multiple 

Returns the multinomial of a set of numbers 

Returns the unit matrix or the specified dimension 

Rounds a number up to the nearest odd integer 

Returns the value of pi 

Returns the result of a number raised to a power 

Multiplies its arguments 

Returns the integer portion of a division 

Converts degrees to radians 

Returns a random number between 0 and 1 

Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values. 

Returns a random number between the numbers you specify 

Converts an Arabic numeral to Roman, as text 

Rounds a number to a specified number of digits 

Rounds a number down, toward zero 

Rounds a number up, away from zero 

Returns the secant of an angle 

Returns the hyperbolic secant of an angle 

Returns the sum of a power series based on the formula 

Returns the sign of a number 

Returns the sine of the given angle 

Returns the hyperbolic sine of a number 

Returns a positive square root 

Returns the square root of (number * pi) 

Returns a subtotal in a list or database 

Adds its arguments 

Adds the cells specified by a given criteria 

Adds the cells in a range that meet multiple criteria 

Returns the sum of the products of corresponding array components 

Returns the sum of the squares of the arguments 

Returns the sum of the difference of squares of corresponding values in two arrays 

Returns the sum of the sum of squares of corresponding values in two arrays 

Returns the sum of squares of differences of corresponding values in two arrays 

Returns the tangent of a number 

Returns the hyperbolic tangent of a number 

Truncates a number to an integer 
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x8664 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.