A | B | C | D | E | F | |
---|---|---|---|---|---|---|

1 | FUNCTION | TYPE | XL 2010 | XL 2007 | XL 2003 | DESCRIPTION |

2 | ABS | Math and trigonometry | yes | yes | yes | Returns the absolute value of a number |

3 | ACCRINT | Financial | yes | yes | yes | Returns the accrued interest for a security that pays periodic interest |

4 | ACCRINTM | Financial | yes | yes | yes | Returns the accrued interest for a security that pays interest at maturity |

5 | ACOS | Financial | yes | yes | yes | Returns the accrued interest for a security that pays interest at maturity |

6 | ACOSH | Math and trigonometry | yes | yes | yes | Returns the inverse hyperbolic cosine of a number |

7 | AGGREGATE | Math and trigonometry | yes | no | no | Returns an aggregate in a list or database |

8 | ADDRESS | Lookup and reference | yes | yes | yes | Returns a reference as text to a single cell in a worksheet |

9 | AMORDEGRC | Financial | yes | yes | yes | Returns the depreciation for each accounting period by using a depreciation coefficient |

10 | AMORLINC | Financial | yes | yes | yes | Returns the depreciation for each accounting period |

11 | AND | Logical | yes | yes | yes | Returns TRUE if all of its arguments are TRUE |

12 | AREAS | Lookup and reference | yes | yes | yes | Returns the number of areas in a reference |

13 | ASC | Text | yes | yes | yes | Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters |

14 | ASIN | Math and trigonometry | yes | yes | yes | Returns the arcsine of a number |

15 | ASINH | Math and trigonometry | yes | yes | yes | Returns the inverse hyperbolic sine of a number |

16 | ATAN | Math and trigonometry | yes | yes | yes | Returns the arctangent of a number |

17 | ATAN2 | Math and trigonometry | yes | yes | yes | Returns the arctangent from x- and y-coordinates |

18 | ATANH | Math and trigonometry | yes | yes | yes | Returns the inverse hyperbolic tangent of a number |

19 | AVEDEV | Statistical | yes | yes | yes | Returns the average of the absolute deviations of data points from their mean |

20 | AVERAGE | Statistical | yes | yes | yes | Returns the average of its arguments |

21 | AVERAGEA | Statistical | yes | yes | yes | Returns the average of its arguments, including numbers, text, and logical values |

22 | AVERAGEIF | Statistical | yes | yes | no | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria |

23 | AVERAGEIFS | Statistical | yes | yes | no | Returns the average (arithmetic mean) of all cells that meet multiple criteria. |

24 | BAHTTEXT | Text | yes | yes | yes | Converts a number to text, using the ÃŸ (baht) currency format |

25 | BESSELI | Engineering | yes | yes | yes | Returns the modified Bessel function In(x) |

26 | BESSELJ | Engineering | yes | yes | yes | Returns the Bessel function Jn(x) |

27 | BESSELK | Engineering | yes | yes | yes | Returns the modified Bessel function Kn(x) |

28 | BESSELY | Engineering | yes | yes | yes | Returns the Bessel function Yn(x) |

29 | BETADIST | Compatibility | yes | yes | yes | Returns the beta cumulative distribution function |

30 | BETA.DIST | Statistical | yes | no | no | Returns the beta cumulative distribution function |

31 | BETAINV | Compatibility | yes | yes | yes | Returns the inverse of the cumulative distribution function for a specified beta distribution |

32 | BETA.INV | Statistical | yes | no | no | Returns the inverse of the cumulative distribution function for a specified beta distribution |

33 | BIN2DEC | Engineering | yes | yes | yes | Converts a binary number to decimal |

34 | BIN2HEX | Engineering | yes | yes | yes | Converts a binary number to hexadecimal |

35 | BIN2OCT | Engineering | yes | yes | yes | Converts a binary number to octal |

36 | BINOMDIST | Compatibility | yes | yes | yes | Returns the individual term binomial distribution probability |

37 | BINOM.DIST | Statistical | yes | no | no | Returns the individual term binomial distribution probability |

38 | BINOM.INV | Statistical | yes | no | no | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |

39 | CALL | Add-in and Automation | yes | yes | no | Calls a procedure in a dynamic link library or code resource |

40 | CEILING | Math and trigonometry | yes | yes | yes | Rounds a number to the nearest integer or to the nearest multiple of significance |

41 | CEILING.PRECISE | Math and trigonometry | yes | no | no | 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. |

42 | CELL | Information | yes | yes | yes | Returns information about the formatting, location, or contents of a cell |

43 | CHAR | Text | yes | yes | yes | Returns the character specified by the code number |

44 | CHIDIST | Compatibility | yes | yes | yes | Returns the one-tailed probability of the chi-squared distribution |

45 | CHIINV | Compatibility | yes | yes | yes | Returns the inverse of the one-tailed probability of the chi-squared distribution |

46 | CHITEST | Compatibility | yes | yes | yes | Returns the test for independence |

47 | CHISQ.DIST | Statistical | yes | no | no | Returns the cumulative beta probability density function |

48 | CHISQ.DIST.RT | Statistical | yes | no | no | Returns the one-tailed probability of the chi-squared distribution |

49 | CHISQ.INV | Statistical | yes | no | no | Returns the cumulative beta probability density function |

50 | CHISQ.INV.RT | Statistical | yes | no | no | Returns the inverse of the one-tailed probability of the chi-squared distribution |

51 | CHISQ.TEST | Statistical | yes | no | no | Returns the test for independence |

52 | CHOOSE | Lookup and reference | yes | yes | yes | Chooses a value from a list of values |

53 | CLEAN | Text | yes | yes | yes | Removes all nonprintable characters from text |

54 | CODE | Text | yes | yes | yes | Returns a numeric code for the first character in a text string |

55 | COLUMN | Lookup and reference | yes | yes | yes | Returns the column number of a reference |

56 | COLUMNS | Lookup and reference | yes | yes | yes | Returns the number of columns in a reference |

57 | COMBIN | Math and trigonometry | yes | yes | yes | Returns the number of combinations for a given number of objects |

58 | COMPLEX | Engineering | yes | yes | yes | Converts real and imaginary coefficients into a complex number |

59 | CONCATENATE | Text | yes | yes | yes | Joins several text items into one text item |

60 | CONFIDENCE | Compatibility | yes | yes | yes | Returns the confidence interval for a population mean |

61 | CONFIDENCE.NORM | Statistical | yes | no | no | Returns the confidence interval for a population mean |

62 | CONFIDENCE.T | Statistical | yes | no | no | Returns the confidence interval for a population mean, using a Student's t distribution |

63 | CONVERT | Engineering | yes | yes | yes | Converts a number from one measurement system to another |

64 | CORREL | Statistical | yes | yes | yes | Returns the correlation coefficient between two data sets |

65 | COS | Math and trigonometry | yes | yes | yes | Returns the cosine of a number |

66 | COSH | Math and trigonometry | yes | yes | yes | Returns the hyperbolic cosine of a number |

67 | COUNT | Statistical | yes | yes | yes | Counts how many numbers are in the list of arguments |

68 | COUNTA | Statistical | yes | yes | yes | Counts how many values are in the list of arguments |

69 | COUNTBLANK | Statistical | yes | yes | yes | Counts the number of blank cells within a range |

70 | COUNTIF | Statistical | yes | yes | yes | Counts the number of cells within a range that meet the given criteria |

71 | COUNTIFS | Statistical | yes | yes | no | Counts the number of cells within a range that meet multiple criteria |

72 | COUPDAYBS | Financial | yes | yes | yes | Returns the number of days from the beginning of the coupon period to the settlement date |

73 | COUPDAYS | Financial | yes | yes | yes | Returns the number of days in the coupon period that contains the settlement date |

74 | COUPDAYSNC | Financial | yes | yes | yes | Returns the number of days from the settlement date to the next coupon date |

75 | COUPNCD | Financial | yes | yes | yes | Returns the next coupon date after the settlement date |

76 | COUPNUM | Financial | yes | yes | yes | Returns the number of coupons payable between the settlement date and maturity date |

77 | COUPPCD | Financial | yes | yes | yes | Returns the previous coupon date before the settlement date |

78 | COVAR | Compatibility | yes | yes | yes | Returns covariance, the average of the products of paired deviations |

79 | COVARIANCE.P | Statistical | yes | no | no | Returns covariance, the average of the products of paired deviations |

80 | COVARIANCE.S | Statistical | yes | no | no | Returns the sample covariance, the average of the products deviations for each data point pair in two data sets |

81 | CRITBINOM | Compatibility | yes | yes | yes | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |

82 | CUBEKPIMEMBER | Cube | yes | yes | no | Returns 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 | CUBEMEMBER | Cube | yes | yes | no | Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube. |

84 | CUBEMEMBERPROPERTY | Cube | yes | yes | no | Returns 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 | CUBERANKEDMEMBER | Cube | yes | yes | no | Returns 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 | CUBESET | Cube | yes | yes | no | Defines 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 | CUBESETCOUNT | Cube | yes | yes | no | Returns the number of items in a set. |

88 | CUBEVALUE | Cube | yes | yes | no | Returns an aggregated value from a cube. |

89 | CUMIPMT | Financial | yes | yes | yes | Returns the cumulative interest paid between two periods |

90 | CUMPRINC | Financial | yes | yes | yes | Returns the cumulative principal paid on a loan between two periods |

91 | DATE | Date and time | yes | yes | yes | Returns the serial number of a particular date |

92 | DATEVALUE | Date and time | yes | yes | yes | Converts a date in the form of text to a serial number |

93 | DAVERAGE | Database | yes | yes | yes | Returns the average of selected database entries |

94 | DAY | Date and time | yes | yes | yes | Converts a serial number to a day of the month |

95 | DAYS360 | Date and time | yes | yes | yes | Calculates the number of days between two dates based on a 36no-day year |

96 | DB | Financial | yes | yes | yes | Returns the depreciation of an asset for a specified period by using the fixed-declining balance method |

97 | DCOUNT | Database | yes | yes | yes | Counts the cells that contain numbers in a database |

98 | DCOUNTA | Database | yes | yes | yes | Counts nonblank cells in a database |

99 | DDB | Financial | yes | yes | yes | Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify |

100 | DEC2BIN | Engineering | yes | yes | yes | Converts a decimal number to binary |

Loading...

Main menu