Google Sheets Function List
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Google Sheets Function List
2
3
Source:
4
https://support.google.com/docs/table/25273?hl=en
5
6
Full list491
7
8
=IMPORTHTML(A4,"table",1)
<-- Function used to import formula list, but does not appear to work since March 2020
9
10
TypeNameSyntaxDescription
11
ArrayARRAY_CONSTRAINARRAY_CONSTRAIN(input_range, num_rows, num_cols)Constrains an array result to a specified size. Learn more
12
ArrayFREQUENCYFREQUENCY(data, classes)
Calculates the frequency distribution of a one-column array into specified classes. Learn more
13
ArrayGROWTHGROWTH(known_data_y, [known_data_x], [new_data_x], [b])
Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values. Learn more
14
ArrayLINESTLINEST(known_data_y, [known_data_x], [calculate_b], [verbose])
Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method. Learn more
15
ArrayLOGESTLOGEST(known_data_y, [known_data_x], [b], [verbose])
Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve. Learn more
16
ArrayMDETERMMDETERM(square_matrix)
Returns the matrix determinant of a square matrix specified as an array or range. Learn more
17
ArrayMINVERSEMINVERSE(square_matrix)
Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more
18
ArrayMMULTMMULT(matrix1, matrix2)
Calculates the matrix product of two matrices specified as arrays or ranges. Learn more
19
ArraySUMPRODUCTSUMPRODUCT(array1, [array2, ...])
Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more
20
ArraySUMX2MY2SUMX2MY2(array_x, array_y)
Calculates the sum of the differences of the squares of values in two arrays. Learn more
21
ArraySUMX2PY2SUMX2PY2(array_x, array_y)
Calculates the sum of the sums of the squares of values in two arrays. Learn more
22
ArraySUMXMY2SUMXMY2(array_x, array_y)
Calculates the sum of the squares of differences of values in two arrays. Learn more
23
ArrayTRANSPOSETRANSPOSE(array_or_range)Transposes the rows and columns of an array or range of cells. Learn more
24
ArrayTRENDTREND(known_data_y, [known_data_x], [new_data_x], [b])
Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values. Learn more
25
DatabaseDAVERAGEDAVERAGE(database, field, criteria)
Returns the average of a set of values selected from a database table-like array or range using a SQL-like query. Learn more
26
DatabaseDCOUNTDCOUNT(database, field, criteria)
Counts numeric values selected from a database table-like array or range using a SQL-like query. Learn more
27
DatabaseDCOUNTADCOUNTA(database, field, criteria)
Counts values, including text, selected from a database table-like array or range using a SQL-like query. Learn more
28
DatabaseDGETDGET(database, field, criteria)
Returns a single value from a database table-like array or range using a SQL-like query. Learn more
29
DatabaseDMAXDMAX(database, field, criteria)
Returns the maximum value selected from a database table-like array or range using a SQL-like query. Learn more
30
DatabaseDMINDMIN(database, field, criteria)
Returns the minimum value selected from a database table-like array or range using a SQL-like query. Learn more
31
DatabaseDPRODUCTDPRODUCT(database, field, criteria)
Returns the product of values selected from a database table-like array or range using a SQL-like query. Learn more
32
DatabaseDSTDEVDSTDEV(database, field, criteria)
Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query. Learn more
33
DatabaseDSTDEVPDSTDEVP(database, field, criteria)
Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query. Learn more
34
DatabaseDSUMDSUM(database, field, criteria)
Returns the sum of values selected from a database table-like array or range using a SQL-like query. Learn more
35
DatabaseDVARDVAR(database, field, criteria)
Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query. Learn more
36
DatabaseDVARPDVARP(database, field, criteria)
Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query. Learn more
37
DateDATEDATE(year, month, day)Converts a provided year, month, and day into a date. Learn more
38
DateDATEDIFDATEDIF(start_date, end_date, unit)
Calculates the number of days, months, or years between two dates. Learn more
39
DateDATEVALUEDATEVALUE(date_string)
Converts a provided date string in a known format to a date value. Learn more
40
DateDAYDAY(date)
Returns the day of the month that a specific date falls on, in numeric format. Learn more
41
DateDAYSDAYS(end_date, start_date)Returns the number of days between two dates. Learn more.
42
DateDAYS360DAYS360(start_date, end_date, [method])
Returns the difference between two days based on the 360 day year used in some financial interest calculations. Learn more
43
DateEDATEEDATE(start_date, months)
Returns a date a specified number of months before or after another date. Learn more
44
DateEOMONTHEOMONTH(start_date, months)
Returns a date representing the last day of a month which falls a specified number of months before or after another date. Learn more
45
DateHOURHOUR(time)
Returns the hour component of a specific time, in numeric format. Learn more
46
DateISOWEEKNUMISOWEEKNUM(date)
Returns the number of the ISO week of the year where the provided date falls. Learn more
47
DateMINUTEMINUTE(time)
Returns the minute component of a specific time, in numeric format. Learn more
48
DateMONTHMONTH(date)
Returns the month of the year a specific date falls in, in numeric format. Learn more
49
DateNETWORKDAYSNETWORKDAYS(start_date, end_date, [holidays])
Returns the number of net working days between two provided days. Learn more
50
DateNETWORKDAYS.INTLNETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Returns the number of net working days between two provided days excluding specified weekend days and holidays. Learn more
51
DateNOWNOW()Returns the current date and time as a date value. Learn more
52
DateSECONDSECOND(time)
Returns the second component of a specific time, in numeric format. Learn more
53
DateTIMETIME(hour, minute, second)Converts a provided hour, minute, and second into a time. Learn more
54
DateTIMEVALUETIMEVALUE(time_string)Returns the fraction of a 24-hour day the time represents. Learn more
55
DateTODAYTODAY()Returns the current date as a date value. Learn more
56
DateWEEKDAYWEEKDAY(date, [type])
Returns a number representing the day of the week of the date provided. Learn more
57
DateWEEKNUMWEEKNUM(date, [type])
Returns a number representing the week of the year where the provided date falls. Learn more
58
DateWORKDAYWORKDAY(start_date, num_days, [holidays])
Calculates the end date after a specified number of working days. Learn more
59
DateWORKDAY.INTLWORKDAY.INTL(start_date, num_days, [weekend], [holidays])
Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Learn more
60
DateYEARYEAR(date)Returns the year specified by a given date. Learn more
61
DateYEARFRACYEARFRAC(start_date, end_date, [day_count_convention])
Returns the number of years, including fractional years, between two dates using a specified day count convention. Learn more
62
EngineeringBIN2DECBIN2DEC(signed_binary_number)Converts a signed binary number to decimal format. Learn more
63
EngineeringBIN2HEXBIN2HEX(signed_binary_number, [significant_digits])
Converts a signed binary number to signed hexadecimal format. Learn more
64
EngineeringBIN2OCTBIN2OCT(signed_binary_number, [significant_digits])Converts a signed binary number to signed octal format. Learn more
65
EngineeringBITANDBITAND(value1, value2)Bitwise boolean AND of two numbers. Learn more.
66
EngineeringBITLSHIFTBITLSHIFT(value, shift_amount)
Shifts the bits of the input a certain number of places to the left. Learn more.
67
EngineeringBITORBITOR(value1, value2)Bitwise boolean OR of 2 numbers. Learn more.
68
EngineeringBITRSHIFTBITRSHIFT(value, shift_amount)
Shifts the bits of the input a certain number of places to the right. Learn more.
69
EngineeringBITXORBITXOR(value1, value2)Bitwise XOR (exclusive OR) of 2 numbers. Learn more.
70
EngineeringCOMPLEXCOMPLEX(real_part, imaginary_part, [suffix])
Creates a complex number given real and imaginary coefficients. Learn more
71
EngineeringDEC2BINDEC2BIN(decimal_number, [significant_digits])Converts a decimal number to signed binary format. Learn more
72
EngineeringDEC2HEXDEC2HEX(decimal_number, [significant_digits])Converts a decimal number to signed hexadecimal format. Learn more
73
EngineeringDEC2OCTDEC2OCT(decimal_number, [significant_digits])Converts a decimal number to signed octal format. Learn more
74
EngineeringDELTADELTA(number1, [number2])Compare two numeric values, returning 1 if they're equal. Learn more
75
EngineeringERFERF(lower_bound, [upper_bound])
The ERF function returns the integral of the Gauss error function over an interval of values. Learn more.
76
EngineeringERF.PRECISEERF.PRECISE(lower_bound, [upper_bound])See ERF
77
EngineeringGESTEPGESTEP(value, [step])
Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise. If no step value is provided then the default value of 0 will be used. Learn more.
78
EngineeringHEX2BINHEX2BIN(signed_hexadecimal_number, [significant_digits])
Converts a signed hexadecimal number to signed binary format. Learn more
79
EngineeringHEX2DECHEX2DEC(signed_hexadecimal_number)Converts a signed hexadecimal number to decimal format. Learn more
80
EngineeringHEX2OCTHEX2OCT(signed_hexadecimal_number, significant_digits)
Converts a signed hexadecimal number to signed octal format. Learn more
81
EngineeringIMABSIMABS(number)Returns absolute value of a complex number. Learn more
82
EngineeringIMAGINARYIMAGINARY(complex_number)Returns the imaginary coefficient of a complex number. Learn more
83
EngineeringIMARGUMENTIMARGUMENT(number)
The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians. Learn more.
84
EngineeringIMCONJUGATEIMCONJUGATE(number)Returns the complex conjugate of a number. Learn more
85
EngineeringIMCOSIMCOS(number)
The IMCOS function returns the cosine of the given complex number. Learn more.
86
EngineeringIMCOSHIMCOSH(number)
Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)." Learn more.
87
EngineeringIMCOTIMCOT(number)
Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)." Learn more.
88
EngineeringIMCOTHIMCOTH(number)
Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)." Learn more.
89
EngineeringIMCSCIMCSC(number)Returns the cosecant of the given complex number. Learn more.
90
EngineeringIMCSCHIMCSCH(number)
Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)." Learn more.
91
EngineeringIMDIVIMDIV(dividend, divisor)Returns one complex number divided by another. Learn more
92
EngineeringIMEXPIMEXP(exponent)
Returns Euler's number, e (~2.718) raised to a complex power. Learn more.
93
EngineeringIMLOGIMLOG(value, base)
Returns the logarithm of a complex number for a specified base. Learn more.
94
EngineeringIMLOG10IMLOG10(value)Returns the logarithm of a complex number with base 10. Learn more.
95
EngineeringIMLOG2IMLOG2(value)Returns the logarithm of a complex number with base 2. Learn more.
96
EngineeringIMPRODUCTIMPRODUCT(factor1, [factor2, ...])
Returns the result of multiplying a series of complex numbers together. Learn more
97
EngineeringIMREALIMREAL(complex_number)Returns the real coefficient of a complex number. Learn more
98
EngineeringIMSECIMSEC(number)
Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)." Learn more.
99
EngineeringIMSECHIMSECH(number)
Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)." Learn more.
100
EngineeringIMSINIMSIN (number)Returns the sine of the given complex number. Learn more.