Math and Trig Formulas in Excel

Absolute value of a number.

Arccosine (inverse cosine) of a number.

Inverse hyperbolic cosine of a number.

Arccotangent (inverse cotangent) of a number.

Hyperbolic arccotangent (inverse cotangent) of a number.

Aggregate in a list or database with the option to ignore hidden rows and error values.

Roman to Arabic number.

Arcsine (inverse sine) of a number.

Inverse hyperbolic sine of a number.

Arctangent (inverse tangent) of a number.

Arctangent (inverse tangent) from x- and y-coordinates.

Inverse hyperbolic tangent of a number.

Number to a text representation of the specified radix (base).

Number that is rounded to the nearest integer or nearest multiple of significance.

Round the number to the nearest integer or nearest multiple of significance with the option to round neagtive numbers toward or away from zero.

Regardless of the sign of the number, rounded to the nearest integer or nearest multiple of significance.

Number of combinations without repetitions for a given number of items.

Number of combinations with repetitions for a given number of items.

Cosine of a number.

Hyperbolic cosine of a number.

Cotangent of an angle specified in radians.

Hyperbolic cotangent of a number that is reciprocal of the hyperbolic tangent.

Cosecant of an angle specified in radians.

Hyperbolic cosecant of an angle specified in radians.

Converts a text representation of a number in a specified base into a decimal number.

Converts radians which are determined based on the radius of a circle into degrees.

Rounds a number up to the nearest even number.

Value of e raised to the power of a specified number.

Factorial of a number.

Double factorial of a number.

Rounds a number down, towards zero and to the nearest multiple of a given significance.

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

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.

Greatest Common Divisor (GCD).

Rounds down to the nearest integer although the decimal is closer to the next integer.

Number rounded up to the nearest integer or to the nearest multiple of significance.

Least Common Multiple (LCM).

Natural logarithm of a given number.

Logarithm of a number to a given base.

Base-10 logarithm of a given number.

Matrix determinant of a given array or range.

Matrix inverse of a given array or range.

Matrix product of two given arrays or ranges.

Remainder after one number (dividend) is divided by another (divisor).

Rounds a number to the specified multiple.

Ratio of the factorial of a sum of given values to the product of factorials.

A unit matrix for a given dimension.

Round up the number to the nearest odd integer.

Mathematical constant pi number as 3.14159265358979 (15 digits containing 14 decimals).

Number raised to a given power.

Product (multiplication) of all the numbers given as arguments.

Divide the numeric values with numerator and denominator as arguments by ignoring the remainder.

Converts degrees into radians.

Generate random number between 0 and 1.

Generate an array of random numbers between 0 and 1 with specified number of rows, columns, minimum and maximum values.

Generate random number between two specified numbers.

Converts an Arabic number to specified Roman text type.

Rounds a number to a specified number of digits.

Rounds a number down to a specified number of digits.

Rounds a number up to a specified number of digits.

Secant of an angle.

Hyperbolic secant of an angle.

A list of sequential numbers in an array or range.

Sum of a power series.

Sign of a number

Sine of an angle.

Hyperbolic sine of a number.

Square root of a positive number.

Square root of a positive number muliplied by pi.

Subtotal from a range or array.

Add values.

Add values in a range that meet specified criteria.

Add values in a range that meet multiple criteria.

Sum of the products of corresponding arrays or ranges.

Sum of the squares of a given set of values.

Sum of the difference of squares between corresponding items in two arrays or ranges.

Sum of the sum of squares of correcsponding items in two arrays or ranges.

Sum of the squares of differences between corresponding items in two arrays or ranges.

Tangent of a number.

Hyperbolic tangent of a number.

Removes the fractional part of a number and truncates to an integer.