”;
The Excel Math & Trig functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.
Some more math-related functions are also discussed in the Statistical functions and Engineering functions categories.
Math and Trigonometric Functions
The following table lists all the Math & Trigonometric functions −
| S.No. | Function and Description |
|---|---|
| 1 | ABS
Returns the absolute value of a number |
| 2 | ACOS
Returns the arccosine of a number |
| 3 | ACOSH
Returns the inverse hyperbolic cosine of a number |
| 4 | ACOT
Returns the arccotangent of a number |
| 5 | ACOTH
Returns the hyperbolic arccotangent of a number |
| 6 | AGGREGATE
Returns an aggregate in a list or database |
| 7 | ARABIC
Converts a Roman number to Arabic, as a number |
| 8 | ASIN
Returns the arcsine of a number |
| 9 | ASINH
Returns the inverse hyperbolic sine of a number |
| 10 | ATAN
Returns the arctangent of a number |
| 11 | ATAN2
Returns the arctangent from x and y coordinates |
| 12 | ATANH
Returns the inverse hyperbolic tangent of a number |
| 13 | BASE
Converts a number into a text representation with the given radix (base) |
| 14 | CEILING.MATH
Rounds a number up, to the nearest integer or to the nearest multiple of significance |
| 15 | COMBIN
Returns the number of combinations for a given number of objects |
| 16 | COMBINA
Returns the number of combinations with repetitions for a given number of items |
| 17 | COS
Returns the cosine of a number |
| 18 | COSH
Returns the hyperbolic cosine of a number |
| 19 | COT
Returns the cotangent of an angle |
| 20 | COTH
Returns the hyperbolic cotangent of a number |
| 21 | CSC
Returns the cosecant of an angle |
| 22 | CSCH
Returns the hyperbolic cosecant of an angle |
| 23 | DECIMAL
Converts a text representation of a number in a given base into a decimal number |
| 24 | DEGREES
Converts radians to degrees |
| 25 | EVEN
Rounds a number up to the nearest even integer |
| 26 | EXP
Returns e raised to the power of a given number |
| 27 | FACT
Returns the factorial of a number |
| 28 | FACTDOUBLE
Returns the double factorial of a number |
| 29 | FLOOR.MATH
Rounds a number down, to the nearest integer or to the nearest multiple of significance |
| 30 | GCD
Returns the greatest common divisor |
| 31 | INT
Rounds a number down to the nearest integer |
| 32 | LCM
Returns the least common multiple |
| 33 | LN
Returns the natural logarithm of a number |
| 34 | LOG
Returns the logarithm of a number to a specified base |
| 35 | LOG10
Returns the base-10 logarithm of a number |
| 36 | MDETERM
Returns the matrix determinant of an array |
| 37 | MINVERSE
Returns the matrix inverse of an array |
| 38 | MMULT
Returns the matrix product of two arrays |
| 39 | MOD
Returns the remainder from division |
| 40 | MROUND
Returns a number rounded to the desired multiple |
| 41 | MULTINOMIAL
Returns the multinomial of a set of numbers |
| 42 | MUNIT
Returns the unit matrix or the specified dimension |
| 43 | ODD
Rounds a number up to the nearest odd integer |
| 44 | PI
Returns the value of pi |
| 45 | POWER
Returns the result of a number raised to a power |
| 46 | PRODUCT
Multiplies its arguments |
| 47 | QUOTIENT
Returns the integer portion of a division |
| 48 | RADIANS
Converts degrees to radians |
| 49 | RAND
Returns a random number between 0 and 1 |
| 50 | RANDBETWEEN
Returns a random number between the numbers that you specify |
| 51 | ROMAN
Converts an Arabic numeral to Roman, as text |
| 52 | ROUND
Rounds a number to a specified number of digits |
| 53 | ROUNDDOWN
Rounds a number down, toward 0 |
| 54 | ROUNDUP
Rounds a number up, away from 0 |
| 55 | SEC
Returns the secant of an angle |
| 56 | SECH
Returns the hyperbolic secant of an angle |
| 57 | SERIESSUM
Returns the sum of a power series based on the formula |
| 58 | SIGN
Returns the sign of a number |
| 59 | SIN
Returns the sine of the given angle |
| 60 | SINH
Returns the hyperbolic sine of a number |
| 61 | SQRT
Returns a positive square root |
| 62 | SQRTPI
Returns the square root of pi |
| 63 | SUBTOTAL
Returns a subtotal in a list or database |
| 64 | SUM
Adds its arguments |
| 65 | SUMIF
Adds the cells specified by a given criteria |
| 66 | SUMIFS
Adds the cells specified by a multiple criteria |
| 67 | SUMPRODUCT
Returns the sum of the products of corresponding array components |
| 68 | SUMSQ
Returns the sum of the squares of the arguments |
| 69 | SUMX2MY2
Returns the sum of the difference of squares of corresponding values in two arrays |
| 70 | SUMX2PY2
Returns the sum of the sum of squares of corresponding values in two arrays |
| 71 | SUMXMY2
Returns the sum of squares of differences of corresponding values in two arrays |
| 72 | TAN
Returns the tangent of a number |
| 73 | TANH
Returns the hyperbolic tangent of a number |
| 74 | TRUNC
Truncates a number (you specify the precision of the truncation) |
”;