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.
Try itMath & 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.