Math and Trigonometric Functions


Advertisements


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)



Advertisements
E-Books Store