# Math and trigonometry functions (reference)

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 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.

### See Also

Expand your Office skills
Explore training Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

×