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

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TypeNameDescription
2
ArrayARRAY_CONSTRAINARRAY_CONSTRAIN(input_range, num_rows, num_cols)Constrains an array result to a specified size. Learn more
3
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
4
ArraySUMXMY2SUMXMY2(array_x, array_y)Calculates the sum of the squares of differences of values in two arrays. Learn more
5
ArraySUMX2PY2SUMX2PY2(array_x, array_y)Calculates the sum of the sums of the squares of values in two arrays. Learn more
6
ArraySUMX2MY2SUMX2MY2(array_x, array_y)Calculates the sum of the differences of the squares of values in two arrays. Learn more
7
ArraySUMPRODUCTSUMPRODUCT(array1, [array2, ...])Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more
8
ArrayMMULTMMULT(matrix1, matrix2)Calculates the matrix product of two matrices specified as arrays or ranges. Learn more
9
ArrayMINVERSEMINVERSE(square_matrix)Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more
10
ArrayMDETERMMDETERM(square_matrix)Returns the matrix determinant of a square matrix specified as an array or range. Learn more
11
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
12
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
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
ArrayFREQUENCYFREQUENCY(data, classes)Calculates the frequency distribution of a one-column array into specified classes. Learn more
15
ArrayTRANSPOSETRANSPOSE(array_or_range)Transposes the rows and columns of an array or range of cells. Learn more
16
DatabaseDMINDMIN(database, field, criteria)Returns the minimum value selected from a database table-like array or range using a SQL-like query. Learn more
17
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
18
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
19
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
20
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
21
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
22
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
23
DatabaseDMAXDMAX(database, field, criteria)Returns the maximum value selected from a database table-like array or range using a SQL-like query. Learn more
24
DatabaseDGETDGET(database, field, criteria)Returns a single value from a database table-like array or range using a SQL-like query. Learn more
25
DatabaseDCOUNTADCOUNTA(database, field, criteria)Counts values, including text, 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
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
28
DateDATEVALUEDATEVALUE(date_string)Converts a provided date string in a known format to a date value. Learn more
29
DateDAYDAY(date)Returns the day of the month that a specific date falls on, in numeric format. Learn more
30
DateDAYSDAYS(end_date, start_date)Returns the number of days between two dates.
31
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
32
DateEDATEEDATE(start_date, months)Returns a date a specified number of months before or after another date. Learn more
33
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
34
DateHOURHOUR(time)Returns the hour component of a specific time, in numeric format. Learn more
35
DateISOWEEKNUMISOWEEKNUM(date)Returns the number of the ISO week of the year where the provided date falls. Learn more
36
DateMINUTEMINUTE(time)Returns the minute component of a specific time, in numeric format. Learn more
37
DateMONTHMONTH(date)Returns the month of the year a specific date falls in, in numeric format. Learn more
38
DateNETWORKDAYSNETWORKDAYS(start_date, end_date, [holidays])Returns the number of net working days between two provided days. Learn more
39
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
40
DateNOWNOW()Returns the current date and time as a date value. Learn more
41
DateSECONDSECOND(time)Returns the second component of a specific time, in numeric format. Learn more
42
DateTIMETIME(hour, minute, second)Converts a provided hour, minute, and second into a time. Learn more
43
DateTIMEVALUETIMEVALUE(time_string)Returns the fraction of a 24-hour day the time represents. Learn more
44
DateTODAYTODAY()Returns the current date as a date value. Learn more
45
DateWEEKDAYWEEKDAY(date, [type])Returns a number representing the day of the week of the date provided. Learn more
46
DateWEEKNUMWEEKNUM(date, [type])Returns a number representing the week of the year where the provided date falls. Learn more
47
DateWORKDAYWORKDAY(start_date, num_days, [holidays])Calculates the end date after a specified number of working days. Learn more
48
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
49
DateYEARYEAR(date)Returns the year specified by a given date. Learn more
50
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
51
DateDATEDATE(year, month, day)Converts a provided year, month, and day into a date. Learn more
52
DateDATEDIFDATEDIF(start_date, end_date, unit)Calculates the number of days, months, or years between two dates. Learn more
53
EngineeringOCT2BINOCT2BIN(signed_octal_number, [significant_digits])Converts a signed octal number to signed binary format. Learn more
54
EngineeringIMSUBIMSUB(first_number, second_number)Returns the difference between two complex numbers. Learn more
55
EngineeringIMREALIMREAL(complex_number)Returns the real coefficient of a complex number. Learn more
56
EngineeringIMPRODUCTIMPRODUCT(factor1, [factor2, ...])Returns the result of multiplying a series of complex numbers together. Learn more
57
EngineeringIMDIVIMDIV(dividend, divisor)Returns one complex number divided by another. Learn more
58
EngineeringIMCONJUGATEIMCONJUGATE(number)Returns the complex conjugate of a number. Learn more
59
EngineeringIMAGINARYIMAGINARY(complex_number)Returns the imaginary coefficient of a complex number. Learn more
60
EngineeringIMABSIMABS(number)Returns absolute value of a complex number. Learn more
61
EngineeringHEX2OCTHEX2OCT(signed_hexadecimal_number, significant_digits)Converts a signed hexadecimal number to signed octal format. Learn more
62
EngineeringHEX2DECHEX2DEC(signed_hexadecimal_number)Converts a signed hexadecimal number to decimal format. Learn more
63
EngineeringHEX2BINHEX2BIN(signed_hexadecimal_number, [significant_digits])Converts a signed hexadecimal number to signed binary format. Learn more
64
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.
65
EngineeringERFERF(z1, [z2])Returns the result of the Gauss error function.
66
EngineeringDELTADELTA(number1, [number2])Compare two numeric values, returning 1 if they're equal. Learn more
67
EngineeringDEC2OCTDEC2OCT(decimal_number, [significant_digits])Converts a decimal number to signed octal format. Learn more
68
EngineeringDEC2HEXDEC2HEX(decimal_number, [significant_digits])Converts a decimal number to signed hexadecimal format. Learn more
69
EngineeringDEC2BINDEC2BIN(decimal_number, [significant_digits])Converts a decimal number to signed binary format. Learn more
70
EngineeringCOMPLEXCOMPLEX(real_part, imaginary_part, [suffix])Creates a complex number given real and imaginary coefficients. Learn more
71
EngineeringBITXORBITXOR(value1, value2)Bitwise boolean XOR (exclusive or) of two numbers.
72
EngineeringBITRSHIFTBITRSHIFT(value, shift_amount)Shifts the bits of the input a certain number of places to the right.
73
EngineeringBITORBITOR(value1, value2)Bitwise boolean OR of two numbers.
74
EngineeringBITLSHIFTBITLSHIFT(value, shift_amount)Shifts the bits of the input a certain number of places to the left.
75
EngineeringBITANDBITAND(value1, value2)Bitwise boolean AND of two numbers.
76
EngineeringBIN2OCTBIN2OCT(signed_binary_number, [significant_digits])Converts a signed binary number to signed octal format. Learn more
77
EngineeringOCT2DECOCT2DEC(signed_octal_number)Converts a signed octal number to decimal format. Learn more
78
EngineeringBIN2HEXBIN2HEX(signed_binary_number, [significant_digits])Converts a signed binary number to signed hexadecimal format. Learn more
79
EngineeringBIN2DECBIN2DEC(signed_binary_number)Converts a signed binary number to decimal format. Learn more
80
EngineeringIMSUMIMSUM(value1, [value2, ...])Returns the sum of a series of complex numbers. Learn more
81
EngineeringOCT2HEXOCT2HEX(signed_octal_number, [significant_digits])Converts a signed octal number to signed hexadecimal format. Learn more
82
FilterFILTERFILTER(range, condition1, [condition2])Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. Learn more
83
FilterSORTSORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])Sorts the rows of a given array or range by the values in one or more columns. Learn more
84
FilterSORTNSORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)Returns the first n items in a data set after performing a sort. Learn more
85
FilterUNIQUEUNIQUE(range)Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Learn more
86
FinancialISPMTISPMT(rate, period, number_of_periods, present_value)Interest payment. Calculates the interest paid at a particular period of an investment.
87
FinancialPMTPMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
88
FinancialPPMTPPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate. Learn more
89
FinancialPRICEPRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more
90
FinancialPRICEDISCPRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])Calculates the price of a discount (non-interest-bearing) security, based on expected yield. Learn more
91
FinancialPRICEMATPRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])Calculates the price of a security paying interest at maturity, based on expected yield. Learn more
92
FinancialPVPV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
93
FinancialRATERATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate. Learn more
94
FinancialRECEIVEDRECEIVED(settlement, maturity, investment, discount, [day_count_convention])Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date. Learn more
95
FinancialSLNSLN(cost, salvage, life)Calculates the depreciation of an asset for one period using the straight-line method. Learn more
96
FinancialSYDSYD(cost, salvage, life, period)Calculates the depreciation of an asset for a specified period using the sum of years digits method. Learn more
97
FinancialTBILLEQTBILLEQ(settlement, maturity, discount)Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more
98
FinancialTBILLPRICETBILLPRICE(settlement, maturity, discount)Calculates the price of a US Treasury Bill based on discount rate. Learn more
99
FinancialTBILLYIELDTBILLYIELD(settlement, maturity, price)Calculates the yield of a US Treasury Bill based on price. Learn more
100
FinancialVDBVDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])Returns the depreciation of an asset for a particular period (or partial period).
Loading...
Main menu