This reference table lists all officially documented Math and Trigonometry Functions. It is based on the Excel Help documentation and linked in each row when clicking on the function name. Export the table and/or display additional columns via the symbols to the top right of the table. Please report errors or inconsistencies via the comment function at the bottom of this page. Also check the main table with List of all Excel Functions.
#  Excel Function  Description  Syntax with Arguments  Syntax only  Arguments only 

1  ABS  Returns the absolute value of a number  =ABS(numbernumber [required]: The real number of which you want the absolute value.)  =ABS(number) 

2  ACOS  Returns the arccosine, or inverse cosine, of a number  =ACOS(numbernumber [required]: The cosine of the angle you want and must be from 1 to 1.)  =ACOS(number) 

3  ACOSH  Returns the inverse hyperbolic cosine of a number  =ACOSH(numbernumber [required]: Any real number equal to or greater than 1.)  =ACOSH(number) 

4  ACOT  Returns the principal value of the arccotangent, or inverse cotangent, of a number  =ACOT(numbernumber [required]: Number is the cotangent of the angle you want.)  =ACOT(number) 

5  ACOT  Returns the inverse hyperbolic cotangent of a number  =ACOTH(numbernumber [required]: The absolute value of Number must be greater than 1.)  =ACOTH(number) 

6  AGGREGATE  Returns an aggregate in a list or database  =AGGREGATE(function_numfunction_num [required]: A number 1 to 19 that specifies which function to use., optionsoptions [required]: A numerical value that determines which values to ignore in the evaluation range for the function., ref1ref1 [required]: The first numeric argument for functions that take multiple numeric arguments for which you want the aggregate value., [ref2ref2 [optional]: Numeric arguments 2 to 253 for which you want the aggregate value.], ...)  =AGGREGATE(function_num, options, ref1, [ref2], ...) 

7  ARABIC  Converts a Roman numeral to an Arabic numeral  =ARABIC(texttext [required]: A string enclosed in quotation marks, an empty string (""), or a reference to a cell containing text.)  =ARABIC(text) 

8  ASIN  Returns the arcsine, or inverse sine, of a number  =ASIN(numbernumber [required]: The sine of the angle you want and must be from 1 to 1.)  =ASIN(number) 

9  ASINH  Returns the inverse hyperbolic sine of a number  =ASINH(numbernumber [required]: Any real number.)  =ASINH(number) 

10  ATAN  Returns the arctangent, or inverse tangent, of a number.  =ATAN(numbernumber [required]: The tangent of the angle you want.)  =ATAN(number) 

11  ATAN2  Returns the arctangent, or inverse tangent, of the specified x and ycoordinates  =ATAN2(x_numx_num [required]: The xcoordinate of the point., y_numy_num [required]: The ycoordinate of the point.)  =ATAN2(x_num, y_num) 

12  ATANH  Returns the inverse hyperbolic tangent of a number.  =ATANH(numbernumber [required]: Any real number between 1 and 1.)  =ATANH(number) 

13  BASE  Converts a number into a text representation with the given radix (base)  =BASE(numbernumber [required]: The number that you want to convert., radixradix [required]: The base radix that you want to convert the number into., [min_lengthmin_length [optional]: The minimum length of the returned string.])  =BASE(number, radix, [min_length]) 

14  CEILING  Returns number rounded up, away from zero, to the nearest multiple of significance  =CEILING(numbernumber [required]: Value you want to round., significancesignificance [required]: Multiple to which you want to round.)  =CEILING(number, significance) 

15  CEILING.MATH  Rounds a number up to the nearest integer or to the nearest multiple of significance  =CEILING.MATH(numbernumber [required]: Number must be less than 9., [significancesignificance [optional]: The multiple to which Number is to be rounded.], [modemode [optional]: For negative numbers, controls whether Number is rounded toward or away from zero.])  =CEILING.MATH(number, [significance], [mode]) 

16  CEILING.PRECISE  Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance  =CEILING.PRECISE(numbernumber [required]: The value to be rounded., [significancesignificance [optional]: The multiple to which number is to be rounded.])  =CEILING.PRECISE(number, [significance]) 

17  COMBIN  Returns the number of combinations for a given number of items  =COMBIN(numbernumber [required]: The number of items., number_chosennumber_chosen [required]: The number of items in each combination.)  =COMBIN(number, number_chosen) 

18  COMBINA  Returns the number of combinations (with repetitions) for a given number of items  =COMBINA(numbernumber [required]: Must be greater than or equal to 0, and greater than or equal to Number_chosen., number_chosennumber_chosen [required]: Must be greater than or equal to 0.)  =COMBINA(number, number_chosen) 

19  COS  Returns the cosine of the given angle  =COS(numbernumber [required]: The angle in radians for which you want the cosine.)  =COS(number) 

20  COSH  Returns the hyperbolic cosine of a number  =COSH(numbernumber [required]: Any real number for which you want to find the hyperbolic cosine.)  =COSH(number) 

21  COT  Return the cotangent of an angle specified in radians  =COT(numbernumber [required]: The angle in radians for which you want the cotangent.)  =COT(number) 

22  COTH  Return the hyperbolic cotangent of a hyperbolic angle  =COTH(numbernumber [required]: Number from which to calculate hyperbolic cotangent.)  =COTH(number) 

23  CSC  Returns the cosecant of an angle specified in radians  =CSC(numbernumber [required]: Number from wich to calculate cosecant.)  =CSC(number) 

24  CSCH  Return the hyperbolic cosecant of an angle specified in radians  =CSCH(numbernumber [required]: Number from wich to calculate hyperbolic cosecant.)  =CSCH(number) 

25  DECIMAL  Converts a text representation of a number in a given base into a decimal number  =DECIMAL(texttext [required]: Text representation of a number., radixradix [required]: Radix must be an integer.)  =DECIMAL(text, radix) 

26  DEGREES  Converts radians into degrees  =DEGREES(angleangle [required]: The angle in radians that you want to convert.)  =DEGREES(angle) 

27  EVEN  Returns number rounded up to the nearest even integer  =EVEN(numbernumber [required]: The value to round.)  =EVEN(number) 

28  EXP  Returns e raised to the power of number  =EXP(numbernumber [required]: The exponent applied to the base e.)  =EXP(number) 

29  FACT  Returns the factorial of a number  =FACT(numbernumber [required]: The nonnegative number for which you want the factorial.)  =FACT(number) 

30  FACTDOUBLE  Returns the double factorial of a number  =FACTDOUBLE(numbernumber [required]: The value for which to return the double factorial.)  =FACTDOUBLE(number) 

31  FLOOR.MATH  Round a number down to the nearest integer or to the nearest multiple of significance  =FLOOR.MATH(numbernumber [required]: The number to be rounded down., significancesignificance [required]: The multiple to which you want to round., modemode [required]: The direction (toward or away from 0) to round negative numbers.)  =FLOOR.MATH(number, significance, mode) 

32  FLOOR.PRECISE  Returns a number that is rounded down to the nearest integer or to the nearest multiple of significance  =FLOOR.PRECISE(numbernumber [required]: The value to be rounded., [significancesignificance [optional]: The multiple to which number is to be rounded.])  =FLOOR.PRECISE(number, [significance]) 

33  GCD  Returns the greatest common divisor of two or more integers  =GCD(number1number1 [required]: The first number from which to determine the greatest common divisor of two or more integer, [number2number2 [optional]: Additional optional numbers], ...)  =GCD(number1, [number2], ...) 

34  INT  Rounds a number down to the nearest integer  =INT(numbernumber [required]: The real number you want to round down to an integer.)  =INT(number) 

35  ISO.CEILING  Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance  =ISO.CEILING(numbernumber [required]: The value to be rounded., [significancesignificance [optional]: The optional multiple to which number is to be rounded.])  =ISO.CEILING(number, [significance]) 

36  LCM  Returns the least common multiple of integers  =LCM(number1number1 [required]: Number for which you want the least common multiple. , [number2number2 [optional]: Additional optional numbers.], ...)  =LCM(number1, [number2], ...) 

37  LET  Assigns names to calculation results to allows storing intermediate calculations, values, or defining names inside a formula  =LET(namename [required]: Name to assign, name_valuename_value [required]: Value calculation to assign to value, calculationcalculation [required]: Calculation for assigned names/ values)  =LET(name, name_value, calculation) 

38  LN  Returns the natural logarithm of a number  =LN(numbernumber [required]: The positive real number for which you want the natural logarithm.)  =LN(number) 

39  LOG  Returns the logarithm of a number to the base you specify  =LOG(numbernumber [required]: The positive real number for which you want the logarithm., [basebase [optional]: The base of the logarithm.])  =LOG(number, [base]) 

40  LOG10  Returns the base10 logarithm of a number  =LOG10(numbernumber [required]: The positive real number for which you want the base10 logarithm.)  =LOG10(number) 

41  MDETERM  Returns the matrix determinant of an array  =MDETERM(arrayarray [required]: A numeric array with an equal number of rows and columns.)  =MDETERM(array) 

42  MINVERSE  Returns the inverse matrix for a matrix stored in an array  =MINVERSE(arrayarray [required]: A numeric array with an equal number of rows and columns.)  =MINVERSE(array) 

43  MMULT  Returns the matrix product of two arrays  =MMULT(array1array1 [required]: The first arrays you want to multiply., array2array2 [required]: The second arrays you want to multiply.)  =MMULT(array1, array2) 

44  MOD  Returns the remainder after number is divided by divisor  =MOD(numbernumber [required]: The number for which you want to find the remainder., divisordivisor [required]: The number by which you want to divide number.)  =MOD(number, divisor) 

45  MROUND  Returns a number rounded to the desired multiple  =MROUND(numbernumber [required]: The value to round., multiplemultiple [required]: The multiple to which you want to round number.)  =MROUND(number, multiple) 

46  MULTINOMIAL  Returns the ratio of the factorial of a sum of values to the product of factorials  =MULTINOMIAL(number1, [number2], ...)  =MULTINOMIAL(number1, [number2], ...)  
47  MUNIT  Returns the unit matrix for the specified dimension  =MUNIT(dimensiondimension [required]: Dimension is an integer specifying the dimension of the unit matrix that you want to return. It returns an array. The dimension has to be greater than zero.)  =MUNIT(dimension) 

48  ODD  Returns number rounded up to the nearest odd integer  =ODD(numbernumber [required]: The value to round.)  =ODD(number) 

49  PI  Returns pi (3.14159265358979) with 15 digits  =PI()  =PI()  
50  POWER  Returns the result of a number raised to a power  =POWER(numbernumber [required]: The base number., powerpower [required]: The exponent to which the base number is raised.)  =POWER(number, power) 

51  PRODUCT  Multiplies all the numbers given as arguments and returns the product.  =PRODUCT(number1number1 [required]: The first number or range that you want to multiply., [number2], ...)  =PRODUCT(number1, [number2], ...) 

52  QUOTIENT  Returns the integer portion of a division  =QUOTIENT(numeratornumerator [required]: The dividend., denominatordenominator [required]: The divisor)  =QUOTIENT(numerator, denominator) 

53  RADIANS  Converts degrees to radians  =RADIANS(angleangle [required]: An angle in degrees that you want to convert.)  =RADIANS(angle) 

54  RAND  Converts degrees to radians  =RAND()  =RAND()  
55  RANDARRAY  Returns an array of random numbers.  =RANDARRAY([rowsrows [optional]: The number of rows to be returned], [columnscolumns [optional]: The number of columns to be returned], [minmin [optional]: The minimum number you would like returned], [maxmax [optional]: The maximum number you would like returned], [whole_numberwhole_number [optional]: Return a whole number or a decimal value])  =RANDARRAY([rows], [columns], [min], [max], [whole_number]) 

56  RANDBETWEEN  Returns a random integer number between the numbers you specify  =RANDBETWEEN(bottombottom [required]: The smallest integer RANDBETWEEN will return., toptop [required]: The largest integer RANDBETWEEN will return.)  =RANDBETWEEN(bottom, top) 

57  ROMAN  Converts an arabic numeral to roman, as text  =ROMAN(numbernumber [required]: The Arabic numeral you want converted., [formform [optional]: A number specifying the type of roman numeral you want.])  =ROMAN(number, [form]) 

58  ROUND  Rounds a number to a specified number of digits  =ROUND(numbernumber [required]: The number that you want to round., num_digitsnum_digits [required]: The number of digits to which you want to round the number argument.)  =ROUND(number, num_digits) 

59  ROUNDDOWN  Rounds a number down, toward zero  =ROUNDDOWN(numbernumber [required]: Any real number that you want rounded down., num_digitsnum_digits [required]: The number of digits to which you want to round number.)  =ROUNDDOWN(number, num_digits) 

60  ROUNDUP  Rounds a number up, away from 0 (zero)  =ROUNDUP(numbernumber [required]: Any real number that you want rounded up., num_digitsnum_digits [required]: The number of digits to which you want to round number.)  =ROUNDUP(number, num_digits) 

61  SEC  Returns the secant of an angle  =SEC(numbernumber [required]: Number is the angle in radians for which you want the secant.)  =SEC(number) 

62  SECH  Returns the hyperbolic secant of an angle  =SECH(numbernumber [required]: Number is the angle in radians for which you want the hyperbolic secant.)  =SECH(number) 

63  SEQUENCE  Generates a list of sequential numbers in an array, such as 1, 2, 3, 4  =SEQUENCE(rowsrows [required]: The number of rows to be returned, [columnscolumns [required]: The number of columns to be returned], [startstart [optional]: Sequence start value], [stepstep [optional]: Sequence Increments])  =SEQUENCE(rows, [columns], [start], [step]) 

64  SERIESSUM  Returns the sum of a power series based on approximation by defined power series expansion formula  =SERIESSUM(xx [required]: The input value to the power series., nn [required]: The initial power to which you want to raise x., mm [required]: The step by which to increase n for each term in the series., coefficientscoefficients [required]: A set of coefficients by which each successive power of x is multiplied.)  =SERIESSUM(x, n, m, coefficients) 

65  SIGN  Determines the sign of a number  =SIGN(numbernumber [required]: Any real number.)  =SIGN(number) 

66  SIN  Returns the sine of the given angle  =SIN(numbernumber [required]: The angle in radians for which you want the sine.)  =SIN(number) 

67  SINH  Returns the hyperbolic sine of a number  =SINH(numbernumber [required]: Any real number.)  =SINH(number) 

68  SQRT  Returns a positive square root  =SQRT(numbernumber [required]: The number for which you want the square root.)  =SQRT(number) 

69  SQRTPI  Returns the square root of (number * pi)  =SQRTPI(numbernumber [required]: The number by which pi is multiplied.)  =SQRTPI(number) 

70  SUBTOTAL  Returns a subtotal in a list or database  =SUBTOTAL(function_numfunction_num [required]: The number 111 or 101111 that specifies the function to use for the subtotal., ref1ref1 [required]: The first named range or reference for which you want the subtotal., [ref2ref2 [optional]: Additional optional references], ...)  =SUBTOTAL(function_num, ref1, [ref2], ...) 

71  SUM  Adds values, cell references or ranges or a mix of all three  =SUM(number1number1 [required]: First number to add,[number2number2 [optional]: Additional optional numbers],...)  =SUM(number1,[number2],...) 

72  SUMIF  Sum the values in a range that meet criteria that you specify  =SUMIF(rangerange [required]: The range of cells that you want evaluated by criteria., criteriacriteria [required]: The criteria in the form of a number, expression, a cell reference, text, or a function that defines which cells will be added., [sum_rangesum_range [optional]: The actual cells to add, if you want to add cells other than those specified in the range argument.])  =SUMIF(range, criteria, [sum_range]) 

73  SUMIFS  Sums all of its arguments that meet multiple criteria.  =SUMIFS(sum_rangesum_range [required]: The range of cells to sum., criteria_range1criteria_range1 [optional]: The range that is tested using CRITERIA1, criteria1criteria1 [optional]: The criteria that defines which cells in CRITERIA_RANGE1 will be added., [criteria_range2, criteria2criteria_range2, criteria2 [optional]: Additional optional critiera and criteria ranges], ...)  =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) 

74  SUMPRODUCT  Returns the sum of the products of corresponding ranges or arrays  =SUMPRODUCT(array1array1 [required]: The first array argument whose components you want to multiply and then add., [array2array2 [optional]: Additional optional array argument], ...)  =SUMPRODUCT(array1, [array2], ...) 

75  SUMSQ  Returns the sum of the squares of the arguments  =SUMSQ(number1number1 [required]: Number arguments for which you want the sum of the squares, [number2number2 [optional]: Additional optional numbers], ...)  =SUMSQ(number1, [number2], ...) 

76  SUMX2MY2  Returns the sum of the difference of squares of corresponding values in two arrays  =SUMX2MY2(array_xarray_x [required]: The first array or range of values., array_yarray_y [required]: The second array or range of values.)  =SUMX2MY2(array_x, array_y) 

77  SUMX2PY2  Returns the sum of the sum of squares of corresponding values in two arrays  =SUMX2PY2(array_xarray_x [required]: The first array or range of values., array_yarray_y [required]: The second array or range of values.)  =SUMX2PY2(array_x, array_y) 

78  SUMXMY2  Returns the sum of squares of differences of corresponding values in two arrays  =SUMXMY2(array_xarray_x [required]: The first array or range of values., array_yarray_y [required]: The second array or range of values.)  =SUMXMY2(array_x, array_y) 

79  TAN  Returns the tangent of the given angle  =TAN(numbernumber [required]: The angle in radians for which you want the tangent.)  =TAN(number) 

80  TANH  Returns the hyperbolic tangent of a number  =TANH(numbernumber [required]: Any real number.)  =TANH(number) 

81  TRUNC  Truncates a number to an integer by removing the fractional part of the number  =TRUNC(numbernumber [required]: The number you want to truncate., [num_digitsnum_digits [optional]: A number specifying the precision of the truncation.])  =TRUNC(number, [num_digits]) 

Created by admin on 2/9/2021
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy
0 Comments for '(Excel)  List of Excel Math and Trigonometry Functions with Syntax and Arguments' [post comment in main thread]