# 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.