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.