Excel functions

Every Excel function (476), organized by category. Arguments in [brackets] are optional.

Formula Explainer · Paste any formula and see it broken down step by step. Free.

Math & Trig (81)

=ABS(number)

Returns the absolute value of a number.

=ACOS(number)

Returns the arccosine of a number.

=ACOSH(number)

Returns the inverse hyperbolic cosine of a number.

=ACOT(number)

Returns the arccotangent of a number.

=ACOTH(number)

Returns the hyperbolic arccotangent of a number.

=AGGREGATE(function_num, options, ref1, [ref2], ...)

Returns an aggregate in a list or database.

=ARABIC(text)

Converts a Roman number to Arabic, as a number.

=ASIN(number)

Returns the arcsine of a number.

=ASINH(number)

Returns the inverse hyperbolic sine of a number.

=ATAN(number)

Returns the arctangent of a number.

=ATAN2(x_num, y_num)

Returns the arctangent from x- and y-coordinates.

=ATANH(number)

Returns the inverse hyperbolic tangent of a number.

=BASE(Number, Radix [Min_length])

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

=CEILING(number, significance)

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

=CEILING.MATH(number, [significance], [mode])

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

=CEILING.PRECISE(number, [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.

=COMBIN(number, number_chosen)

Returns the number of combinations for a given number of objects.

=COMBINA(number, number_chosen)

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

=COS(number)

Returns the cosine of a number.

=COSH(number)

Returns the hyperbolic cosine of a number.

=COT(number)

Returns the cotangent of an angle.

=COTH(number)

Returns the hyperbolic cotangent of a number.

=CSC(number)

Returns the cosecant of an angle.

=CSCH(number)

Returns the hyperbolic cosecant of an angle.

=DECIMAL(text, radix)

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

=DEGREES(angle)

Converts radians to degrees.

=EVEN(number)

Rounds a number up to the nearest even integer.

=EXP(number)

Returns e raised to the power of a given number.

=FACT(number)

Returns the factorial of a number.

=FACTDOUBLE(number)

Returns the double factorial of a number.

=FLOOR.MATH(number, significance, mode)

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

=FLOOR.PRECISE(number, [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.

=GCD(number1, [number2], ...)

Returns the greatest common divisor.

=INT(number)

Rounds a number down to the nearest integer.

=ISO.CEILING(number, [significance])

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

=LCM(number1, [number2], ...)

Returns the least common multiple.

=LN(number)

Returns the natural logarithm of a number.

=LOG(number, [base])

Returns the logarithm of a number to a specified base.

=LOG10(number)

Returns the base-10 logarithm of a number.

=MDETERM(array)

Returns the matrix determinant of an array.

=MINVERSE(array)

Returns the matrix inverse of an array.

=MMULT(array1, array2)

Returns the matrix product of two arrays.

=MOD(number, divisor)

Returns the remainder from division.

=MROUND(number, multiple)

Returns a number rounded to the desired multiple.

=MULTINOMIAL(number1, [number2], ...)

Returns the multinomial of a set of numbers.

=MUNIT(dimension)

Returns the unit matrix or the specified dimension.

=ODD(number)

Rounds a number up to the nearest odd integer.

=PERCENTOF(data_subset, data_all)

Sums the values in the subset and divides it by all the values.

=PI()

Returns the value of pi.

=POWER(number, power)

Returns the result of a number raised to a power.

=PRODUCT(number1, [number2], ...)

Multiplies its arguments.

=QUOTIENT(numerator, denominator)

Returns the integer portion of a division.

=RADIANS(angle)

Converts degrees to radians.

=RAND()

Returns a random number between 0 and 1.

=RANDARRAY([rows], [columns], [min], [max], [integer])

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.

=RANDBETWEEN(bottom, top)

Returns a random number between the numbers you specify.

=ROMAN(number, [form])

Converts an Arabic numeral to Roman, as text.

=ROUND(number, num_digits)

Rounds a number to a specified number of digits.

=ROUNDDOWN(number, num_digits)

Rounds a number down, toward zero.

=ROUNDUP(number, num_digits)

Rounds a number up, away from zero.

=SEC(number)

Returns the secant of an angle.

=SECH(number)

Returns the hyperbolic secant of an angle.

=SEQUENCE(rows, [columns], [start], [step])

Generates a list of sequential numbers in an array, such as 1, 2, 3, 4.

=SERIESSUM(x, n, m, coefficients)

Returns the sum of a power series based on the formula.

=SIGN(number)

Returns the sign of a number.

=SIN(number)

Returns the sine of the given angle.

=SINH(number)

Returns the hyperbolic sine of a number.

=SQRT(number)

Returns a positive square root.

=SQRTPI(number)

Returns the square root of (number * pi).

=SUBTOTAL(function_num, ref1, [ref2], ...)

Returns a subtotal in a list or database.

=SUM(number1, [number2], ...)

Adds its arguments.

=SUMIF(range, criteria, [sum_range])

Adds the cells specified by a given criteria.

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Adds the cells in a range that meet multiple criteria.

=SUMPRODUCT(array1, [array2], [array3], ...)

Returns the sum of the products of corresponding array components.

=SUMSQ(number1, [number2], ...)

Returns the sum of the squares of the arguments.

=SUMX2MY2(array_x, array_y)

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

=SUMX2PY2(array_x, array_y)

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

=SUMXMY2(array_x, array_y)

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

=TAN(number)

Returns the tangent of a number.

=TANH(number)

Returns the hyperbolic tangent of a number.

=TRUNC(number, [num_digits])

Truncates a number to an integer.