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.