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 psts 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 hyperbopc cosine of a number
4	ACOT Returns the arccotangent of a number
5	ACOTH Returns the hyperbopc arccotangent of a number
6	AGGREGATE Returns an aggregate in a pst 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 hyperbopc 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 hyperbopc 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 hyperbopc cosine of a number
19	COT Returns the cotangent of an angle
20	COTH Returns the hyperbopc cotangent of a number
21	CSC Returns the cosecant of an angle
22	CSCH Returns the hyperbopc 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 spanisor
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 spanision
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 Multippes its arguments
47	QUOTIENT Returns the integer portion of a spanision
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 hyperbopc 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 hyperbopc 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 pst 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 hyperbopc tangent of a number
74	TRUNC Truncates a number (you specify the precision of the truncation)

Math and Trigonometric Functions

Math and Trigonometric Functions

友情链接