BLOG TV Google Spreadsheet Functions vs. MS Excel Functions
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Excel Function ListGoogle Spreadsheet Function ListGoogle Spreadsheet Function
Description
Excel Function Description
2
ABSABSReturns the absolute value of a number. Learn moreReturns the absolute value of a number
3
ACCRINTACCRINTCalculates the accrued interest of a security that has periodic payments. Learn moreReturns the accrued interest for a security that pays periodic interest
4
ACCRINTMACCRINTMCalculates the accrued interest of a security that pays interest at maturity. Learn moreReturns the accrued interest for a security that pays interest at maturity
5
ACOSACOSReturns the inverse cosine of a value, in radians. Learn moreReturns the arccosine of a number
6
ACOSHACOSHReturns the inverse hyperbolic cosine of a number. Learn moreReturns the inverse hyperbolic cosine of a number
7
ACOTACOTReturns the inverse cotangent of a value, in radians. Learn more.Returns the arccotangent of a number
8
ACOTHACOTHReturns 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
AGGREGATEReturns an aggregate in a list or database
10
ADDRESSADDRESSReturns a cell reference as a string. Learn moreReturns a reference as text to a single cell in a worksheet
11
AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficient
12
AMORLINCAMORLINCReturns 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
ANDANDReturns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Learn moreReturns TRUE if all of its arguments are TRUE
14
ARABICARABICConverts a Roman number to Arabic, as a number
15
AREASReturns the number of areas in a reference
16
ASCASCChanges full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
17
ASINASINReturns the inverse sine of a value, in radians. Learn moreReturns the arcsine of a number
18
ASINHASINHReturns the inverse hyperbolic sine of a number. Learn moreReturns the inverse hyperbolic sine of a number
19
ATANATANReturns the inverse tangent of a value, in radians. Learn moreReturns the arctangent of a number
20
ATAN2ATAN2Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians. Learn moreReturns the arctangent from x- and y-coordinates
21
ATANHATANHReturns the inverse hyperbolic tangent of a number. Learn moreReturns the inverse hyperbolic tangent of a number
22
AVEDEVAVEDEVReturns the average of the absolute deviations of data points from their mean
23
AVERAGEAVERAGEReturns the average of its arguments
24
AVERAGEAAVERAGEAReturns the average of its arguments, including numbers, text, and logical values
25
AVERAGEIFAVERAGEIFReturns the average (arithmetic mean) of all the cells in a range that meet a given criteria
26
AVERAGEIFSAVERAGEIFSReturns the average (arithmetic mean) of all cells that meet multiple criteria.
27
BAHTTEXTConverts a number to text, using the ß (baht) currency format
28
BASEBASEConverts 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
BESSELIReturns the modified Bessel In(x)
30
BESSELJReturns the Bessel Jn(x)
31
BESSELKReturns the modified Bessel Kn(x)
32
BESSELYReturns the Bessel Yn(x)
33
BETADISTBETADISTReturns the beta cumulative distribution
In Excel 2007, this is a Statistical .
34
BETA.DISTBETA.DISTReturns the beta cumulative distribution
35
BETAINVBETAINVReturns the inverse of the cumulative distribution for a specified beta distribution
In Excel 2007, this is a Statistical .
36
BETA.INVBETA.INVReturns the inverse of the cumulative distribution for a specified beta distribution
37
BIN2DECBIN2DECConverts a signed binary number to decimal format. Learn moreConverts a binary number to decimal
38
BIN2HEXBIN2HEXConverts a signed binary number to signed hexadecimal format. Learn moreConverts a binary number to hexadecimal
39
BIN2OCTBIN2OCTConverts a signed binary number to signed octal format. Learn moreConverts a binary number to octal
40
BINOMDISTBINOMDISTReturns the individual term binomial distribution probability
In Excel 2007, this is a Statistical .
41
BINOM.DISTReturns the individual term binomial distribution probability
42
BINOM.DIST.RANGEReturns the probability of a trial result using a binomial distribution
43
BINOM.INVReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
44
BITANDBITANDBitwise boolean AND of two numbers. Learn more.Returns a 'Bitwise And' of two numbers
45
BITLSHIFTBITLSHIFTShifts 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
BITORBITORBitwise boolean OR of 2 numbers. Learn more.Returns a bitwise OR of 2 numbers
47
BITRSHIFTBITRSHIFTShifts 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
BITXORBITXORBitwise XOR (exclusive or) of 2 numbers. Learn more.Returns a bitwise 'Exclusive Or' of two numbers
49
CALLCalls a procedure in a dynamic link library or code resource
50
CEILINGCEILINGRounds a number up to the nearest integer multiple of specified significance. Learn moreRounds a number to the nearest integer or to the nearest multiple of significance
51
CEILING.MATHCEILING.MATHRounds 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.PRECISECEILING.PRECISERounds 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
CELLCELLReturns the requested information about the specified cell. Learn moreReturns information about the formatting, location, or contents of a cell
This is not available in Excel Online.
54
CHARCHARReturns the character specified by the code number
55
CHIDISTCHIDISTCalculates the right-tailed chi-squared distribution, often used in hypothesis testing. Learn moreReturns the one-tailed probability of the chi-squared distribution
Note
56
CHIINVCHIINVCalculates the inverse of the right-tailed chi-squared distribution. Learn moreReturns the inverse of the one-tailed probability of the chi-squared distribution
Note
57
CHITESTCHITESTReturns 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 moreReturns the test for independence
Note
58
CHISQ.DISTCHISQ.DISTCalculates the left-tailed chi-squared distribution, often used in hypothesis testing. Learn moreReturns the cumulative beta probability density
59
CHISQ.DIST.RTCHISQ.DIST.RTCalculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing. Learn moreReturns the one-tailed probability of the chi-squared distribution
60
CHISQ.INVCHISQ.INVCalculates the inverse of the left-tailed chi-squared distribution. Learn moreReturns the cumulative beta probability density
61
CHISQ.INV.RTCHISQ.INV.RTCalculates the inverse of the right-tailed chi-squared distribution. Learn moreReturns the inverse of the one-tailed probability of the chi-squared distribution
62
CHISQ.TESTReturns the test for independence
63
CHOOSECHOOSEReturns an element from a list of choices based on index. Learn moreChooses a value from a list of values
64
CLEANCLEANRemoves all nonprintable characters from text
65
CODECODEReturns a numeric code for the first character in a text string
66
COLUMNCOLUMNReturns the column number of a specified cell, with `A=1`. Learn moreReturns the column number of a reference
67
COLUMNSCOLUMNSReturns the number of columns in a specified array or range. Learn moreReturns the number of columns in a reference
68
COMBINCOMBINReturns the number of ways to choose some number of objects from a pool of a given size of objects. Learn moreReturns the number of combinations for a given number of objects
69
COMBINACOMBINAReturns 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
COMPLEXCOMPLEXCreates a complex number given real and imaginary coefficients. Learn moreConverts real and imaginary coefficients into a complex number
71
CONCATCONCATReturns the concatenation of two values. Equivalent to the `&` operator. Learn moreCombines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
72
CONCATENATECONCATENATEJoins several text items into one text item
73
CONFIDENCECONFIDENCECalculates the width of half the confidence interval for a normal distribution. Learn moreReturns the confidence interval for a population mean
In Excel 2007, this is a Statistical .
74
CONFIDENCE.NORMCONFIDENCE.NORMCalculates the width of half the confidence interval for a normal distribution.Returns the confidence interval for a population mean
75
CONFIDENCE.TReturns the confidence interval for a population mean, using a Student's t distribution
76
CONVERTCONVERTConverts a numeric value to a different unit of measure. Learn moreConverts a number from one measurement system to another
77
CORRELCORRELCalculates r, the Pearson product-moment correlation coefficient of a dataset. Learn moreReturns the correlation coefficient between two data sets
78
COSCOSReturns the cosine of an angle provided in radians. Learn moreReturns the cosine of a number
79
COSHCOSHReturns the hyperbolic cosine of any real number. Learn moreReturns the hyperbolic cosine of a number
80
COTCOTCotangent of an angle provided in radians. Learn more.Returns the hyperbolic cosine of a number
81
COTHCOTHReturns the hyperbolic cotangent of any real number. Learn more.Returns the cotangent of an angle
82
COUNTCOUNTReturns a count of the number of numeric values in a dataset. Learn moreCounts how many numbers are in the list of arguments
83
COUNTACOUNTAReturns a count of the number of values in a dataset. Learn moreCounts how many values are in the list of arguments
84
COUNTBLANKCOUNTBLANKReturns the number of empty cells in a given range. Learn moreCounts the number of blank cells within a range
85
COUNTIFCOUNTIFReturns a conditional count across a range. Learn moreCounts the number of cells within a range that meet the given criteria
86
COUNTIFSCOUNTIFSReturns the count of a range depending on multiple criteria. Learn moreCounts the number of cells within a range that meet multiple criteria
87
COUPDAYBSCOUPDAYBSCalculates the number of days from the first coupon, or interest payment, until settlement. Learn moreReturns the number of days from the beginning of the coupon period to the settlement date
88
COUPDAYSCOUPDAYSCalculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn moreReturns the number of days in the coupon period that contains the settlement date
89
COUPDAYSNCCOUPDAYSNCCalculates the number of days from the settlement date until the next coupon, or interest payment. Learn moreReturns the number of days from the settlement date to the next coupon date
90
COUPNCDCOUPNCDCalculates next coupon, or interest payment, date after the settlement date. Learn moreReturns the next coupon date after the settlement date
91
COUPNUMCOUPNUMCalculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. Learn moreReturns the number of coupons payable between the settlement date and maturity date
92
COUPPCDCOUPPCDCalculates last coupon, or interest payment, date before the settlement date. Learn moreReturns the previous coupon date before the settlement date
93
COVARCOVARCalculates the covariance of a dataset. Learn moreReturns covariance, the average of the products of paired deviations
In Excel 2007, this is a Statistical .
94
COVARIANCE.PReturns covariance, the average of the products of paired deviations
95
COVARIANCE.SReturns the sample covariance, the average of the products deviations for each data point pair in two data sets
96
CRITBINOMCRITBINOMCalculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. Learn moreReturns 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
CSCCSCReturns the cosecant of an angle provided in radians. Learn more.Returns the cosecant of an angle
98
CSCHReturns the hyperbolic cosecant of an angle
99
CUBEKPIMEMBERReturns 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
CUBEMEMBERReturns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube. Loading...