Google Sheets function list

Google Spreadsheets supports cell formulas typically found in most desktop spreadsheet packages. These formulae can be used to create functions that manipulate data and calculate strings and numbers.

Here's a list of all the functions available in each category. When using them, don't forget to add quotation marks around all function components consisting of alphabetic characters that aren't referring to cells or columns.

You can change the language of Google Sheets functions between English and 21 other languages.

TypeNameSyntaxDescription
DateDATEDATE(year, month, day) Converts a provided year, month and day into a date. Learn more
DateDATEDIFDATEDIF(start_date, end_date, unit) Calculates the number of days, months or years between two dates. Learn more
DateDATEVALUEDATEVALUE(date_string) Converts a provided date string in a known format into a date value. Learn more
DateDAYDAY(date) Returns the day of the month that a specific date falls on, in numerical format. Learn more
DateDAYSDAYS(end_date, start_date)Returns the number of days between two dates. Learn more. 
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
DateEDATEEDATE(start_date, months) Returns a date that is a specified number of months before or after another date. Learn more
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
DateHOURHOUR(time) Returns the hour component of a specific time, in numerical format. Learn more
Date
DateMINUTEMINUTE(time) Returns the minute component of a specific time, in numerical format. Learn more
DateMONTHMONTH(date) Returns the month of the year that a specific date falls in, in numerical format. Learn more
DateNETWORKDAYSNETWORKDAYS(start_date, end_date, [holidays]) Returns the number of net working days between two provided days. Learn more
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
DateNOWNOW() Returns the current date and time as a date value. Learn more
DateSECONDSECOND(time) Returns the second component of a specific time, in numerical format. Learn more
DateTIMETIME(hour, minute, second) Converts a provided hour, minute and second into a time. Learn more
DateTIMEVALUETIMEVALUE(time_string) Returns the fraction of a 24-hour day that the time represents. Learn more
DateTODAYTODAY() Returns the current date as a date value. Learn more
DateWEEK DAYWEEK DAY(date, [type]) Returns a number representing the day of the week of the date provided. Learn more
DateWEEKNUMWEEKNUM(date, [type]) Returns a number representing the week of the year where the provided date falls. Learn more
DateWORKDAYWORKDAY(start_date, num_days, [holidays]) Calculates the end date after a specified number of working days. Learn more
DateWORKDAY.INTLWORKDAY.INTL(start_date, num_days, [weekend], [holidays]) Calculates the date after a specified number of working days excluding specified weekend days and holidays. Learn more
DateYEARYEAR(date) Returns the year specified by a given date. Learn more
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
Engineering
Engineering
Engineering
EngineeringBITANDBITAND(value1, value2)Bitwise Boolean AND of two numbers. Learn more. 
EngineeringBITLSHIFTBITLSHIFT(value, shift_amount)Shifts the bits of the input a certain number of places to the left. Learn more. 
EngineeringBITORBITOR(value1, value2)Bitwise Boolean OR of 2 numbers. Learn more. 
EngineeringBITRSHIFTBITRSHIFT(value, shift_amount)Shifts the bits of the input a certain number of places to the right. Learn more. 
EngineeringBITXORBITXOR(value1, value2)Bitwise XOR (exclusive OR) of two numbers. Learn more. 
EngineeringCOMPLEXCOMPLEX(real_part, imaginary_part, [suffix])Creates a complex number given real and imaginary coefficients. Learn more
Engineering
Engineering
Engineering
EngineeringDELTADELTA(number1, [number2]) Compare two numerical values, returning 1 if they're equal. Learn more
EngineeringERFERF(lower_bound, [upper_bound])The ERF function returns the integral of the Gauss error function over an interval of values. Learn more.
EngineeringERF.PRECISEERF.PRECISE(lower_bound, [upper_bound]) See ERF
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. 
Engineering
EngineeringHEX2DECHEX2DEC(signed_hexadecimal_number) Converts a signed hexadecimal number to decimal format. Learn more
Engineering
EngineeringIMABSIMABS(number)Returns absolute value of a complex number. Learn more
EngineeringIMAGINARYIMAGINARY(complex_number)Returns the imaginary coefficient of a complex number. Learn more
EngineeringIMARGUMENTIMARGUMENT(number)The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians. Learn more.
EngineeringIMCONJUGATEIMCONJUGATE(number)Returns the complex conjugate of a number. Learn more
EngineeringIMCOSIMCOS(number)The IMCOS function returns the cosine of the given complex number. Learn more.
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.
EngineeringIMCOTIMCOT(number)Returns the cotangent of the given complex number. For example, a given complex number 'x+yi' returns 'cot(x+yi)'. Learn more.
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.
EngineeringIMCSCIMCSC(number)Returns the cosecant of the given complex number. Learn more.
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.
EngineeringIMDIVIMDIV(dividend, divisor)Returns one complex number divided by another. Learn more
EngineeringIMEXPIMEXP(exponent)Returns Euler's number, e (~2.718) raised to a complex power. Learn more.
EngineeringIMLOGIMLOG(value, base)Returns the logarithm of a complex number for a specified base. Learn more.
EngineeringIMLOG10IMLOG10(value) Returns the logarithm of a complex number with base 10. Learn more.
EngineeringIMLOG2IMLOG2(value)Returns the logarithm of a complex number with base 2. Learn more.
EngineeringIMPRODUCTIMPRODUCT(factor1, [factor2, …])Returns the result of multiplying a series of complex numbers together. Learn more
EngineeringIMREALIMREAL(complex_number)Returns the real coefficient of a complex number. Learn more
EngineeringIMSECIMSEC(number)Returns the secant of the given complex number. For example, a given complex number 'x+yi' returns 'sec(x+yi)'. Learn more.
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.
EngineeringIMSINIMSIN (number)Returns the sine of the given complex number. Learn more.
EngineeringIMSINHIMSINH(number)Returns the hyperbolic sine of the given complex number. For example, a given complex number 'x+yi' returns 'sinh(x+yi)'. Learn more.
EngineeringIMSUBIMSUB(first_number, second_number)Returns the difference between two complex numbers. Learn more
EngineeringIMSUMIMSUM(value1, [value2, …])Returns the sum of a series of complex numbers. Learn more
EngineeringIMTANIMTAN(number)Returns the tangent of the given complex number. Learn more.
EngineeringIMTANHIMTANH(number)Returns the hyperbolic tangent of the given complex number. For example, a given complex number 'x+yi' returns 'tanh(x+yi)'. Learn more.
Engineering
Engineering
Engineering
FilterFILTERFILTER(range, condition1, [condition2]) Returns a filtered version of the source range, returning only rows or columns that meet the specified conditions. Learn more
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
Filter
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
Financial
Financial
FinancialAMORLINCAMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period. Learn more. 
Financial
Financial
FinancialCOUPDAYSNCCOUPDAYSNC(settlement, maturity, frequency, [day_count_convention]) Calculates the number of days from the settlement date until the next coupon or interest payment. Learn more
Financial
Financial
Financial
Financial
Financial
Financial
Financial
Financial
Financial
Financial
FinancialDURATIONDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) . Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value. Learn more
Financial
FinancialFVFV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning]) Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
Financial
FinancialINTRATEINTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention]) Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself. Learn more
FinancialIPMTIPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
FinancialIRRIRR(cashflow_amounts, [rate_guess]) Calculates the internal rate of return on an investment based on a series of periodic cash flows. Learn more
FinancialISPMTISPMT(rate, period, number_of_periods, present_value)The ISPMT function calculates the interest paid during a particular period of an investment. Learn more.
Financial
Financial
Financial
FinancialNPERNPER(rate, payment_amount, present_value, [future_value], [end_or_beginning]) Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
FinancialNPVNPV(discount, cashflow1, [cashflow2, ...]) Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. Learn more
FinancialPDURATIONPDURATION(rate, present_value, future_value)Returns the number of periods for an investment to reach a specific value at a given rate. Learn more.
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
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
Financial
Financial
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
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
Financial
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
FinancialRRIRRI(number_of_periods, present_value, future_value)Returns the interest rate needed for an investment to reach a specific value within a given number of periods. Learn more.
Financial
Financial
Financial
Financial
Financial
FinancialVDBVDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])Returns the depreciation of an asset for a particular period (or partial period). Learn more.
FinancialXIRRXIRR(cashflow_amounts, cashflow_dates, [rate_guess]) Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows. Learn more
Financial
Financial
FinancialYIELDDISCYIELDDISC(settlement, maturity, price, redemption, [day_count_convention]) Calculates the annual yield of a discount (non-interest-bearing) security, based on price. Learn more
Financial
GoogleARRAYFORMULAARRAYFORMULA(array_formula) Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays. Learn more
GoogleDETECTLANGUAGEDETECTLANGUAGE(text_or_range) Identifies the language used in text within the specified range. Learn more
GoogleGOOGLEFINANCEGOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval]) Fetches current or historical securities information from Google Finance. Learn more
GoogleGOOGLETRANSLATEGOOGLETRANSLATE(text, [source_language], [target_language]) Translates text from one language into another Learn more
GoogleIMAGEIMAGE(url, [mode], [height], [width]) Inserts an image into a cell. Learn more
GoogleQUERYQUERY(data, query, [headers]) Runs a Google Visualisation API Query Language query across data. Learn more
GoogleSPARKLINESPARKLINE(data, [options]) Creates a miniature chart contained within a single cell. Learn more
Info
InfoISBLANKISBLANK(value) Checks whether the referenced cell is empty. Learn more
InfoISDATEISDATE(value)Returns whether a value is a date. Learn more. 
InfoISEMAILISEMAIL(value) Checks whether a value is a valid email address. Learn more
Info
InfoISERRORISERROR(value) Checks whether a value is an error. Learn more
Info
InfoISLOGICALISLOGICAL(value) Checks whether a value is `TRUE` or `FALSE`. Learn more
InfoISNAISNA(value) Checks whether a value is the error `#N/A`. Learn more
Info
InfoISNUMBERISNUMBER(value) Checks whether a value is a number. Learn more
Info
InfoISTEXTISTEXT(value) Checks whether a value is text. Learn more
InfoNN(value) Returns the argument provided as a number. Learn more
InfoNANA() Returns the 'value not available' error, `#N/A`. Learn more
InfoTYPETYPE(value) Returns a number associated with the type of data passed into the function. Learn more
InfoCELLCELL(info_type, reference) Returns the requested information about the specified cell. Learn more
LogicalANDAND(logical_expression1, [logical_expression2, ...]) Returns true if all of the provided arguments are logically true and false if any of the provided arguments are logically false. Learn more
LogicalFALSEFALSE() Returns the logical value 'FALSE'. Learn more
LogicalIFIF(logical_expression, value_if_true, value_if_false) Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Learn more
LogicalIFERRORIFERROR(value, [value_if_error]) Returns the first argument if it is not an error value, otherwise returns the second argument if present or a blank if the second argument is absent. Learn more
LogicalIFNAIFNA(value, value_if_na)Evaluates a value. If the value is an #N/A error, returns the specified value. Learn more.
LogicalIFSIFS(condition1, value1, [condition2, value2], …) Evaluates multiple conditions and returns a value that corresponds to the first true condition. Learn more.
LogicalNOTNOT(logical_expression) Returns the opposite of a logical value – 'NOT(TRUE)' returns 'FALSE'; 'NOT(FALSE)' returns 'TRUE'. Learn more
LogicalOROR(logical_expression1, [logical_expression2, ...]) Returns true if any of the provided arguments are logically true and false if all of the provided arguments are logically false. Learn more
Logical
LogicalTRUETRUE() Returns the logical value `TRUE`. Learn more
LogicalXORXOR(logical_expression1, [logical_expression2, …]) The XOR function performs an exclusive OR of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise. Learn more.
LookupADDRESSADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet]) Returns a cell reference as a string. Learn more
LookupCHOOSECHOOSE(index, choice1, [choice2, ...]) Returns an element from a list of choices based on index. Learn more
LookupCOLUMNCOLUMN([cell_reference]) Returns the column number of a specified cell, with 'A=1'. Learn more
LookupCOLUMNSCOLUMNS(range) Returns the number of columns in a specified array or range. Learn more
LookupFORMULATEXTFORMULATEXT(cell)Returns the formula as a string. Learn more.
Lookup
LookupHLOOKUPHLOOKUP(search_key, range, index, [is_sorted]) Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found. Learn more
LookupINDEXINDEX(reference, [row], [column]) Returns the content of a cell specified by row and column offset. Learn more
LookupINDIRECTINDIRECT(cell_reference_as_string, [is_A1_notation]) Returns a cell reference specified by a string. Learn more
LookupLOOKUPLOOKUP(search_key, search_range|search_result_array, [result_range]) Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. Learn more
LookupMATCHMATCH(search_key, range, [search_type]) Returns the relative position of an item in a range that matches a specified value. Learn more
LookupOFFSETOFFSET(cell_reference, offset_rows, offset_columns, [height], [width]) Returns a range reference that shifts a specified number of rows and columns from a starting cell reference. Learn more
LookupROWROW([cell_reference]) Returns the row number of a specified cell. Learn more
LookupROWSROWS(range) Returns the number of rows in a specified array or range. Learn more
LookupVLOOKUPVLOOKUP(search_key, range, index, [is_sorted]) Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found. Learn more
MathsABSABS(value) Returns the absolute value of a number. Learn more
Maths
Maths
Maths
Math
Maths
Maths
Maths
Maths
Maths
Maths
MathsCEILINGCEILING(value, [factor]) Rounds a number up to the nearest integer multiple of specified significance. Learn more
Maths
MathsCEILING.PRECISECEILING.PRECISE(number, [significance])Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up. Learn more. 
MathsCOMBINCOMBIN(n, k) Returns the number of ways to choose some number of objects from a pool of a given size of objects. Learn more
MathsCOMBINACOMBINA(n, k)Returns the number of ways to choose some number of objects from a pool of a given set of objects, including ways that choose the same object multiple times. Learn more.
Maths
Maths
MathsCOTCOT(angle)Cotangent of an angle provided in radians. Learn more.
MathsCOTHCOTH(value)Returns the hyperbolic cotangent of any real number. Learn more.
MathsCOUNTBLANKCOUNTBLANK(range) Returns the number of empty cells in a given range. Learn more
MathsCOUNTIFCOUNTIF(range, criterion) Returns a conditional count across a range. Learn more
MathsCOUNTIFSCOUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...]) Returns the count of a range depending on multiple criteria. Learn more
MathsCOUNTUNIQUECOUNTUNIQUE(value1, [value2, …]) Counts the number of unique values in a list of specified values and ranges. Learn more
MathsCSCCSC(angle)Returns the cosecant of an angle provided in radians. Learn more.
MathsCSCHCSCH(value)The CSCH function returns the hyperbolic cosecant of any real number. Learn more.
MathsDECIMALDECIMAL(value, base)The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal). Learn more.
MathsDEGREESDEGREES(angle) Converts an angle value in radians to degrees. Learn more
Maths
MathsERFC.PRECISEERFC.PRECISE(z) See ERFC
Maths
Maths
Maths
Maths
MathsFLOORFLOOR(value, [factor]) Rounds a number down to the nearest integer multiple of specified significance. Learn more
MathsFLOOR.MATHFLOOR.MATH(number, [significance], [mode])Rounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more. 
MathsFLOOR.PRECISEFLOOR.PRECISE(number, [significance])The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance. Learn more.
Maths
MathsGAMMALN.PRECISEGAMMALN.PRECISE(value) See GAMMALN
Maths
Maths
Maths
Maths
MathsINTINT(value) Rounds a number down to the nearest integer that is less than or equal to it. Learn more
Maths
MathsISO.CEILINGISO.CEILING(number, [significance]) See CEILING.PRECISE
Maths
Maths
Maths
MathsLOGLOG(value, base) Returns the logarithm of a number given a base. Learn more
Maths
MathsMODMOD(dividend, divisor) Returns the result of the modulo operator, the remainder after a division operation. Learn more
MathsMROUNDMROUND(value, factor) Rounds one number to the nearest integer multiple of another. Learn more
Maths
MathsMUNITMUNIT(dimension)Returns a unit matrix of size dimension x dimension. Learn more.
Maths
Maths
MathsPOWERPOWER(base, exponent) Returns a number raised to a power. Learn more
MathsPRODUCTPRODUCT(factor1, [factor2, ...]) Returns the result of multiplying a series of numbers together. Learn more
MathsQUOTIENTQUOTIENT(dividend, divisor) Returns one number divided by another. Learn more
Maths
MathsRANDRAND() Returns a random number between 0 inclusive and 1 exclusive. Learn more
MathsRANDARRAYRANDARRAY(rows, columns)Generates an array of random numbers between 0 and 1. Learn more.
MathsRANDBETWEENRANDBETWEEN(low, high) Returns a uniformly random integer between two values, inclusive. Learn more
MathsROUNDROUND(value, [places]) Rounds a number to a certain number of decimal places according to standard rules. Learn more
MathsROUNDDOWNROUNDDOWN(value, [places]) Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. Learn more
MathsROUNDUPROUNDUP(value, [places]) Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more
Maths
Maths
MathsSEQUENCESEQUENCE(rows, columns, start, step)Returns an array of sequential numbers, such as 1, 2, 3, 4. Learn more.
MathsSERIESSUMSERIESSUM(x, n, m, a) Given parameters x, n, m and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range 'a'. Learn more
Maths
Maths
Maths
MathsSQRTSQRT(value) Returns the positive square root of a positive number. Learn more
Maths
MathsSUBTOTALSUBTOTAL(function_code, range1, [range2, ...]) Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more
MathsSUMSUM(value1, [value2, ...]) Returns the sum of a series of numbers and/or cells. Learn more
MathsSUMIFSUMIF(range, criterion, [sum_range]) Returns a conditional sum across a range. Learn more
MathsSUMIFSSUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) Returns the sum of a range depending on multiple criteria. Learn more
MathsSUMSQSUMSQ(value1, [value2, ...]) Returns the sum of the squares of a series of numbers and/or cells. Learn more
Maths
Maths
MathsTRUNCTRUNC(value, [places]) Truncates a number to a certain number of significant digits by omitting less significant digits. Learn more
OperatorADDADD(value1, value2) Returns the sum of two numbers. Equivalent to the '+' operator. Learn more
OperatorCONCATCONCAT(value1, value2) Returns the concatenation of two values. Equivalent to the '&' operator. Learn more
OperatorDIVIDEDIVIDE(dividend, divisor) Returns one number divided by another. Equivalent to the '/' operator. Learn more
OperatorEQEQ(value1, value2) Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator. Learn more
OperatorGTGT(value1, value2) Returns 'TRUE' if the first argument is strictly greater than the second, and 'FALSE' otherwise. Equivalent to the '>' operator. Learn more
OperatorGTEGTE(value1, value2) Returns 'TRUE' if the first argument is greater than or equal to the second, and 'FALSE' otherwise. Equivalent to the '>=' operator. Learn more
OperatorLTLT(value1, value2) Returns 'TRUE' if the first argument is strictly less than the second, and 'FALSE' otherwise. Equivalent to the '<' operator. Learn more
OperatorLTELTE(value1, value2) Returns 'TRUE' if the first argument is less than or equal to the second, and 'FALSE' otherwise. Equivalent to the '<=' operator. Learn more
OperatorMINUSMINUS(value1, value2) Returns the difference of two numbers. Equivalent to the '-' operator. Learn more
OperatorMULTIPLYMULTIPLY(factor1, factor2) Returns the product of two numbers. Equivalent to the '*' operator. Learn more
OperatorNENE(value1, value2) Returns 'TRUE' if two specified values are not equal and 'FALSE' otherwise. Equivalent to the '<>' operator. Learn more
OperatorPOWPOW(base, exponent) Returns a number raised to a power. Learn more
OperatorUMINUSUMINUS(value) Returns a number with the sign reversed. Learn more
OperatorUNARY_PERCENTUNARY_PERCENT(percentage) Returns a value interpreted as a percentage; that is, 'UNARY_PERCENT(100)' equals '1'. Learn more
OperatorUPLUSUPLUS(value) Returns a specified number, unchanged. Learn more
StatisticalAVEDEVAVEDEV(value1, [value2, ...]) Calculates the average of the magnitude of deviations of data from a data set's mean. Learn more
StatisticalAVERAGEAVERAGE(value1, [value2, ...]) Returns the numerical average value in a data set, ignoring text. Learn more
StatisticalAVERAGE.WEIGHTEDAVERAGE.WEIGHTED(values, weights, [additional values], [additional weights]) Finds the weighted average of a set of values, given the values and the corresponding weights. Learn more.
StatisticalAVERAGEAAVERAGEA(value1, [value2, ...]) Returns the numerical average value in a data set. Learn more
StatisticalAVERAGEIFAVERAGEIF(criteria_range, criterion, [average_range]) Returns the average of a range depending on criteria. Learn more
StatisticalAVERAGEIFSAVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) Returns the average of a range depending on multiple criteria. Learn more
StatisticalBETA.DISTBETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound)Returns the probability of a given value as defined by the beta distribution function. Learn more.
StatisticalBETA.INVBETA.INV(probability, alpha, beta, lower_bound, upper_bound)Returns the value of the inverse beta distribution function for a given probability. Learn more. 
StatisticalBETADISTBETADIST(value, alpha, beta, lower_bound, upper_bound)See BETA.DIST.
StatisticalBETAINVBETAINV(probability, alpha, beta, lower_bound, upper_bound) See BETA.INV 
StatisticalBINOM.DISTBINOM.DIST(num_successes, num_trials, prob_success, cumulative) See BINOMDIST
StatisticalBINOM.INVBINOM.INV(num_trials, prob_success, target_prob) See CRITBINOM
Statistical
Statistical
StatisticalCHIINVCHIINV(probability, degrees_freedom) Calculates the inverse of the right-tailed chi-squared distribution. Learn more
StatisticalCHISQ.DISTCHISQ.DIST(x, degrees_freedom, cumulative) Calculates the left-tailed chi-squared distribution, often used in hypothesis testing. Learn more
Statistical
Statistical
Statistical
StatisticalCHISQ.TESTCHISQ.TEST(observed_range, expected_range)See CHITEST
Statistical
StatisticalCONFIDENCECONFIDENCE(alpha, standard_deviation, pop_size)See CONFIDENCE.NORM
StatisticalCONFIDENCE.NORMCONFIDENCE.NORM(alpha, standard_deviation, pop_size)Calculates the width of half of the confidence interval for a normal distribution. Learn more.
StatisticalCONFIDENCE.TCONFIDENCE.T(alpha, standard_deviation, size)Calculates the width of half the confidence interval for a Student’s t-distribution. Learn more.
StatisticalCORRELCORREL(data_y, data_x) Calculates r, the Pearson product-moment correlation coefficient of a data set. Learn more
StatisticalCOUNTCOUNT(value1, [value2, ...]) Returns a count of the number of numerical values in a data set. Learn more
StatisticalCOUNTACOUNTA(value1, [value2, ...]) Returns a count of the number of values in a data set. Learn more
Statistical
StatisticalCOVARIANCE.PCOVARIANCE.P(data_y, data_x) See COVAR
StatisticalCOVARIANCE.SCOVARIANCE.S(data_y, data_x)Calculates the covariance of a data set, where the data set is a sample of the total population. Learn more.
Statistical
Statistical
StatisticalEXPON.DISTEXPON.DIST(x, lambda, cumulative)Returns the value of the exponential distribution function with a specified lambda at a specified value. Learn more
StatisticalEXPONDISTEXPONDIST(x, lambda, cumulative)See EXPON.DIST
Statistical
Statistical
Statistical
Statistical
StatisticalF.TESTF.TEST(range1, range2) See FTEST.
Statistical
Statistical
Statistical
Statistical
StatisticalFORECASTFORECAST(x, data_y, data_x) Calculates the expected Y-value for a specified X based on a linear regression of a data set. Learn more
StatisticalFORECAST.LINEARFORECAST.LINEAR(x, data_y, data_x) See FORECAST
Statistical
StatisticalGAMMAGAMMA(number)Returns the Gamma function evaluated at the specified value. Learn more.
Statistical
StatisticalGAMMA.INVGAMMA.INV(probability, alpha, beta)The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters. Learn more.
Statistical
StatisticalGAMMAINVGAMMAINV(probability, alpha, beta)See GAMMA.INV.
StatisticalGAUSSGAUSS(z)The GAUSS function returns the probability that a random variable, drawn from a normal distribution, will be between the mean and z standard deviations above (or below) the mean. Learn more.
Statistical
Statistical
StatisticalHYPGEOM.DISTHYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size) See HYPGEOMDIST
StatisticalHYPGEOMDISTHYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size) Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without the replacement of draws. Learn more
Statistical
Statistical
StatisticalLARGELARGE(data, n) Returns the nth largest element from a data set, where n is user-defined. Learn more
Statistical
StatisticalLOGNORM.DISTLOGNORM.DIST(x, mean, standard_deviation)See LOGNORMDIST
StatisticalLOGNORM.INVLOGNORM.INV(x, mean, standard_deviation)See LOGINV
Statistical
StatisticalMAXMAX(value1, [value2, ...]) Returns the maximum value in a numerical data set. Learn more
Statistical
StatisticalMAXIFSMAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …) Returns the maximum value in a range of cells, filtered by a set of criteria. Learn more.
StatisticalMEDIANMEDIAN(value1, [value2, ...]) Returns the median value in a numerical data set. Learn more
StatisticalMINMIN(value1, [value2, ...]) Returns the minimum value in a numerical data set. Learn more
Statistical
Statistical
StatisticalMODEMODE(value1, [value2, ...]) Returns the most commonly occurring value in a dataset. Learn more
StatisticalMODE.MULTMODE.MULT(value1, value2)Returns the most commonly occurring values in a data set. Learn more.
StatisticalMODE.SNGLMODE.SNGL(value1, [value2, ...]) See MODE 
StatisticalNEGBINOM.DISTNEGBINOM.DIST(num_failures, num_successes, prob_success) See NEGBINOMDIST
Statistical
StatisticalNORM.DISTNORM.DIST(x, mean, standard_deviation, cumulative) See NORMDIST
StatisticalNORM.INVNORM.INV(x, mean, standard_deviation) See NORMINV
StatisticalNORM.S.DISTNORM.S.DIST(x) See NORMSDIST
StatisticalNORM.S.INVNORM.S.INV(x)See NORMSINV
StatisticalNORMDISTNORMDIST(x, mean, standard_deviation, cumulative) Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean and standard deviation. Learn more
Statistical
Statistical
Statistical
Statistical
StatisticalPERCENTILEPERCENTILE(data, percentile) Returns the value at a given percentile of a data set. Learn more
StatisticalPERCENTILE.EXCPERCENTILE.EXC(data, percentile)Returns the value at a given percentile of a data set, exclusive of 0 and 1. Learn more.
StatisticalPERCENTILE.INCPERCENTILE.INC(data, percentile)See PERCENTILE
StatisticalPERCENTRANKPERCENTRANK(data, value, [significant_digits]) Returns the percentage rank (percentile) of a specified value in a data set. Learn more
StatisticalPERCENTRANK.EXCPERCENTRANK.EXC(data, value, [significant_digits]) Returns the percentage rank (percentile) from 0 to 1, exclusive of a specified value in a data set. Learn more
StatisticalPERCENTRANK.INCPERCENTRANK.INC(data, value, [significant_digits]) Returns the percentage rank (percentile) from 0 to 1, inclusive of a specified value in a data set. Learn more
StatisticalPERMUTATIONAPERMUTATIONA(number, number_chosen)Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. Learn more.
Statistical
StatisticalPHIPHI(x)The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1. Learn more.
StatisticalPOISSONPOISSON(x, mean, cumulative)See POISSON.DIST
StatisticalPOISSON.DISTPOISSON.DIST(x, mean, [cumulative])Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean. Learn more
Statistical
StatisticalQUARTILEQUARTILE(data, quartile_number) Returns a value nearest to a specified quartile of a data set. Learn more
StatisticalQUARTILE.EXCQUARTILE.EXC(data, quartile_number)Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4. Learn more.
StatisticalQUARTILE.INCQUARTILE.INC(data, quartile_number)See QUARTILE
StatisticalRANKRANK(value, data, [is_ascending]) Returns the rank of a specified value in a data set. Learn more
StatisticalRANK.AVGRANK.AVG(value, data, [is_ascending]) Returns the rank of a specified value in a data set. If there is more than one entry of the same value in the data set, the average rank of the entries will be returned. Learn more
StatisticalRANK.EQRANK.EQ(value, data, [is_ascending]) Returns the rank of a specified value in a data set. If there is more than one entry of the same value in the data set, the top rank of the entries will be returned. Learn more
Statistical
Statistical
StatisticalSKEW.PSKEW.P(value1, value2)Calculates the skewness of a data set that represents the entire population. Learn more.
StatisticalSLOPESLOPE(data_y, data_x) Calculates the slope of the line resulting from linear regression of a data set. Learn more
Statistical
Statistical
StatisticalSTDEVSTDEV(value1, [value2, ...]) Calculates the standard deviation based on a sample. Learn more
StatisticalSTDEV.PSTDEV.P(value1, [value2, ...])See STDEVP
StatisticalSTDEV.SSTDEV.S(value1, [value2, ...])See STDEV
Statistical
Statistical
Statistical
Statistical
StatisticalT.DISTT.DIST(x, degrees_freedom, cumulative)Returns the right-tailed student distribution for a value x. Learn more.
StatisticalT.DIST.2TT.DIST.2T(x, degrees_freedom)Returns the two tailed student distribution for a value x. Learn more.
StatisticalT.DIST.RTT.DIST.RT(x, degrees_freedom)Returns the right-tailed Student distribution for a value x. Learn more.
Statistical
Statistical
StatisticalT.TESTT.TEST(range1, range2, tails, type)Returns the probability associated with a student's t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean. Learn more
StatisticalTDISTTDIST(x, degrees_freedom, tails) Calculates the probability for Student's t-distribution with a given input (x). Learn more
Statistical
Statistical
StatisticalTTESTTTEST(range1, range2, tails, type)See T.TEST.
StatisticalVARVAR(value1, [value2, ...]) Calculates the variance based on a sample. Learn more
StatisticalVAR.PVAR.P(value1, [value2, ...])See VARP
StatisticalVAR.SVAR.S(value1, [value2, ...])See VAR
Statistical
Statistical
StatisticalCalculates the variance based on an entire population, setting text to the value '0'. Learn more
Statistical
StatisticalWEIBULL.DISTWEIBULL.DIST(x, shape, scale, cumulative)See WEIBULL
StatisticalZ.TESTZ.TEST(data, value, [standard_deviation])Returns the one-tailed P-value of a Z-test with standard distribution. Learn more
StatisticalZTESTZTEST(data, value, [standard_deviation])See Z.TEST.
Text
TextASCASC(text)Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged. Learn more. 
TextCHARCHAR(table_number) Converts a number into a character according to the current Unicode table. Learn more
TextCLEANCLEAN(text) Returns the text with the non-printable ASCII characters removed. Learn more
TextCODECODE(string) Returns the numerical Unicode map value of the first character in the string provided. Learn more
TextCONCATENATECONCATENATE(string1, [string2, ...]) Appends strings to one another. Learn more
TextDOLLARDOLLAR(number, [number_of_places]) Formats a number into the locale-specific currency format. Learn more
TextEXACTEXACT(string1, string2) Tests whether two strings are identical. Learn more
TextFINDFIND(search_for, text_to_search, [starting_at]) Returns the position at which a string is first found within text. Learn more
TextFINDBFINDB(search_for, text_to_search, [starting_at]) Returns the position at which a string is first found within text, counting each double character as 2. Learn more
TextFIXEDFIXED(number, [number_of_places], [suppress_separator]) Formats a number with a fixed number of decimal places. Learn more
TextJOINJOIN(delimiter, value_or_array1, [value_or_array2, …]) Concatenates the elements of one or more one-dimensional arrays using a specified delimiter. Learn more
TextLEFTLEFT(string, [number_of_characters]) Returns a substring from the beginning of a specified string. Learn more
TextLEFTBLEFTB(string, num_of_bytes)Returns the left portion of a string up to a certain number of bytes. Learn more.
TextLENLEN(text) Returns the length of a string. Learn more
TextLENBLENB(string)Returns the length of a string in bytes. Learn more.
TextLOWERLOWER(text) Converts a specified string to lowercase. Learn more
TextMIDMID(string, starting_at, extract_length) Returns a segment of a string. Learn more
TextMIDBMIDB(string)Returns a section of a string starting at a given character and up to a specified number of bytes. Learn more.
TextPROPERPROPER(text_to_capitalise) Capitalises each word in a specified string. Learn more
TextREGEXEXTRACTREGEXEXTRACT(text, regular_expression) Extracts matching substrings according to a regular expression. Learn more
TextREGEXMATCHREGEXMATCH(text, regular_expression) Whether a piece of text matches a regular expression. Learn more
TextREGEXREPLACEREGEXREPLACE(text, regular_expression, replacement) Replaces part of a text string with a different text string using regular expressions. Learn more
TextREPLACEREPLACE(text, position, length, new_text) Replaces part of a text string with a different text string. Learn more
TextREPLACEBREPLACEB(text, position, num_bytes, new_text)Replaces part of a text string, based on a number of bytes, with a different text string. Learn more.
TextREPTREPT(text_to_repeat, number_of_repetitions) Returns specified text repeated a number of times. Learn more
TextRIGHTRIGHT(string, [number_of_characters]) Returns a substring from the end of a specified string. Learn more
TextRIGHTBRIGHTB(string, num_of_bytes)Returns the right portion of a string up to a certain number of bytes. Learn more.
Text
TextSEARCHSEARCH(search_for, text_to_search, [starting_at]) Returns the position at which a string is first found within text. Learn more
TextSEARCHBSEARCHB(search_for, text_to_search, [starting_at]) Returns the position at which a string is first found within text, counting each double character as 2. Learn more
TextSPLITSPLIT(text, delimiter, [split_by_each], [remove_empty_text]) Divides text around a specified character or string and puts each fragment into a separate cell in the row. Learn more
TextSUBSTITUTESUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number]) Replaces existing text with new text in a string. Learn more
TextTT(value) Returns string arguments as text. Learn more
TextTEXTTEXT(number, format) Converts a number to text according to a specified format. Learn more
TextTEXTJOINTEXTJOIN(delimiter, ignore_empty, text1, [text2], …) Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts. Learn more.
TextTRIMTRIM(text) Removes leading and trailing spaces in a specified string. Learn more
TextUNICHARUNICHAR(number)Returns the Unicode character for a number. Learn more.
TextUNICODEUNICODE(text)Returns the decimal Unicode value of the first character of the text. Learn more.
TextUPPERUPPER(text) Converts a specified string to upper case. Learn more
TextVALUEVALUE(text) Converts a string in any of the date, time or number formats that Google Sheets understands into a number. Learn more
DatabaseDAVERAGEDAVERAGE(database, field, criteria) Returns the average of a set of values selected from a database table-like array or range using an SQL-like query. Learn more
DatabaseDCOUNTDCOUNT(database, field, criteria) Counts numerical values selected from a database table-like array or range using an SQL-like query. Learn more
DatabaseDCOUNTADCOUNTA(database, field, criteria) Counts values, including text, selected from a database table-like array or range using a SQL-like query. Learn more
DatabaseDGETDGET(database, field, criteria) Returns a single value from a database table-like array or range using an SQL-like query. Learn more
DatabaseDMAXDMAX(database, field, criteria) Returns the maximum value selected from a database table-like array or range using an SQL-like query. Learn more
DatabaseDMINDMIN(database, field, criteria) Returns the minimum value selected from a database table-like array or range using an SQL-like query. Learn more
DatabaseDPRODUCTDPRODUCT(database, field, criteria) Returns the product of values selected from a database table-like array or range using an SQL-like query. Learn more
DatabaseDSTDEVDSTDEV(database, field, criteria) Returns the standard deviation of a population sample selected from a database table-like array or range using an SQL-like query. Learn more
Database
DatabaseDSUMDSUM(database, field, criteria) Returns the sum of values selected from a database table-like array or range using an SQL-like query. Learn more
Database
DatabaseDVARPDVARP(database, field, criteria) Returns the variance of an entire population selected from a database table-like array or range using an SQL-like query. Learn more
ParserCONVERTCONVERT(value, start_unit, end_unit) Converts a numerical value to a different unit of measure. Learn more
ParserTO_DATETO_DATE(value) Converts a provided number into a date. Learn more
ParserTO_DOLLARSTO_DOLLARS(value) Converts a provided number to a dollar value. Learn more
ParserTO_PERCENTTO_PERCENT(value) Converts a provided number to a percentage. Learn more
ParserTO_PURE_NUMBERTO_PURE_NUMBER(value) Converts a provided date/time, percentage, currency or other formatted numerical value to a pure number without formatting. Learn more
ParserTO_TEXTTO_TEXT(value) Converts a provided numerical value to a text value. Learn more
ArrayARRAY_CONSTRAINARRAY_CONSTRAIN(input_range, num_rows, num_cols) Constrains an array result to a specified size. Learn more
ArrayFREQUENCYFREQUENCY(data, classes) Calculates the frequency distribution of a one-column array into specified classes. Learn more
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
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
Array
Array
Array
ArrayMMULTMMULT(matrix1, matrix2) Calculates the matrix product of two matrices specified as arrays or ranges. Learn more
ArraySUMPRODUCTSUMPRODUCT(array1, [array2, ...]) Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more
ArraySUMX2MY2SUMX2MY2(array_x, array_y) Calculates the sum of the differences of the squares of values in two arrays. Learn more
Array
ArraySUMXMY2SUMXMY2(array_x, array_y) Calculates the sum of the squares of differences of values in two arrays. Learn more
ArrayTRANSPOSETRANSPOSE(array_or_range) Transposes the rows and columns of an array or range of cells. Learn more
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
WebENCODEURLENCODEURL(text)Encodes a string of text for the purpose of using it in a URL query. Learn more.
Web
Web
Web
Web
Web
WebIMPORTXMLIMPORTXML(url, xpath_query) Imports data from any of various structured data types including XML, HTML, CSV, TSV and RSS and Atom XML feeds. Learn more
WebISURLISURL(value) Checks whether a value is a valid URL. Find out more