ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Source:
4
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])
15
ArrayLOGESTLOGEST(known_data_y, [known_data_x], [b], [verbose])
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
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
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
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
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
63
64
EngineeringBIN2OCTBIN2OCT(signed_binary_number, [significant_digits])Converts a signed binary number to signed octal format. Learn more
65
66
EngineeringBITLSHIFTBITLSHIFT(value, shift_amount)Shifts the bits of the input a certain number of places to the left. Learn more.
67
68
EngineeringBITRSHIFTBITRSHIFT(value, shift_amount)Shifts the bits of the input a certain number of places to the right. Learn more.
69
70
EngineeringCOMPLEXCOMPLEX(real_part, imaginary_part, [suffix])Creates a complex number given real and imaginary coefficients. Learn more
71
72
73
74
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
79
80
81
82
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
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
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
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