A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|

1 | Excel Function List | Google Spreadsheet Function List | Google Spreadsheet Function Description | Excel Function Description | ||||||||||||||||||||||||

2 | ABS | ABS | Returns the absolute value of a number. Learn more | Returns the absolute value of a number | ||||||||||||||||||||||||

3 | ACCRINT | ACCRINT | Calculates the accrued interest of a security that has periodic payments. Learn more | Returns the accrued interest for a security that pays periodic interest | ||||||||||||||||||||||||

4 | ACCRINTM | ACCRINTM | Calculates the accrued interest of a security that pays interest at maturity. Learn more | Returns the accrued interest for a security that pays interest at maturity | ||||||||||||||||||||||||

5 | ACOS | ACOS | Returns the inverse cosine of a value, in radians. Learn more | Returns the arccosine of a number | ||||||||||||||||||||||||

6 | ACOSH | ACOSH | Returns the inverse hyperbolic cosine of a number. Learn more | Returns the inverse hyperbolic cosine of a number | ||||||||||||||||||||||||

7 | ACOT | ACOT | Returns the inverse cotangent of a value, in radians. Learn more. | Returns the arccotangent of a number | ||||||||||||||||||||||||

8 | ACOTH | ACOTH | Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive. Learn more. | Returns the hyperbolic arccotangent of a number | ||||||||||||||||||||||||

9 | AGGREGATE | Returns an aggregate in a list or database | ||||||||||||||||||||||||||

10 | ADDRESS | ADDRESS | Returns a cell reference as a string. Learn more | Returns a reference as text to a single cell in a worksheet | ||||||||||||||||||||||||

11 | AMORDEGRC | Returns the depreciation for each accounting period by using a depreciation coefficient | ||||||||||||||||||||||||||

12 | AMORLINC | AMORLINC | Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period. Learn more. | Returns the depreciation for each accounting period | ||||||||||||||||||||||||

13 | AND | AND | Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Learn more | Returns TRUE if all of its arguments are TRUE | ||||||||||||||||||||||||

14 | ARABIC | ARABIC | Converts a Roman number to Arabic, as a number | |||||||||||||||||||||||||

15 | AREAS | Returns the number of areas in a reference | ||||||||||||||||||||||||||

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

17 | ASIN | ASIN | Returns the inverse sine of a value, in radians. Learn more | Returns the arcsine of a number | ||||||||||||||||||||||||

18 | ASINH | ASINH | Returns the inverse hyperbolic sine of a number. Learn more | Returns the inverse hyperbolic sine of a number | ||||||||||||||||||||||||

19 | ATAN | ATAN | Returns the inverse tangent of a value, in radians. Learn more | Returns the arctangent of a number | ||||||||||||||||||||||||

20 | ATAN2 | ATAN2 | Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians. Learn more | Returns the arctangent from x- and y-coordinates | ||||||||||||||||||||||||

21 | ATANH | ATANH | Returns the inverse hyperbolic tangent of a number. Learn more | Returns the inverse hyperbolic tangent of a number | ||||||||||||||||||||||||

22 | AVEDEV | AVEDEV | Returns the average of the absolute deviations of data points from their mean | |||||||||||||||||||||||||

23 | AVERAGE | AVERAGE | Returns the average of its arguments | |||||||||||||||||||||||||

24 | AVERAGEA | AVERAGEA | Returns the average of its arguments, including numbers, text, and logical values | |||||||||||||||||||||||||

25 | AVERAGEIF | AVERAGEIF | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria | |||||||||||||||||||||||||

26 | AVERAGEIFS | AVERAGEIFS | Returns the average (arithmetic mean) of all cells that meet multiple criteria. | |||||||||||||||||||||||||

27 | BAHTTEXT | Converts a number to text, using the ß (baht) currency format | ||||||||||||||||||||||||||

28 | BASE | BASE | Converts a number into a text representation in another base, for example, base 2 for binary. Learn more. | Converts a number into a text representation with the given radix (base) | ||||||||||||||||||||||||

29 | BESSELI | Returns the modified Bessel In(x) | ||||||||||||||||||||||||||

30 | BESSELJ | Returns the Bessel Jn(x) | ||||||||||||||||||||||||||

31 | BESSELK | Returns the modified Bessel Kn(x) | ||||||||||||||||||||||||||

32 | BESSELY | Returns the Bessel Yn(x) | ||||||||||||||||||||||||||

33 | BETADIST | BETADIST | Returns the beta cumulative distribution In Excel 2007, this is a Statistical . | |||||||||||||||||||||||||

34 | BETA.DIST | BETA.DIST | Returns the beta cumulative distribution | |||||||||||||||||||||||||

35 | BETAINV | BETAINV | Returns the inverse of the cumulative distribution for a specified beta distribution In Excel 2007, this is a Statistical . | |||||||||||||||||||||||||

36 | BETA.INV | BETA.INV | Returns the inverse of the cumulative distribution for a specified beta distribution | |||||||||||||||||||||||||

37 | BIN2DEC | BIN2DEC | Converts a signed binary number to decimal format. Learn more | Converts a binary number to decimal | ||||||||||||||||||||||||

38 | BIN2HEX | BIN2HEX | Converts a signed binary number to signed hexadecimal format. Learn more | Converts a binary number to hexadecimal | ||||||||||||||||||||||||

39 | BIN2OCT | BIN2OCT | Converts a signed binary number to signed octal format. Learn more | Converts a binary number to octal | ||||||||||||||||||||||||

40 | BINOMDIST | BINOMDIST | Returns the individual term binomial distribution probability In Excel 2007, this is a Statistical . | |||||||||||||||||||||||||

41 | BINOM.DIST | Returns the individual term binomial distribution probability | ||||||||||||||||||||||||||

42 | BINOM.DIST.RANGE | Returns the probability of a trial result using a binomial distribution | ||||||||||||||||||||||||||

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

44 | BITAND | BITAND | Bitwise boolean AND of two numbers. Learn more. | Returns a 'Bitwise And' of two numbers | ||||||||||||||||||||||||

45 | BITLSHIFT | BITLSHIFT | Shifts the bits of the input a certain number of places to the left. Learn more. | Returns a value number shifted left by shift_amount bits | ||||||||||||||||||||||||

46 | BITOR | BITOR | Bitwise boolean OR of 2 numbers. Learn more. | Returns a bitwise OR of 2 numbers | ||||||||||||||||||||||||

47 | BITRSHIFT | BITRSHIFT | Shifts the bits of the input a certain number of places to the right. Learn more. | Returns a value number shifted right by shift_amount bits | ||||||||||||||||||||||||

48 | BITXOR | BITXOR | Bitwise XOR (exclusive or) of 2 numbers. Learn more. | Returns a bitwise 'Exclusive Or' of two numbers | ||||||||||||||||||||||||

49 | CALL | Calls a procedure in a dynamic link library or code resource | ||||||||||||||||||||||||||

50 | CEILING | CEILING | Rounds a number up to the nearest integer multiple of specified significance. Learn more | Rounds a number to the nearest integer or to the nearest multiple of significance | ||||||||||||||||||||||||

51 | CEILING.MATH | CEILING.MATH | Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more. | Rounds a number up, to the nearest integer or to the nearest multiple of significance | ||||||||||||||||||||||||

52 | CEILING.PRECISE | CEILING.PRECISE | Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up. Learn more. | 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. | ||||||||||||||||||||||||

53 | CELL | CELL | Returns the requested information about the specified cell. Learn more | Returns information about the formatting, location, or contents of a cell This is not available in Excel Online. | ||||||||||||||||||||||||

54 | CHAR | CHAR | Returns the character specified by the code number | |||||||||||||||||||||||||

55 | CHIDIST | CHIDIST | Calculates the right-tailed chi-squared distribution, often used in hypothesis testing. Learn more | Returns the one-tailed probability of the chi-squared distribution Note | ||||||||||||||||||||||||

56 | CHIINV | CHIINV | Calculates the inverse of the right-tailed chi-squared distribution. Learn more | Returns the inverse of the one-tailed probability of the chi-squared distribution Note | ||||||||||||||||||||||||

57 | CHITEST | CHITEST | Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution. Learn more | Returns the test for independence Note | ||||||||||||||||||||||||

58 | CHISQ.DIST | CHISQ.DIST | Calculates the left-tailed chi-squared distribution, often used in hypothesis testing. Learn more | Returns the cumulative beta probability density | ||||||||||||||||||||||||

59 | CHISQ.DIST.RT | CHISQ.DIST.RT | Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing. Learn more | Returns the one-tailed probability of the chi-squared distribution | ||||||||||||||||||||||||

60 | CHISQ.INV | CHISQ.INV | Calculates the inverse of the left-tailed chi-squared distribution. Learn more | Returns the cumulative beta probability density | ||||||||||||||||||||||||

61 | CHISQ.INV.RT | CHISQ.INV.RT | Calculates the inverse of the right-tailed chi-squared distribution. Learn more | Returns the inverse of the one-tailed probability of the chi-squared distribution | ||||||||||||||||||||||||

62 | CHISQ.TEST | Returns the test for independence | ||||||||||||||||||||||||||

63 | CHOOSE | CHOOSE | Returns an element from a list of choices based on index. Learn more | Chooses a value from a list of values | ||||||||||||||||||||||||

64 | CLEAN | CLEAN | Removes all nonprintable characters from text | |||||||||||||||||||||||||

65 | CODE | CODE | Returns a numeric code for the first character in a text string | |||||||||||||||||||||||||

66 | COLUMN | COLUMN | Returns the column number of a specified cell, with `A=1`. Learn more | Returns the column number of a reference | ||||||||||||||||||||||||

67 | COLUMNS | COLUMNS | Returns the number of columns in a specified array or range. Learn more | Returns the number of columns in a reference | ||||||||||||||||||||||||

68 | COMBIN | COMBIN | Returns the number of ways to choose some number of objects from a pool of a given size of objects. Learn more | Returns the number of combinations for a given number of objects | ||||||||||||||||||||||||

69 | COMBINA | COMBINA | Returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways that choose the same object multiple times. Learn more. | Returns the number of combinations with repetitions for a given number of items | ||||||||||||||||||||||||

70 | COMPLEX | COMPLEX | Creates a complex number given real and imaginary coefficients. Learn more | Converts real and imaginary coefficients into a complex number | ||||||||||||||||||||||||

71 | CONCAT | CONCAT | Returns the concatenation of two values. Equivalent to the `&` operator. Learn more | Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. | ||||||||||||||||||||||||

72 | CONCATENATE | CONCATENATE | Joins several text items into one text item | |||||||||||||||||||||||||

73 | CONFIDENCE | CONFIDENCE | Calculates the width of half the confidence interval for a normal distribution. Learn more | Returns the confidence interval for a population mean In Excel 2007, this is a Statistical . | ||||||||||||||||||||||||

74 | CONFIDENCE.NORM | CONFIDENCE.NORM | Calculates the width of half the confidence interval for a normal distribution. | Returns the confidence interval for a population mean | ||||||||||||||||||||||||

75 | CONFIDENCE.T | Returns the confidence interval for a population mean, using a Student's t distribution | ||||||||||||||||||||||||||

76 | CONVERT | CONVERT | Converts a numeric value to a different unit of measure. Learn more | Converts a number from one measurement system to another | ||||||||||||||||||||||||

77 | CORREL | CORREL | Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more | Returns the correlation coefficient between two data sets | ||||||||||||||||||||||||

78 | COS | COS | Returns the cosine of an angle provided in radians. Learn more | Returns the cosine of a number | ||||||||||||||||||||||||

79 | COSH | COSH | Returns the hyperbolic cosine of any real number. Learn more | Returns the hyperbolic cosine of a number | ||||||||||||||||||||||||

80 | COT | COT | Cotangent of an angle provided in radians. Learn more. | Returns the hyperbolic cosine of a number | ||||||||||||||||||||||||

81 | COTH | COTH | Returns the hyperbolic cotangent of any real number. Learn more. | Returns the cotangent of an angle | ||||||||||||||||||||||||

82 | COUNT | COUNT | Returns a count of the number of numeric values in a dataset. Learn more | Counts how many numbers are in the list of arguments | ||||||||||||||||||||||||

83 | COUNTA | COUNTA | Returns a count of the number of values in a dataset. Learn more | Counts how many values are in the list of arguments | ||||||||||||||||||||||||

84 | COUNTBLANK | COUNTBLANK | Returns the number of empty cells in a given range. Learn more | Counts the number of blank cells within a range | ||||||||||||||||||||||||

85 | COUNTIF | COUNTIF | Returns a conditional count across a range. Learn more | Counts the number of cells within a range that meet the given criteria | ||||||||||||||||||||||||

86 | COUNTIFS | COUNTIFS | Returns the count of a range depending on multiple criteria. Learn more | Counts the number of cells within a range that meet multiple criteria | ||||||||||||||||||||||||

87 | COUPDAYBS | COUPDAYBS | Calculates the number of days from the first coupon, or interest payment, until settlement. Learn more | Returns the number of days from the beginning of the coupon period to the settlement date | ||||||||||||||||||||||||

88 | COUPDAYS | COUPDAYS | Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn more | Returns the number of days in the coupon period that contains the settlement date | ||||||||||||||||||||||||

89 | COUPDAYSNC | COUPDAYSNC | Calculates the number of days from the settlement date until the next coupon, or interest payment. Learn more | Returns the number of days from the settlement date to the next coupon date | ||||||||||||||||||||||||

90 | COUPNCD | COUPNCD | Calculates next coupon, or interest payment, date after the settlement date. Learn more | Returns the next coupon date after the settlement date | ||||||||||||||||||||||||

91 | COUPNUM | COUPNUM | Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. Learn more | Returns the number of coupons payable between the settlement date and maturity date | ||||||||||||||||||||||||

92 | COUPPCD | COUPPCD | Calculates last coupon, or interest payment, date before the settlement date. Learn more | Returns the previous coupon date before the settlement date | ||||||||||||||||||||||||

93 | COVAR | COVAR | Calculates the covariance of a dataset. Learn more | Returns covariance, the average of the products of paired deviations In Excel 2007, this is a Statistical . | ||||||||||||||||||||||||

94 | COVARIANCE.P | Returns covariance, the average of the products of paired deviations | ||||||||||||||||||||||||||

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

96 | CRITBINOM | CRITBINOM | Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. Learn more | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value In Excel 2007, this is a Statistical . | ||||||||||||||||||||||||

97 | CSC | CSC | Returns the cosecant of an angle provided in radians. Learn more. | Returns the cosecant of an angle | ||||||||||||||||||||||||

98 | CSCH | Returns the hyperbolic cosecant of an angle | ||||||||||||||||||||||||||

99 | CUBEKPIMEMBER | 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. | ||||||||||||||||||||||||||

100 | CUBEMEMBER | Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube. |

Loading...