# Math and Trigonometric Functions

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) |