| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Google Sheets Function List | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | Source: | |||||||||||||||||||||||||
4 | https://support.google.com/docs/table/25273?hl=en | |||||||||||||||||||||||||
5 | ||||||||||||||||||||||||||
6 | Full list | 491 | ||||||||||||||||||||||||
7 | ||||||||||||||||||||||||||
8 | =IMPORTHTML(A4,"table",1) | <-- Function used to import formula list, but does not appear to work since March 2020 | ||||||||||||||||||||||||
9 | ||||||||||||||||||||||||||
10 | Type | Name | Syntax | Description | ||||||||||||||||||||||
11 | Array | ARRAY_CONSTRAIN | ARRAY_CONSTRAIN(input_range, num_rows, num_cols) | Constrains an array result to a specified size. Learn more | ||||||||||||||||||||||
12 | Array | FREQUENCY | FREQUENCY(data, classes) | Calculates the frequency distribution of a one-column array into specified classes. Learn more | ||||||||||||||||||||||
13 | Array | GROWTH | GROWTH(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 | Array | LINEST | LINEST(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 | Array | LOGEST | LOGEST(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 | Array | MDETERM | MDETERM(square_matrix) | Returns the matrix determinant of a square matrix specified as an array or range. Learn more | ||||||||||||||||||||||
17 | Array | MINVERSE | MINVERSE(square_matrix) | Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more | ||||||||||||||||||||||
18 | Array | MMULT | MMULT(matrix1, matrix2) | Calculates the matrix product of two matrices specified as arrays or ranges. Learn more | ||||||||||||||||||||||
19 | Array | SUMPRODUCT | SUMPRODUCT(array1, [array2, ...]) | Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more | ||||||||||||||||||||||
20 | Array | SUMX2MY2 | SUMX2MY2(array_x, array_y) | Calculates the sum of the differences of the squares of values in two arrays. Learn more | ||||||||||||||||||||||
21 | Array | SUMX2PY2 | SUMX2PY2(array_x, array_y) | Calculates the sum of the sums of the squares of values in two arrays. Learn more | ||||||||||||||||||||||
22 | Array | SUMXMY2 | SUMXMY2(array_x, array_y) | Calculates the sum of the squares of differences of values in two arrays. Learn more | ||||||||||||||||||||||
23 | Array | TRANSPOSE | TRANSPOSE(array_or_range) | Transposes the rows and columns of an array or range of cells. Learn more | ||||||||||||||||||||||
24 | Array | TREND | TREND(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 | Database | DAVERAGE | DAVERAGE(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 | Database | DCOUNT | DCOUNT(database, field, criteria) | Counts numeric values selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||
27 | Database | DCOUNTA | DCOUNTA(database, field, criteria) | Counts values, including text, selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||
28 | Database | DGET | DGET(database, field, criteria) | Returns a single value from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||
29 | Database | DMAX | DMAX(database, field, criteria) | Returns the maximum value selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||
30 | Database | DMIN | DMIN(database, field, criteria) | Returns the minimum value selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||
31 | Database | DPRODUCT | DPRODUCT(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 | Database | DSTDEV | DSTDEV(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 | Database | DSTDEVP | DSTDEVP(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 | Database | DSUM | DSUM(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 | Database | DVAR | DVAR(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 | Database | DVARP | DVARP(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 | Date | DATE | DATE(year, month, day) | Converts a provided year, month, and day into a date. Learn more | ||||||||||||||||||||||
38 | Date | DATEDIF | DATEDIF(start_date, end_date, unit) | Calculates the number of days, months, or years between two dates. Learn more | ||||||||||||||||||||||
39 | Date | DATEVALUE | DATEVALUE(date_string) | Converts a provided date string in a known format to a date value. Learn more | ||||||||||||||||||||||
40 | Date | DAY | DAY(date) | Returns the day of the month that a specific date falls on, in numeric format. Learn more | ||||||||||||||||||||||
41 | Date | DAYS | DAYS(end_date, start_date) | Returns the number of days between two dates. Learn more. | ||||||||||||||||||||||
42 | Date | DAYS360 | DAYS360(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 | Date | EDATE | EDATE(start_date, months) | Returns a date a specified number of months before or after another date. Learn more | ||||||||||||||||||||||
44 | Date | EOMONTH | EOMONTH(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 | Date | HOUR | HOUR(time) | Returns the hour component of a specific time, in numeric format. Learn more | ||||||||||||||||||||||
46 | Date | ISOWEEKNUM | ISOWEEKNUM(date) | Returns the number of the ISO week of the year where the provided date falls. Learn more | ||||||||||||||||||||||
47 | Date | MINUTE | MINUTE(time) | Returns the minute component of a specific time, in numeric format. Learn more | ||||||||||||||||||||||
48 | Date | MONTH | MONTH(date) | Returns the month of the year a specific date falls in, in numeric format. Learn more | ||||||||||||||||||||||
49 | Date | NETWORKDAYS | NETWORKDAYS(start_date, end_date, [holidays]) | Returns the number of net working days between two provided days. Learn more | ||||||||||||||||||||||
50 | Date | NETWORKDAYS.INTL | NETWORKDAYS.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 | Date | NOW | NOW() | Returns the current date and time as a date value. Learn more | ||||||||||||||||||||||
52 | Date | SECOND | SECOND(time) | Returns the second component of a specific time, in numeric format. Learn more | ||||||||||||||||||||||
53 | Date | TIME | TIME(hour, minute, second) | Converts a provided hour, minute, and second into a time. Learn more | ||||||||||||||||||||||
54 | Date | TIMEVALUE | TIMEVALUE(time_string) | Returns the fraction of a 24-hour day the time represents. Learn more | ||||||||||||||||||||||
55 | Date | TODAY | TODAY() | Returns the current date as a date value. Learn more | ||||||||||||||||||||||
56 | Date | WEEKDAY | WEEKDAY(date, [type]) | Returns a number representing the day of the week of the date provided. Learn more | ||||||||||||||||||||||
57 | Date | WEEKNUM | WEEKNUM(date, [type]) | Returns a number representing the week of the year where the provided date falls. Learn more | ||||||||||||||||||||||
58 | Date | WORKDAY | WORKDAY(start_date, num_days, [holidays]) | Calculates the end date after a specified number of working days. Learn more | ||||||||||||||||||||||
59 | Date | WORKDAY.INTL | WORKDAY.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 | Date | YEAR | YEAR(date) | Returns the year specified by a given date. Learn more | ||||||||||||||||||||||
61 | Date | YEARFRAC | YEARFRAC(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 | Engineering | BIN2DEC | BIN2DEC(signed_binary_number) | Converts a signed binary number to decimal format. Learn more | ||||||||||||||||||||||
63 | Engineering | BIN2HEX | BIN2HEX(signed_binary_number, [significant_digits]) | Converts a signed binary number to signed hexadecimal format. Learn more | ||||||||||||||||||||||
64 | Engineering | BIN2OCT | BIN2OCT(signed_binary_number, [significant_digits]) | Converts a signed binary number to signed octal format. Learn more | ||||||||||||||||||||||
65 | Engineering | BITAND | BITAND(value1, value2) | Bitwise boolean AND of two numbers. Learn more. | ||||||||||||||||||||||
66 | Engineering | BITLSHIFT | BITLSHIFT(value, shift_amount) | Shifts the bits of the input a certain number of places to the left. Learn more. | ||||||||||||||||||||||
67 | Engineering | BITOR | BITOR(value1, value2) | Bitwise boolean OR of 2 numbers. Learn more. | ||||||||||||||||||||||
68 | Engineering | BITRSHIFT | BITRSHIFT(value, shift_amount) | Shifts the bits of the input a certain number of places to the right. Learn more. | ||||||||||||||||||||||
69 | Engineering | BITXOR | BITXOR(value1, value2) | Bitwise XOR (exclusive OR) of 2 numbers. Learn more. | ||||||||||||||||||||||
70 | Engineering | COMPLEX | COMPLEX(real_part, imaginary_part, [suffix]) | Creates a complex number given real and imaginary coefficients. Learn more | ||||||||||||||||||||||
71 | Engineering | DEC2BIN | DEC2BIN(decimal_number, [significant_digits]) | Converts a decimal number to signed binary format. Learn more | ||||||||||||||||||||||
72 | Engineering | DEC2HEX | DEC2HEX(decimal_number, [significant_digits]) | Converts a decimal number to signed hexadecimal format. Learn more | ||||||||||||||||||||||
73 | Engineering | DEC2OCT | DEC2OCT(decimal_number, [significant_digits]) | Converts a decimal number to signed octal format. Learn more | ||||||||||||||||||||||
74 | Engineering | DELTA | DELTA(number1, [number2]) | Compare two numeric values, returning 1 if they're equal. Learn more | ||||||||||||||||||||||
75 | Engineering | ERF | ERF(lower_bound, [upper_bound]) | The ERF function returns the integral of the Gauss error function over an interval of values. Learn more. | ||||||||||||||||||||||
76 | Engineering | ERF.PRECISE | ERF.PRECISE(lower_bound, [upper_bound]) | See ERF | ||||||||||||||||||||||
77 | Engineering | GESTEP | GESTEP(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 | Engineering | HEX2BIN | HEX2BIN(signed_hexadecimal_number, [significant_digits]) | Converts a signed hexadecimal number to signed binary format. Learn more | ||||||||||||||||||||||
79 | Engineering | HEX2DEC | HEX2DEC(signed_hexadecimal_number) | Converts a signed hexadecimal number to decimal format. Learn more | ||||||||||||||||||||||
80 | Engineering | HEX2OCT | HEX2OCT(signed_hexadecimal_number, significant_digits) | Converts a signed hexadecimal number to signed octal format. Learn more | ||||||||||||||||||||||
81 | Engineering | IMABS | IMABS(number) | Returns absolute value of a complex number. Learn more | ||||||||||||||||||||||
82 | Engineering | IMAGINARY | IMAGINARY(complex_number) | Returns the imaginary coefficient of a complex number. Learn more | ||||||||||||||||||||||
83 | Engineering | IMARGUMENT | IMARGUMENT(number) | The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians. Learn more. | ||||||||||||||||||||||
84 | Engineering | IMCONJUGATE | IMCONJUGATE(number) | Returns the complex conjugate of a number. Learn more | ||||||||||||||||||||||
85 | Engineering | IMCOS | IMCOS(number) | The IMCOS function returns the cosine of the given complex number. Learn more. | ||||||||||||||||||||||
86 | Engineering | IMCOSH | IMCOSH(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 | Engineering | IMCOT | IMCOT(number) | Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)." Learn more. | ||||||||||||||||||||||
88 | Engineering | IMCOTH | IMCOTH(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 | Engineering | IMCSC | IMCSC(number) | Returns the cosecant of the given complex number. Learn more. | ||||||||||||||||||||||
90 | Engineering | IMCSCH | IMCSCH(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 | Engineering | IMDIV | IMDIV(dividend, divisor) | Returns one complex number divided by another. Learn more | ||||||||||||||||||||||
92 | Engineering | IMEXP | IMEXP(exponent) | Returns Euler's number, e (~2.718) raised to a complex power. Learn more. | ||||||||||||||||||||||
93 | Engineering | IMLOG | IMLOG(value, base) | Returns the logarithm of a complex number for a specified base. Learn more. | ||||||||||||||||||||||
94 | Engineering | IMLOG10 | IMLOG10(value) | Returns the logarithm of a complex number with base 10. Learn more. | ||||||||||||||||||||||
95 | Engineering | IMLOG2 | IMLOG2(value) | Returns the logarithm of a complex number with base 2. Learn more. | ||||||||||||||||||||||
96 | Engineering | IMPRODUCT | IMPRODUCT(factor1, [factor2, ...]) | Returns the result of multiplying a series of complex numbers together. Learn more | ||||||||||||||||||||||
97 | Engineering | IMREAL | IMREAL(complex_number) | Returns the real coefficient of a complex number. Learn more | ||||||||||||||||||||||
98 | Engineering | IMSEC | IMSEC(number) | Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)." Learn more. | ||||||||||||||||||||||
99 | Engineering | IMSECH | IMSECH(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 | Engineering | IMSIN | IMSIN (number) | Returns the sine of the given complex number. Learn more. |