Excel Math and Trig Functions

The Excel math and trig functions are used to perform multiple mathematical calculations such as basic arithmetic calculations, conditional calculations, logarithm, and trigonometric equations.

Complete List of Excel Math and Trig Functions (A to Z)

All Excel Math and Trig functions are mentioned below in alphabetical order:

Function	Description
ABS Function	Absolute value of a number.
ACOS Function	Arccosine (inverse cosine) of a number.
ACOSH Function	Inverse hyperbolic cosine of a number.
ACOT Function	Arccotangent (inverse cotangent) of a number.
ACOTH Function	Hyperbolic arccotangent (inverse cotangent) of a number.
AGGREGATE Function	Aggregate in a list or database with the option to ignore hidden rows and error values.
ARABIC Function	Roman to Arabic number.
ASIN Function	Arcsine (inverse sine) of a number.
ASINH Function	Inverse hyperbolic sine of a number.
ATAN Function	Arctangent (inverse tangent) of a number.
ATAN2 Function	Arctangent (inverse tangent) from x- and y-coordinates.
ATANH Function	Inverse hyperbolic tangent of a number.
BASE Function	Number to a text representation of the specified radix (base).
CEILING Function	Number that is rounded to the nearest integer or nearest multiple of significance.
CEILING.MATH Function	Round the number to the nearest integer or nearest multiple of significance with the option to round negative numbers toward or away from zero.
CEILING.PRECISE Function	Regardless of the sign of the number, rounded to the nearest integer or nearest multiple of significance.
COMBIN Function	Number of combinations without repetitions for a given number of items.
COMBINA Function	Number of combinations with repetitions for a given number of items.
COS Function	Cosine of a number.
COSH Function	Hyperbolic cosine of a number.
COT Function	Cotangent of an angle specified in radians.
COTH Function	Hyperbolic cotangent of a number that is reciprocal of the hyperbolic tangent.
CSC Function	Cosecant of an angle specified in radians.
CSCH Function	Hyperbolic cosecant of an angle specified in radians.
DECIMAL Function	Converts a text representation of a number in a specified base into a decimal number.
DEGREES Function	Converts radians which are determined based on the radius of a circle into degrees.
EVEN Function	Rounds a number up to the nearest even number.
EXP Function	Value of e raised to the power of a specified number.
FACT Function	Factorial of a number.
FACTDOUBLE Function	Double factorial of a number.
FLOOR Function	Rounds a number down, towards zero and to the nearest multiple of a given significance.
FLOOR.MATH Function	Rounds a number down, to the nearest number or to the nearest multiple of a given significance.
FLOOR.PRECISE Function	Regardless of the sign of the number, the number is rounded down to the nearest number or to the nearest multiple of a given significance.
GCD Function	Greatest Common Divisor (GCD).
INT Function	Rounds down to the nearest integer although the decimal is closer to the next integer.
ISO.CEILING Function	Number rounded up to the nearest integer or to the nearest multiple of significance.
LCM Function	Least Common Multiple (LCM).
LN Function	Natural logarithm of a given number.
LOG Function	Logarithm of a number to a given base.
LOG10 Function	Base-10 logarithm of a given number.
MDETERM Function	Matrix determinant of a given array or range.
MINVERSE Function	Matrix inverse of a given array or range.
MMULT Function	Matrix product of two given arrays or ranges.
MOD Function	Remainder after one number (dividend) is divided by another (divisor).
MROUND Function	Rounds a number to the specified multiple.
MULTINOMINAL Function	Ratio of the factorial of a sum of given values to the product of factorials.
MUNIT Function	A unit matrix for a given dimension.
ODD Function	Round up the number to the nearest odd integer.
PI Function	Mathematical constant pi number as 3.14159265358979 (15 digits containing 14 decimals).
POWER Function	Number raised to a given power.
PRODUCT Function	Product (multiplication) of all the numbers given as arguments.
QUOTIENT Function	Divide the numeric values with numerator and denominator as arguments by ignoring the remainder.
RADIANS Function	Converts degrees into radians.
RANBETWEEN Function	Generate random number between two specified numbers.
RAND Function	Generate random number between 0 and 1.
RANDARRAY Function	Generate an array of random numbers between 0 and 1 with specified number of rows, columns, minimum and maximum values.
ROMAN Function	Converts an Arabic number to specified Roman text type.
ROUND Function	Rounds a number to a specified number of digits.
ROUNDDOWN Function	Rounds a number down to a specified number of digits.
ROUNDUP Function	Rounds a number up to a specified number of digits.
SEC Function	Secant of an angle.
SECH Function	Hyperbolic secant of an angle.
SEQUENCE Function	A list of sequential numbers in an array or range.
SERIESSUM Function	Sum of a power series.
SIGN Function	Sign of a number
SIN Function	Sine of an angle.
SINH Function	Hyperbolic sine of a number.
SQRT Function	Square root of a positive number.
SQRTPI Function	Square root of a positive number multiplied by pi.
SUBTOTAL Function	Subtotal from a range or array.
SUM Function	Add values.
SUMIF Function	Add values in a range that meet specified criteria.
SUMIFS Function	Add values in a range that meet multiple criteria.
SUMPRODUCT Function	Sum of the products of corresponding arrays or ranges.
SUMSQ Function	Sum of the squares of a given set of values.
SUMX2MY2 Function	Sum of the difference of squares between corresponding items in two arrays or ranges.
SUMX2PY2 Function	Sum of the sum of squares of corresponding items in two arrays or ranges.
SUMXMY2 Function	Sum of the squares of differences between corresponding items in two arrays or ranges.
TAN Function	Tangent of a number.
TANH Function	Hyperbolic tangent of a number.
TRUNC Function	Removes the fractional part of a number and truncates to an integer.