Excel Functions: Compatibility Reference (2010, 2007 & 2003)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
|
 
Still loading...
ABCDEF
1
FUNCTIONTYPEXL
2010
XL
2007
XL
2003
DESCRIPTION
2
ABSMath and trigonometryyesyesyesReturns the absolute value of a number
3
ACCRINTFinancialyesyesyesReturns the accrued interest for a security that pays periodic interest
4
ACCRINTMFinancialyesyesyesReturns the accrued interest for a security that pays interest at maturity
5
ACOSFinancialyesyesyesReturns the accrued interest for a security that pays interest at maturity
6
ACOSHMath and trigonometryyesyesyesReturns the inverse hyperbolic cosine of a number
7
AGGREGATEMath and trigonometryyesnonoReturns an aggregate in a list or database
8
ADDRESSLookup and referenceyesyesyesReturns a reference as text to a single cell in a worksheet
9
AMORDEGRCFinancialyesyesyesReturns the depreciation for each accounting period by using a depreciation coefficient
10
AMORLINCFinancialyesyesyesReturns the depreciation for each accounting period
11
ANDLogicalyesyesyesReturns TRUE if all of its arguments are TRUE
12
AREASLookup and referenceyesyesyesReturns the number of areas in a reference
13
ASCTextyesyesyesChanges full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
14
ASINMath and trigonometryyesyesyesReturns the arcsine of a number
15
ASINHMath and trigonometryyesyesyesReturns the inverse hyperbolic sine of a number
16
ATANMath and trigonometryyesyesyesReturns the arctangent of a number
17
ATAN2Math and trigonometryyesyesyesReturns the arctangent from x- and y-coordinates
18
ATANHMath and trigonometryyesyesyesReturns the inverse hyperbolic tangent of a number
19
AVEDEVStatisticalyesyesyesReturns the average of the absolute deviations of data points from their mean
20
AVERAGEStatisticalyesyesyesReturns the average of its arguments
21
AVERAGEAStatisticalyesyesyesReturns the average of its arguments, including numbers, text, and logical values
22
AVERAGEIFStatisticalyesyesnoReturns the average (arithmetic mean) of all the cells in a range that meet a given criteria
23
AVERAGEIFSStatisticalyesyesnoReturns the average (arithmetic mean) of all cells that meet multiple criteria.
24
BAHTTEXTTextyesyesyesConverts a number to text, using the ß (baht) currency format
25
BESSELIEngineeringyesyesyesReturns the modified Bessel function In(x)
26
BESSELJEngineeringyesyesyesReturns the Bessel function Jn(x)
27
BESSELKEngineeringyesyesyesReturns the modified Bessel function Kn(x)
28
BESSELYEngineeringyesyesyesReturns the Bessel function Yn(x)
29
BETADISTCompatibilityyesyesyesReturns the beta cumulative distribution function
30
BETA.DISTStatisticalyesnonoReturns the beta cumulative distribution function
31
BETAINVCompatibilityyesyesyesReturns the inverse of the cumulative distribution function for a specified beta distribution
32
BETA.INVStatisticalyesnonoReturns the inverse of the cumulative distribution function for a specified beta distribution
33
BIN2DECEngineeringyesyesyesConverts a binary number to decimal
34
BIN2HEXEngineeringyesyesyesConverts a binary number to hexadecimal
35
BIN2OCTEngineeringyesyesyesConverts a binary number to octal
36
BINOMDISTCompatibilityyesyesyesReturns the individual term binomial distribution probability
37
BINOM.DISTStatisticalyesnonoReturns the individual term binomial distribution probability
38
BINOM.INVStatisticalyesnonoReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
39
CALLAdd-in and AutomationyesyesnoCalls a procedure in a dynamic link library or code resource
40
CEILINGMath and trigonometryyesyesyesRounds a number to the nearest integer or to the nearest multiple of significance
41
CEILING.PRECISEMath and trigonometryyesnonoRounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
42
CELLInformationyesyesyesReturns information about the formatting, location, or contents of a cell
43
CHARTextyesyesyesReturns the character specified by the code number
44
CHIDISTCompatibilityyesyesyesReturns the one-tailed probability of the chi-squared distribution
45
CHIINVCompatibilityyesyesyesReturns the inverse of the one-tailed probability of the chi-squared distribution
46
CHITESTCompatibilityyesyesyesReturns the test for independence
47
CHISQ.DISTStatisticalyesnonoReturns the cumulative beta probability density function
48
CHISQ.DIST.RTStatisticalyesnonoReturns the one-tailed probability of the chi-squared distribution
49
CHISQ.INVStatisticalyesnonoReturns the cumulative beta probability density function
50
CHISQ.INV.RTStatisticalyesnonoReturns the inverse of the one-tailed probability of the chi-squared distribution
51
CHISQ.TESTStatisticalyesnonoReturns the test for independence
52
CHOOSELookup and referenceyesyesyesChooses a value from a list of values
53
CLEANTextyesyesyesRemoves all nonprintable characters from text
54
CODETextyesyesyesReturns a numeric code for the first character in a text string
55
COLUMNLookup and referenceyesyesyesReturns the column number of a reference
56
COLUMNSLookup and referenceyesyesyesReturns the number of columns in a reference
57
COMBINMath and trigonometryyesyesyesReturns the number of combinations for a given number of objects
58
COMPLEXEngineeringyesyesyesConverts real and imaginary coefficients into a complex number
59
CONCATENATETextyesyesyesJoins several text items into one text item
60
CONFIDENCECompatibilityyesyesyesReturns the confidence interval for a population mean
61
CONFIDENCE.NORMStatisticalyesnonoReturns the confidence interval for a population mean
62
CONFIDENCE.TStatisticalyesnonoReturns the confidence interval for a population mean, using a Student's t distribution
63
CONVERTEngineeringyesyesyesConverts a number from one measurement system to another
64
CORRELStatisticalyesyesyesReturns the correlation coefficient between two data sets
65
COSMath and trigonometryyesyesyesReturns the cosine of a number
66
COSHMath and trigonometryyesyesyesReturns the hyperbolic cosine of a number
67
COUNTStatisticalyesyesyesCounts how many numbers are in the list of arguments
68
COUNTAStatisticalyesyesyesCounts how many values are in the list of arguments
69
COUNTBLANKStatisticalyesyesyesCounts the number of blank cells within a range
70
COUNTIFStatisticalyesyesyesCounts the number of cells within a range that meet the given criteria
71
COUNTIFSStatisticalyesyesnoCounts the number of cells within a range that meet multiple criteria
72
COUPDAYBSFinancialyesyesyesReturns the number of days from the beginning of the coupon period to the settlement date
73
COUPDAYSFinancialyesyesyesReturns the number of days in the coupon period that contains the settlement date
74
COUPDAYSNCFinancialyesyesyesReturns the number of days from the settlement date to the next coupon date
75
COUPNCDFinancialyesyesyesReturns the next coupon date after the settlement date
76
COUPNUMFinancialyesyesyesReturns the number of coupons payable between the settlement date and maturity date
77
COUPPCDFinancialyesyesyesReturns the previous coupon date before the settlement date
78
COVARCompatibilityyesyesyesReturns covariance, the average of the products of paired deviations
79
COVARIANCE.PStatisticalyesnonoReturns covariance, the average of the products of paired deviations
80
COVARIANCE.SStatisticalyesnonoReturns the sample covariance, the average of the products deviations for each data point pair in two data sets
81
CRITBINOMCompatibilityyesyesyesReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
82
CUBEKPIMEMBERCubeyesyesnoReturns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance.
83
CUBEMEMBERCubeyesyesnoReturns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.
84
CUBEMEMBERPROPERTYCubeyesyesnoReturns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.
85
CUBERANKEDMEMBERCubeyesyesnoReturns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top yesno students.
86
CUBESETCubeyesyesnoDefines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel.
87
CUBESETCOUNTCubeyesyesnoReturns the number of items in a set.
88
CUBEVALUECubeyesyesnoReturns an aggregated value from a cube.
89
CUMIPMTFinancialyesyesyesReturns the cumulative interest paid between two periods
90
CUMPRINCFinancialyesyesyesReturns the cumulative principal paid on a loan between two periods
91
DATEDate and timeyesyesyesReturns the serial number of a particular date
92
DATEVALUEDate and timeyesyesyesConverts a date in the form of text to a serial number
93
DAVERAGEDatabaseyesyesyesReturns the average of selected database entries
94
DAYDate and timeyesyesyesConverts a serial number to a day of the month
95
DAYS360Date and timeyesyesyesCalculates the number of days between two dates based on a 36no-day year
96
DBFinancialyesyesyesReturns the depreciation of an asset for a specified period by using the fixed-declining balance method
97
DCOUNTDatabaseyesyesyesCounts the cells that contain numbers in a database
98
DCOUNTADatabaseyesyesyesCounts nonblank cells in a database
99
DDBFinancialyesyesyesReturns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
100
DEC2BINEngineeringyesyesyesConverts a decimal number to binary
Loading...
 
 
 
ALL
sources