Advanced Excel Functions 简明教程

Math and Trigonometric Functions

Excel 数学和三角函数执行许多常见的数学计算，包括基本算术、条件求和和乘积、指数和对数，以及三角比。

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	ABSReturns the absolute value of a number
2	ACOSReturns the arccosine of a number
3	ACOSHReturns the inverse hyperbolic cosine of a number
4	ACOTReturns the arccotangent of a number
5	ACOTHReturns the hyperbolic arccotangent of a number
6	AGGREGATEReturns an aggregate in a list or database
7	ARABICConverts a Roman number to Arabic, as a number
8	ASINReturns the arcsine of a number
9	ASINHReturns the inverse hyperbolic sine of a number
10	ATANReturns the arctangent of a number
11	ATAN2Returns the arctangent from x and y coordinates
12	ATANHReturns the inverse hyperbolic tangent of a number
13	BASEConverts a number into a text representation with the given radix (base)
14	CEILING.MATHRounds a number up, to the nearest integer or to the nearest multiple of significance
15	COMBINReturns the number of combinations for a given number of objects
16	COMBINAReturns the number of combinations with repetitions for a given number of items
17	COSReturns the cosine of a number
18	COSHReturns the hyperbolic cosine of a number
19	COTReturns the cotangent of an angle
20	COTHReturns the hyperbolic cotangent of a number
21	CSCReturns the cosecant of an angle
22	CSCHReturns the hyperbolic cosecant of an angle
23	DECIMALConverts a text representation of a number in a given base into a decimal number
24	DEGREESConverts radians to degrees
25	EVENRounds a number up to the nearest even integer
26	EXPReturns e raised to the power of a given number
27	FACTReturns the factorial of a number
28	FACTDOUBLEReturns the double factorial of a number
29	FLOOR.MATHRounds a number down, to the nearest integer or to the nearest multiple of significance
30	GCDReturns the greatest common divisor
31	INTRounds a number down to the nearest integer
32	LCMReturns the least common multiple
33	LNReturns the natural logarithm of a number
34	LOGReturns the logarithm of a number to a specified base
35	LOG10Returns the base-10 logarithm of a number
36	MDETERMReturns the matrix determinant of an array
37	MINVERSEReturns the matrix inverse of an array
38	MMULTReturns the matrix product of two arrays
39	MODReturns the remainder from division
40	MROUNDReturns a number rounded to the desired multiple
41	MULTINOMIALReturns the multinomial of a set of numbers
42	MUNITReturns the unit matrix or the specified dimension
43	ODDRounds a number up to the nearest odd integer
44	PIReturns the value of pi
45	POWERReturns the result of a number raised to a power
46	PRODUCTMultiplies its arguments
47	QUOTIENTReturns the integer portion of a division
48	RADIANSConverts degrees to radians
49	RANDReturns a random number between 0 and 1
50	RANDBETWEENReturns a random number between the numbers that you specify
51	ROMANConverts an Arabic numeral to Roman, as text
52	ROUNDRounds a number to a specified number of digits
53	ROUNDDOWNRounds a number down, toward 0
54	ROUNDUPRounds a number up, away from 0
55	SECReturns the secant of an angle
56	SECHReturns the hyperbolic secant of an angle
57	SERIESSUMReturns the sum of a power series based on the formula
58	SIGNReturns the sign of a number
59	SINReturns the sine of the given angle
60	SINHReturns the hyperbolic sine of a number
61	SQRTReturns a positive square root
62	SQRTPIReturns the square root of pi
63	SUBTOTALReturns a subtotal in a list or database
64	SUMAdds its arguments
65	SUMIFAdds the cells specified by a given criteria
66	SUMIFSAdds the cells specified by a multiple criteria
67	SUMPRODUCTReturns the sum of the products of corresponding array components
68	SUMSQReturns the sum of the squares of the arguments
69	SUMX2MY2Returns the sum of the difference of squares of corresponding values in two arrays
70	SUMX2PY2Returns the sum of the sum of squares of corresponding values in two arrays
71	SUMXMY2Returns the sum of squares of differences of corresponding values in two arrays
72	TANReturns the tangent of a number
73	TANHReturns the hyperbolic tangent of a number
74	TRUNCTruncates a number (you specify the precision of the truncation)