Hello,
Select a different account.
You have multiple accounts

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 ACOT function Returns the arccotangent of a number ACOTH function Returns the hyperbolic arccotangent of a number Returns the aggregate in a list or database ARABIC function 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 y-coordinates Returns the inverse hyperbolic tangent of a number BASE function 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 CEILING.MATH function 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 COMBINA function 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 COT function Returns the cotangent of an angle COTH function Returns the hyperbolic cotangent of a number CSC function Returns the cosecant of an angle CSCH function Returns the hyperbolic cosecant of an angle DECIMAL function 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 FLOOR.MATH function 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 ISO.CEILING function 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 base-10 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 MUNIT function 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 SEC function Returns the secant of an angle SECH function 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 x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

Excel functions (by category)

Excel functions (alphabetical)

### Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.        