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.