Math & Trigonometry Functions in Excel

Hello All. In this section, let’s look into all the Math and Trigonometry functions available in Excel. Here is the table with Syntax and Usage

 Function Usage  Syntax
 ABS  Returns absolute value of a number =ABS(number)
 ACOS  Returns the arccosine of a number (o to pi) =ACOS(number)
 ACOSH  Returns inverse hyperbolic cosine =ACOSH(number)
 ACOT  Returns the arccotangent of a number (0 to pi) =ACOT(number)
 ACOTH  Returns inverse hyperbolic cotangent =ACOTH(number)
 AGGREGATE  Returns the aggregate of list =AGGREGATE(Function_num, options, ref1, ref2,..)
 ARABIC  Converts roman numbers to Arabic numbers =ARABIC(text)
 ASIN  Returns arcsine of a number (-pi/2 to pi/2) =ASIN(number)
 ASINH  Returns inverse hyperbolic sine of a number =ASINH(number)
 ATAN  Returns arctangent of a number (-pi/2 to pi/2) =ATAN(number)
 ATAN2  Returns the arctangent of specified x and y co-ordinates (-pi to pi) =ATAN2(x_num,y_num)
 ATANH  Returns inverse hyperbolic tangent of a number =ATANH(number)
 BASE  Converts number into another base (ex: a given number to be converted to Binary representation) =BASE(number, radix, [min_length])
 CEILING.MATH  Rounds a number to the nearest integer =CEILING.MATH(number, [significance],[model])
 COMBIN  Returns the number of combinations for given number of items =COMBIN(number, number_chosen)
 COMBINA  Returns the number of combinations with repetitions for given number of items =COMBINA(number, number_chosen)
 COS  Returns the cosine of an angle =COS(number)
 COSH  Returns the hyperbolic cosine of a number =COSH(number)
 COT  Returns the cotangent of an angle =COT(number)
 COTH  Returns the hyperbolic cotangent of a number =COTH(number)
 CSC  Returns the cosecant of an angle =CSC(number)
 CSCH  Returns the hyperbolic cosecant of an angle =CSCH(number)
 DECIMAL  Converts alpha numeric number to decimal =DECIMAL(number, radix)
 DEGREES  Converts radians to degrees =DEGREES(angle)
 EVEN  Rounds a number to the next “even” integer  =EVEN(number)
 EXP  Returns the value of e (Euler’s number) raised to the power of a given number =EXP(num)
 FACT  Returns the factorial of a number =FACT(number)
 FACTDOUBLE  Returns the double factorial of a number =FACTDOUBLE(number)
 FLOOR.MATH  Rounds a number to the nearest multiple =FLOOR.MATH(number, [significance], [model])
 GCD  Returns the greatest common divisor =GCD(number1, [number2],..)
 INT  Rounds a number to nearest integer =INT(number)
 LCM  Returns the least common multiple =LCM(number1, [number2],..)
 LN  Returns the natural logarithm of a number =LN(number)
 LOG  Returns the logarithm of a number to the given base =LOG(number, [base])
 LOG10  Returns the base -10 logarithm of a number =LOG10(number)
 MDETERM  Returns the matrix determinant of an array =MDETERM(array)
 MINVERSE  Returns the inverse matrix for the matrix in an array =MINVERSE(array)
 MMULT  Returns matrix multiplication of two arrays =MMULT(array1,array2)
 MOD  Returns the remainder from division =MOD(number, divisor)
 MROUND  Rounds a number to desired multiple =MROUND(number,multiple)
 MULTINOMIAL  Returns the multinomial of a set of numbers =MULTINOMIAL(number1,[number2],..)
 MUNIT  Returns the unit matrix for the given dimension =MUNIT(dimension)
 ODD  Rounds a number to the nearest “odd” integer =ODD(number)
 PI  Returns the value of pi =PI()
 POWER  Returns the result of a number raised to a power =POWER(number, power)
 PRODUCT  Multiplies all the numbers =PRODUCT(num1, [num2],..)
 QUOTIENT  Returns the integer portion of a divison =QUOTIENT(numerator, denominator)
 RADIANS  Converts degrees to radians =RADIANS(angle)
 RAND  Returns a random number between 0 and 1 =RAND()
 RANDARRAY  Returns an array of random numbers =RANDARRAY([rows],[columns],[min],[max],[integer])
 RANDBETWEEN  Returns a random number between specified number =RANDBETWEEN(bottom,top)
 ROMAN  Converts arabic number into Roman, as text =ROMAN(number, [form])
 ROUND  Rounds a number to a specified number of digits =ROUND(number, num_digits)
 ROUNDDOWN  Round down to a given number of digits =ROUNDDOWN(number, num_digits)
 ROUNDUP  Round a number up to a given number of digits =ROUNDUP(number, num_digits)
 SEC  Returns the secant of an angle =SEC(number)
 SECH  Returns the hyperbolic secant of an angle =SECH(number)
 SEQUENCE  Returns a sequence of numbers =SEQUENCE(rows, [columns],[start],[step])
 SERIESSUM  Returns the sum of a power series =SERIESSUM(x,n,m,coefficients)
 SIGN  Returns the sign of a number =SIGN(number)
 SIN  Returns the sine of an angle =SIN(number)
 SINH  Returns the hyperbolic sine of a number =SINH(number)
 SQRT  Returns the square root of a number =SQRT(number)
 SQRTPI  Returns the square root of number*pi =SQRTPI(number)
 SUBTOTAL  Returns a subtotal in a list =SUBTOTAL(function_num, ref1, ref2,.)
 SUM  Adds all the numbers in a range =SUM(number1, [number2],..)
 SUMIF  Adds the cells specified by a condition =SUMIF(range, criteria, [sum_range])
 SUMIFS  Adds the cells specified by a set of conditions =SUMIFS(sum_range, criteria_range1, criteria1,..)
 SUMPRODUCT  Returns the sum of products in specified range =SUMPRODUCT(array1,[array2],[array3],..)
 SUMSQ  Returns the sum of the squares of the arguments =SUMSQ(number1, [number2],.)
 SUMX2MY2  Sums the difference between squares of two range / arrays =SUMX2MY2(array_x, array_y)
 SUMX2PY2  Returns the sum total of the sums of squares of numbers in corresponding ranges / arrays =SUMX2PY2(array_x,array_y)
 SUMXMY2  Sums the squares of the difference in two range / array =SUMXMY2(array_x, array_y)
 TAN  Returns the tangent of an angle =TAN(number)
 TANH  Returns the hyperbolic tangent of a number =TANH(number)
 TRUNC  Truncates a number to an integer by removing the decimal or fraction =TRUNC(number, [num_digits])
I hope you find this one pager helpful. Please provide us with your feedback that would help to improve the content. Thanks for reading.

Leave a Reply

%d bloggers like this: