ALL FUNCTION.xlsx

	B	D	F	G
1
2	Function name	Description	Type	Applies to
3	ABS	Returns the absolute value of a number	Math and trigonometry	All Version
4	ACCRINT	Returns the accrued interest for a security that pays periodic interest	Financial	All Version
5	ACCRINTM	Returns the accrued interest for a security that pays interest at maturity	Financial	All Version
6	ACOS	Returns the arccosine of a number	Math and trigonometry	All Version
7	ACOSH	Returns the inverse hyperbolic cosine of a number	Math and trigonometry	All Version
8	ACOT	Returns the arccotangent of a number	Math and trigonometry	2013
9	ACOTH	Returns the hyperbolic arccotangent of a number	Math and trigonometry	2013
10	ADDRESS	Returns a reference as text to a single cell in a worksheet	Lookup and reference	All Version
11	AGGREGATE	Returns an aggregate in a list or database	Math and trigonometry	All Version
12	AMORDEGRC	Returns the depreciation for each accounting period by using a depreciation coefficient	Financial	All Version
13	AMORLINC	Returns the depreciation for each accounting period	Financial	All Version
14	AND	Returns TRUE if all of its arguments are TRUE	Logical	All Version
15	ARABIC	Converts a Roman number to Arabic, as a number	Math and trigonometry	2013
16	AREAS	Returns the number of areas in a reference	Lookup and reference	All Version
17	ARRAYTOTEXT	Returns an array of text values from any specified range	Text	2021
18	ASC	Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters	Text	All Version
19	ASIN	Returns the arcsine of a number	Math and trigonometry	All Version
20	ASINH	Returns the inverse hyperbolic sine of a number	Math and trigonometry	All Version
21	ATAN	Returns the arctangent of a number	Math and trigonometry	All Version
22	ATAN2	Returns the arctangent from x- and y-coordinates	Math and trigonometry	All Version
23	ATANH	Returns the inverse hyperbolic tangent of a number	Math and trigonometry	All Version
24	AVEDEV	Returns the average of the absolute deviations of data points from their mean	Statistical	All Version
25	AVERAGE	Returns the average of its arguments	Statistical	All Version
26	AVERAGEA	Returns the average of its arguments, including numbers, text, and logical values	Statistical	All Version
27	AVERAGEIF	Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria	Statistical	All Version
28	AVERAGEIFS	Returns the average (arithmetic mean) of all cells that meet multiple criteria.	Statistical	All Version
29	BAHTTEXT	Converts a number to text, using the ß (baht) currency format	Text	All Version
30	BASE	Converts a number into a text representation with the given radix (base)	Math and trigonometry	All Version
31	BESSELI	Returns the modified Bessel function In(x)	Engineering	All Version
32	BESSELJ	Returns the Bessel function Jn(x)	Engineering	All Version
33	BESSELK	Returns the modified Bessel function Kn(x)	Engineering	All Version
34	BESSELY	Returns the Bessel function Yn(x)	Engineering	All Version
35	BETA.DIST	Returns the beta cumulative distribution function	Statistical	2010
36	BETA.INVn	Returns the inverse of the cumulative distribution function for a specified beta distribution	Statistical	2010
37	BETADIST	Returns the beta cumulative distribution function	Compatibility	All Version
38	BETAINV	Returns the inverse of the cumulative distribution function for a specified beta distribution	Compatibility	All Version
39	BIN2DEC	Converts a binary number to decimal	Engineering	All Version
40	BIN2HEX	Converts a binary number to hexadecimal	Engineering	All Version
41	BIN2OCT	Converts a binary number to octal	Engineering	All Version
42	BINOM.DIST	Returns the individual term binomial distribution probability	Statistical	2010
43	BINOM.DIST.RANGE	Returns the probability of a trial result using a binomial distribution	Statistical	2013
44	BINOM.INV	Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value	Statistical	2010
45	BINOMDIST	Returns the individual term binomial distribution probability	Compatibility	All Version
46	BITAND	Returns a 'Bitwise And' of two numbers	Engineering	2013
47	BITLSHIFT	Returns a value number shifted left by shift_amount bits	Engineering	2013
48	BITOR	Returns a bitwise OR of 2 numbers	Engineering	2013
49	BITRSHIFT	Returns a value number shifted right by shift_amount bits	Engineering	2013
50	BITXOR	Returns a bitwise 'Exclusive Or' of two numbers	Engineering	2013
51	BYCOL	Applies aLAMBDAto each column and returns an array of the results	Logical	2024
52	BYROW	Applies aLAMBDAto each row and returns an array of the results	Logical	2024
53	CALL	Calls a procedure in a dynamic link library or code resource	Add-in and Automation	All Version
54	CEILING	Rounds a number to the nearest integer or to the nearest multiple of significance	Compatibility	All Version
55	CEILING.MATH	Rounds a number up, to the nearest integer or to the nearest multiple of significance	Math and trigonometry	2013
56	CEILING.PRECISE	Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.	Math and trigonometry	All Version
57	CELL	Returns information about the formatting, location, or contents of a cell, This function is not available in Excel for the web.	Information	All Version
58	CHAR	Returns the character specified by the code number	Text	All Version
59	CHIDIST	Returns the one-tailed probability of the chi-squared distribution	Compatibility	All Version
60	CHIINV	Returns the inverse of the one-tailed probability of the chi-squared distribution	Compatibility	All Version
61	CHISQ.DIST	Returns the cumulative beta probability density function	Statistical	2010
62	CHISQ.DIST.RT	Returns the one-tailed probability of the chi-squared distribution	Statistical	2010
63	CHISQ.INV	Returns the cumulative beta probability density function	Statistical	2010
64	CHISQ.INV.RT	Returns the inverse of the one-tailed probability of the chi-squared distribution	Statistical	2010
65	CHISQ.TEST	Returns the test for independence	Statistical	2010
66	CHITEST	Returns the test for independence	Compatibility	All Version
67	CHOOSE	Chooses a value from a list of values	Lookup and reference	All Version
68	CHOOSECOLS	Returns the specified columns from an array	Lookup and reference	2024
69	CHOOSEROWS	Returns the specified rows from an array	Lookup and reference	2024
70	CLEAN	Removes all nonprintable characters from text	Text	All Version
71	CODE	Returns a numeric code for the first character in a text string	Text	All Version
72	COLUMN	Returns the column number of a reference	Lookup and reference	All Version
73	COLUMNS	Returns the number of columns in a reference	Lookup and reference	All Version
74	COMBIN	Returns the number of combinations for a given number of objects	Math and trigonometry	All Version
75	COMBINA	Returns the number of combinations with repetitions for a given number of items	Math and trigonometry	2013
76	COMPLEX	Converts real and imaginary coefficients into a complex number	Engineering	All Version
77	CONCAT	Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.	Text	2019
78	CONCATENATE	Joins several text items into one text item	Text	All Version
79	CONFIDENCE	Returns the confidence interval for a population mean	Compatibility	All Version
80	CONFIDENCE.NORM	Returns the confidence interval for a population mean	Statistical	2010
81	CONFIDENCE.T	Returns the confidence interval for a population mean, using a Student's t distribution	Statistical	2010
82	CONVERT	Converts a number from one measurement system to another	Engineering	All Version
83	CORREL	Returns the correlation coefficient between two data sets	Statistical	All Version
84	COS	Returns the cosine of a number	Math and trigonometry	All Version
85	COSH	Returns the hyperbolic cosine of a number	Math and trigonometry	All Version
86	COT	Returns the hyperbolic cosine of a number	Math and trigonometry	2013
87	COTH	Returns the cotangent of an angle	Math and trigonometry	2013
88	COUNT	Counts how many numbers are in the list of arguments	Statistical	All Version
89	COUNTA	Counts how many values are in the list of arguments	Statistical	All Version
90	COUNTBLANK	Counts the number of blank cells within a range	Statistical	All Version
91	COUNTIF	Counts the number of cells within a range that meet the given criteria	Statistical	All Version
92	COUNTIFS	Counts the number of cells within a range that meet multiple criteria	Statistical	All Version
93	COUPDAYBS	Returns the number of days from the beginning of the coupon period to the settlement date	Financial	All Version
94	COUPDAYS	Returns the number of days in the coupon period that contains the settlement date	Financial	All Version
95	COUPDAYSNC	Returns the number of days from the settlement date to the next coupon date	Financial	All Version
96	COUPNCD	Returns the next coupon date after the settlement date	Financial	All Version
97	COUPNUM	Returns the number of coupons payable between the settlement date and maturity date	Financial	All Version
98	COUPPCD	Returns the previous coupon date before the settlement date	Financial	All Version
99	COVAR	Returns covariance, the average of the products of paired deviations	Compatibility	All Version
100	COVARIANCE.P	Returns covariance, the average of the products of paired deviations	Statistical	2010