Google spreadsheets function list

Google Spreadsheets supports cell formulas typically found in most desktop spreadsheet packages. These formulas 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 made of alphabetic characters that aren't referring to cells or columns.

The new Google Sheets includes a number of additional functions. These functions include ARRAY_CONSTRAIN, ARRAY_LITERAL, ARRAY_ROW, CELL, CLEAN, DELTA, ISEMAIL, ISURL, TIMEVALUE, LOOKUP, PERCENTRANK.EXC, PERCENTRANK.INC, RANK.AVG, RANK.EQ, TYPE, WEEKNUM, SUMIFS, COUNTIFS, AVERAGEIF, AVERAGEIFS, NETWORKDAYS.INTL, WORKDAY.INTL, SEARCHB, FINDB, and TDIST

TypeNameSyntaxDescription
DateDATEDATE(year, month, day) Converts a provided year, month, and day into a date. Learn more
DateDATEVALUEDATEVALUE(date_string) Converts a provided date string in a known format to a date value. Learn more
DateDAYDAY(date) Returns the day of the month that a specific date falls on, in numeric format. 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) Returns a date 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 numeric format. Learn more
DateMINUTEMINUTE(time) Returns the minute component of a specific time, in numeric format. Learn more
DateMONTHMONTH(date) Returns the month of the year a specific date falls in, in numeric 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. Only available in the new Google Sheets. 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 numeric 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 the time represents. Only available in the new Google Sheets. Learn more
DateTODAYTODAY() Returns the current date as a date value. Learn more
DateWEEKDAYWEEKDAY(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. Only available in the new Google Sheets. Learn more
DateWORKDAYWORKDAY(start_date, num_days, holidays) Calculates the number of working days from a specified start date. Learn more
DateWORKDAY.INTLWORKDAY.INTL(start_date, num_days, [weekend], [holidays]) Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Only available in the new Google Sheets. 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
EngineeringBIN2DECBIN2DEC(signed_binary_number) Converts a signed binary number to decimal format. Learn more
EngineeringBIN2HEXBIN2HEX(signed_binary_number, significant_digits) Converts a signed binary number to signed hexadecimal format. Learn more
EngineeringBIN2OCTBIN2OCT(signed_binary_number, significant_digits) Converts a signed binary number to signed octal format. Learn more
EngineeringDEC2BINDEC2BIN(decimal_number, significant_digits) Converts a decimal number to signed binary format. Learn more
EngineeringDEC2HEXDEC2HEX(decimal_number, significant_digits) Converts a decimal number to signed hexadecimal format. Learn more
EngineeringDEC2OCTDEC2OCT(decimal_number, significant_digits) Converts a decimal number to signed octal format. Learn more
EngineeringDELTADELTA(number1, [number2]) Compare two numeric values, returning 1 if they're equal. Only available in the new Google Sheets. Learn more
EngineeringHEX2BINHEX2BIN(signed_hexadecimal_number, significant_digits) Converts a signed hexadecimal number to signed binary format. Learn more
EngineeringHEX2DECHEX2DEC(signed_hexadecimal_number) Converts a signed hexadecimal number to decimal format. Learn more
EngineeringHEX2OCTHEX2OCT(signed_hexadecimal_number, significant_digits) Converts a signed hexadecimal number to signed octal format. Learn more
EngineeringOCT2BINOCT2BIN(signed_octal_number, significant_digits) Converts a signed octal number to signed binary format. Learn more
EngineeringOCT2DECOCT2DEC(signed_octal_number) Converts a signed octal number to decimal format. Learn more
EngineeringOCT2HEXOCT2HEX(signed_octal_number, significant_digits) Converts a signed octal number to signed hexadecimal format. Learn more
FilterFILTERFILTER(range, condition1, condition2) Returns a filtered version of the source range, returning only rows or columns which 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
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
FinancialACCRINTACCRINT(issue, first_payment, settlement, rate, redemption, frequency, day_count_convention) Calculates the accrued interest of a security that has periodic payments. Learn more
FinancialACCRINTMACCRINTM(issue, maturity, rate, redemption, day_count_convention) Calculates the accrued interest of a security that pays interest at maturity. Learn more
FinancialCOUPDAYBSCOUPDAYBS(settlement, maturity, frequency, day_count_convention) Calculates the number of days from the first coupon, or interest payment, until settlement. Learn more
FinancialCOUPDAYSCOUPDAYS(settlement, maturity, frequency, day_count_convention) Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn more
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
FinancialCOUPNCDCOUPNCD(settlement, maturity, frequency, day_count_convention) Calculates next coupon, or interest payment, date after the settlement date. Learn more
FinancialCOUPNUMCOUPNUM(settlement, maturity, frequency, day_count_convention) Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. Learn more
FinancialCOUPPCDCOUPPCD(settlement, maturity, frequency, day_count_convention) Calculates last coupon, or interest payment, date before the settlement date. Learn more
FinancialCUMIPMTCUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning) Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
FinancialCUMPRINCCUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning) Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
FinancialDBDB(cost, salvage, life, period, month) Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method. Learn more
FinancialDDBDDB(cost, salvage, life, period, factor) Calculates the depreciation of an asset for a specified period using the double-declining balance method. Learn more
FinancialDISCDISC(settlement, maturity, price, redemption, day_count_convention) Calculates the discount rate of a security based on price. Learn more
FinancialDOLLARDEDOLLARDE(fractional_price, unit) Converts a price quotation given as a decimal fraction into a decimal value. Learn more
FinancialDOLLARFRDOLLARFR(decimal_price, unit) Converts a price quotation given as a decimal value into a decimal fraction. Learn more
FinancialDURATIONDURATION(rate, present_value, future_value) 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
FinancialEFFECTEFFECT(nominal_rate, periods_per_year) Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year. Learn more
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
FinancialFVSCHEDULEFVSCHEDULE(principal, rate_schedule) Calculates the future value of some principal based on a specified series of potentially varying interest rates. Learn more
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
FinancialMDURATIONMDURATION(settlement, maturity, rate, yield, frequency, day_count_convention) Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more
FinancialMIRRMIRR(cashflow_amounts, financing_rate, reinvestment_return_rate) Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income. Learn more
FinancialNOMINALNOMINAL(effective_rate, periods_per_year) Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year. Learn more
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
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
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
FinancialPRICEDISCPRICEDISC(settlement, maturity, discount, redemption, day_count_convention) Calculates the price of a discount (non-interest-bearing) security, based on expected yield. Learn more
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
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
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
FinancialSLNSLN(cost, salvage, life) Calculates the depreciation of an asset for one period using the straight-line method. Learn more
FinancialSYDSYD(cost, salvage, life, period) Calculates the depreciation of an asset for a specified period using the sum of years digits method. Learn more
FinancialTBILLEQTBILLEQ(settlement, maturity, discount) Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more
FinancialTBILLPRICETBILLPRICE(settlement, maturity, discount) Calculates the price of a US Treasury Bill based on discount rate. Learn more
FinancialTBILLYIELDTBILLYIELD(settlement, maturity, price) Calculates the yield of a US Treasury Bill based on price. 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
FinancialXNPVXNPV(discount, cashflow_amounts, cashflow_dates) Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate. Learn more
FinancialYIELDYIELD(settlement, maturity, rate, price, redemption, frequency, day_count_convention) Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price. Learn more
FinancialYIELDDISCYIELDDISC(settlement, maturity, price, redemption, day_count_convention) Calculates the annual yield of a discount (non-interest-bearing) security, based on price. Learn more
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
GoogleCONTINUECONTINUE(source_cell, row, column) Returns a specified cell from an array formula result. Learn more
GoogleDETECTLANGUAGEDETECTLANGUAGE(text_or_range) Identifies the language used in text within the specified range. Learn more
GoogleGOOGLECLOCKGOOGLECLOCK() Returns the current system date and time and updates automatically once per minute. Learn more
GoogleGOOGLEFINANCEGOOGLEFINANCE(ticker, attribute, start_date, end_date|num_days, interval) Fetches current or historical securities information from Google Finance. Learn more
GoogleGOOGLETOURNAMENTGOOGLETOURNAMENT(year, league, round, game_slot, statistic, team) Returns data for March Madness (NCAA Division I Basketball Championship) games. Learn more
GoogleGOOGLETRANSLATEGOOGLETRANSLATE(text, source_language, target_language) Translates text from one language into another/ Learn more
GoogleIMAGEIMAGE(url, mode) Inserts an image into a cell. Learn more
GoogleIMPORTDATAIMPORTDATA(url) Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format. Learn more
GoogleIMPORTFEEDIMPORTFEED(url, query, headers, num_items) Imports a RSS or ATOM feed. Learn more
GoogleIMPORTHTMLIMPORTHTML(url, query, index) Imports data from a table or list within an HTML page. Learn more
GoogleIMPORTRANGEIMPORTRANGE(spreadsheet_key, range_string) Imports a range of cells from a specified spreadsheet. Learn more
GoogleIMPORTXMLIMPORTXML(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
GoogleQUERYQUERY(data, query, headers) Runs a Google Visualization API Query Language query across data. Learn more
GoogleSPARKLINESPARKLINE(data, options) Creates a miniature chart contained within a single cell. Learn more
GoogleGoogleLookupGoogleLookup(entity, attribute)

The GoogleLookup function was retired in November 2011. This function relied on technology from Google Squared, a Google Lab that has been shut down. As a result, the GoogleLookup function can no longer be used, and cells that contain GoogleLookup functions will return an error.

InfoERROR.TYPEERROR.TYPE(reference) Returns a number corresponding to the error value in a different cell. Learn more
InfoISBLANKISBLANK(value) Checks whether the referenced cell is empty. Learn more
InfoISEMAILISEMAIL(value) Checks whether a value is a valid email address. Only available in the new Google Sheets. Learn more
InfoISERRISERR(value) Checks whether a value is an error other than `#N/A`. Learn more
InfoISERRORISERROR(value) Checks whether a value is an error. Learn more
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
InfoISNONTEXTISNONTEXT(value) Checks whether a value is non-textual. Learn more
InfoISNUMBERISNUMBER(value) Checks whether a value is a number. Learn more
InfoISREFISREF(value) Checks whether a value is a valid cell reference. Learn more
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. Only available in the new Google Sheets. Learn more
InfoCELLCELL(info_type, reference) Returns the requested information about the specified cell. Only available in the new Google Sheets. Learn more
InfoISURLISURL(value) Checks whether a value is a valid URL. Only available in the new Google Sheets. 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
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
LogicalTRUETRUE() Returns the logical value `TRUE`. 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
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
LookupHYPERLINKHYPERLINK(url, link_label) Creates a hyperlink inside a cell. 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) 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. Only available in the new Google Sheets. 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 shifted 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
MathABSABS(value) Returns the absolute value of a number. Learn more
MathACOSACOS(value) Returns the inverse cosine of a value, in radians. Learn more
MathACOSHACOSH(value) Returns the inverse hyperbolic cosine of a number. Learn more
MathASINASIN(value) Returns the inverse sine of a value, in radians. Learn more
MathASINHASINH(value) Returns the inverse hyperbolic sine of a number. Learn more
MathATANATAN(value) Returns the inverse tangent of a value, in radians. Learn more
MathATAN2ATAN2(x, y) Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians. Learn more
MathATANHATANH(value) Returns the inverse hyperbolic tangent of a number. Learn more
MathCEILINGCEILING(value, factor) Rounds a number up to the nearest integer multiple of specified significance. Learn more
MathCOMBINCOMBIN(n, k) Returns the number of ways to choose some number of objects from a pool of a given size of objects. Learn more
MathCOSCOS(angle) Returns the cosine of an angle provided in radians. Learn more
MathCOSHCOSH(value) Returns the hyperbolic cosine of any real number. Learn more
MathCOUNTBLANKCOUNTBLANK(range) Returns the number of empty cells in a given range. Learn more
MathCOUNTIFCOUNTIF(range, criterion) Returns a conditional count across a range. Learn more
MathCOUNTIFSCOUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...]) Returns the count of a range depending on multiple criteria. Only available in the new Google Sheets. Learn more
MathCOUNTUNIQUECOUNTUNIQUE(value1, value2) Counts the number of unique values in a list of specified values and ranges. Learn more
MathDEGREESDEGREES(angle) Converts an angle value in radians to degrees. Learn more
MathERFCERFC(z) Returns the complementary Gauss error function of a value. Learn more
MathEVENEVEN(value) Rounds a number up to the nearest even integer. Learn more
MathEXPEXP(exponent) Returns Euler's number, e (~2.718) raised to a power. Learn more
MathFACTFACT(value) Returns the factorial of a number. Learn more
MathFACTDOUBLEFACTDOUBLE(value) Returns the "double factorial" of a number. Learn more
MathFLOORFLOOR(value, factor) Rounds a number down to the nearest integer multiple of specified significance. Learn more
MathGAMMALNGAMMALN(value) Returns the the logarithm of a specified Gamma function, base e (Euler's number). Learn more
MathGCDGCD(value1, value2) Returns the greatest common divisor of one or more integers. Learn more
MathINTINT(value) Rounds a number down to the nearest integer that is less than or equal to it. Learn more
MathISEVENISEVEN(value) Checks whether the provided value is even. Learn more
MathISODDISODD(value) Checks whether the provided value is odd. Learn more
MathLCMLCM(value1, value2) Returns the least common multiple of one or more integers. Learn more
MathLNLN(value) Returns the the logarithm of a number, base e (Euler's number). Learn more
MathLOGLOG(value, base) Returns the the logarithm of a number given a base. Learn more
MathLOG10LOG10(value) Returns the the logarithm of a number, base 10. Learn more
MathMODMOD(dividend, divisor) Returns the result of the modulo operator, the remainder after a division operation. Learn more
MathMROUNDMROUND(value, factor) Rounds one number to the nearest integer multiple of another. Learn more
MathMULTINOMIALMULTINOMIAL(value1, value2) Returns the factorial of the sum of values divided by the product of the values' factorials. Learn more
MathODDODD(value) Rounds a number up to the nearest odd integer. Learn more
MathPIPI() Returns the value of Pi to 14 decimal places. Learn more
MathPOWERPOWER(base, exponent) Returns a number raised to a power. Learn more
MathPRODUCTPRODUCT(factor1, factor2) Returns the result of multiplying a series of numbers together. Learn more
MathQUOTIENTQUOTIENT(dividend, divisor) Returns one number divided by another. Learn more
MathRADIANSRADIANS(angle) Converts an angle value in degrees to radians. Learn more
MathRANDRAND() Returns a random number between 0 inclusive and 1 exclusive. Learn more
MathRANDBETWEENRANDBETWEEN(low, high) Returns a uniformly random integer between two values, inclusive. Learn more
MathROUNDROUND(value, places) Rounds a number to a certain number of decimal places according to standard rules. Learn more
MathROUNDDOWNROUNDDOWN(value, places) Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. Learn more
MathROUNDUPROUNDUP(value, places) Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more
MathSERIESSUMSERIESSUM(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
MathSIGNSIGN(value) Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero. Learn more
MathSINSIN(angle) Returns the sine of an angle provided in radians. Learn more
MathSINHSINH(value) Returns the hyperbolic sine of any real number. Learn more
MathSQRTSQRT(value) Returns the positive square root of a positive number. Learn more
MathSQRTPISQRTPI(value) Returns the positive square root of the product of Pi and the given positive number. Learn more
MathSUBTOTALSUBTOTAL(function_code, range1, range2) Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more
MathSUMSUM(value1, value2) Returns the sum of a series of numbers and/or cells. Learn more
MathSUMIFSUMIF(range, criterion, sum_range) Returns a conditional sum across a range. Learn more
MathSUMIFSSUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) Returns the sum of a range depending on multiple criteria. Only available in the new Google Sheets. Learn more
MathSUMSQSUMSQ(value1, value2) Returns the sum of the squares of a series of numbers and/or cells. Learn more
MathTANTAN(angle) Returns the tangent of an angle provided in radians. Learn more
MathTANHTANH(value) Returns the hyperbolic tangent of any real number. Learn more
MathTRUNCTRUNC(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 magnitudes of deviations of data from a dataset's mean. Learn more
StatisticalAVERAGEAVERAGE(value1, value2) Returns the numerical average value in a dataset, ignoring text. Learn more
StatisticalAVERAGEAAVERAGEA(value1, value2) Returns the numerical average value in a dataset. Learn more
StatisticalAVERAGEIFAVERAGEIF(criteria_range, criterion, [average_range]) Returns the average of a range depending on criteria. Only available in the new Google Sheets. Learn more
StatisticalAVERAGEIFSAVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) Returns the average of a range depending on multiple criteria. Only available in the new Google Sheets. Learn more
StatisticalBINOMDISTBINOMDIST(num_successes, num_trials, prob_success, cumulative) Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws. Learn more
StatisticalCONFIDENCECONFIDENCE(alpha, standard_deviation, pop_size) Calculates the width of half the confidence interval for a normal distribution. Learn more
StatisticalCORRELCORREL(data_y, data_x) Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
StatisticalCOUNTCOUNT(value1, value2) Returns the a count of the number of numeric values in a dataset. Learn more
StatisticalCOUNTACOUNTA(value1, value2) Returns the a count of the number of values in a dataset. Learn more
StatisticalCOVARCOVAR(data_y, data_x) Calculates the covariance of a dataset. Learn more
StatisticalCRITBINOMCRITBINOM(num_trials, prob_success, target_prob) Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. Learn more
StatisticalDEVSQDEVSQ(value1, value2) Calculates the sum of squares of deviations based on a sample. Learn more
StatisticalEXPONDISTEXPONDIST(x, lambda, cumulative) Returns the value of the exponential distribution function with a specified lambda at a specified value. Learn more
StatisticalFISHERFISHER(value) Returns the Fisher transformation of a specified value. Learn more
StatisticalFISHERINVFISHERINV(value) Returns the inverse Fisher transformation of a specified value. Learn more
StatisticalFORECASTFORECAST(x, data_y, data_x) Calculates the expected y-value for a specified x based on a linear regression of a dataset. Learn more
StatisticalGEOMEANGEOMEAN(value1, value2) Calculates the geometric mean of a dataset. Learn more
StatisticalHARMEANHARMEAN(value1, value2) Calculates the harmonic mean of a dataset. Learn more
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 replacement of draws. Learn more
StatisticalINTERCEPTINTERCEPT(data_y, data_x) Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0). Learn more
StatisticalKURTKURT(value1, value2) Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset. Learn more
StatisticalLARGELARGE(data, n) Returns the nth largest element from a data set, where n is user-defined. Learn more
StatisticalLOGINVLOGINV(x, mean, standard_deviation) Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more
StatisticalLOGNORMDISTLOGNORMDIST(x, mean, standard_deviation) Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more
StatisticalMAXMAX(value1, value2) Returns the maximum value in a numeric dataset. Learn more
StatisticalMAXAMAXA(value1, value2) Returns the maximum numeric value in a dataset. Learn more
StatisticalMEDIANMEDIAN(value1, value2) Returns the median value in a numeric dataset. Learn more
StatisticalMINMIN(value1, value2) Returns the minimum value in a numeric dataset. Learn more
StatisticalMINAMINA(value1, value2) Returns the minimum numeric value in a dataset. Learn more
StatisticalMODEMODE(value1, value2) Returns the most commonly occurring value in a dataset. Learn more
StatisticalNEGBINOMDISTNEGBINOMDIST(num_failures, num_successes, prob_success) Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials. Learn more
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
StatisticalNORMINVNORMINV(x, mean, standard_deviation) Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation. Learn more
StatisticalNORMSDISTNORMSDIST(x) Returns the value of the standard normal cumulative distribution function for a specified value. Learn more
StatisticalNORMSINVNORMSINV(x) Returns the value of the inverse standard normal distribution function for a specified value. Learn more
StatisticalPEARSONPEARSON(data_y, data_x) Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
StatisticalPERCENTILEPERCENTILE(data, percentile) Returns the value at a given percentile of a dataset. Learn more
StatisticalPERCENTRANKPERCENTRANK(data, value, [significant_digits]) Returns the percentage rank (percentile) of a specified value in a dataset. 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 dataset. Only available in the new Google Sheets. 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 dataset. Only available in the new Google Sheets. Learn more
StatisticalPERMUTPERMUT(n, k) Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order. Learn more
StatisticalPOISSONPOISSON(x, mean, cumulative) Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean. Learn more
StatisticalPROBPROB(data, probabilities, low_limit, high_limit) Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits. Learn more
StatisticalQUARTILEQUARTILE(data, quartile_number) Returns a value nearest to a specified quartile of a dataset. Learn more
StatisticalRANKRANK(value, data, is_ascending) Returns the rank of a specified value in a dataset. Learn more
StatisticalRANK.AVGRANK.AVG(value, data, [is_ascending]) Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned. Only available in the new Google Sheets. Learn more
StatisticalRANK.EQRANK.EQ(value, data, [is_ascending]) Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned. Only available in the new Google Sheets. Learn more
StatisticalRSQRSQ(data_y, data_x) Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset. Learn more
StatisticalSKEWSKEW(value1, value2) Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean. Learn more
StatisticalSLOPESLOPE(data_y, data_x) Calculates the slope of the line resulting from linear regression of a dataset. Learn more
StatisticalSMALLSMALL(data, n) Returns the nth smallest element from a data set, where n is user-defined. Learn more
StatisticalSTANDARDIZESTANDARDIZE(value, mean, standard_deviation) Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution. Learn more
StatisticalSTDEVSTDEV(value1, value2) Calculates an estimate of standard deviation based on a sample. Learn more
StatisticalSTDEVASTDEVA(value1, value2) Calculates an estimate of standard deviation based on a sample, setting text to the value `0`. Learn more
StatisticalSTDEVPSTDEVP(value1, value2) Calculates an estimate of standard deviation based on an entire population. Learn more
StatisticalSTDEVPASTDEVPA(value1, value2) Calculates an estimate of standard deviation based on an entire population, setting text to the value `0`. Learn more
StatisticalSTEYXSTEYX(data_y, data_x) Calculates the standard error of the predicted y-value for each x in the regression of a dataset. Learn more
StatisticalTDISTTDIST(x, degrees_freedom, tails) Calculates the probability for Student's t-distribution with a given input (x). Only available in the new Google Sheets. Learn more
StatisticalTRIMMEANTRIMMEAN(data, exclude_proportion) Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset. Learn more
StatisticalVARVAR(value1, value2) Calculates an estimate of variance based on a sample. Learn more
StatisticalVARAVARA(value1, value2) Calculates an estimate of variance based on a sample, setting text to the value `0`. Learn more
StatisticalVARPVARP(value1, value2) Calculates an estimate of variance based on an entire population. Learn more
StatisticalVARPAVARPA(value1, value2) Calculates an estimate of variance based on an entire population, setting text to the value `0`. Learn more
StatisticalWEIBULLWEIBULL(x, shape, scale, cumulative) Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale. Learn more
StatisticalZTESTZTEST(data, value, standard_deviation) Returns the two-tailed P-value of a Z-test with standard distribution. Learn more
TextARABICARABIC(roman_numeral) Computes the value of a Roman numeral. Learn more
TextCHARCHAR(table_number) Convert 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. Only available in the new Google Sheets. Learn more
TextCODECODE(string) Returns the numeric 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. Only available in the new Google Sheets. 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
TextLENLEN(text) Returns the length of a string. 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
TextPROPERPROPER(text_to_capitalize) Capitalizes 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
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
TextROMANROMAN(number, rule_relaxation) Formats a number in Roman numerals. Learn more
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. Only available in the new Google Sheets. Learn more
TextSPLITSPLIT(text, delimiter, split_by_each) 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 into text according to a specified format. Learn more
TextTRIMTRIM(text) Removes leading and trailing spaces in a specified string. Learn more
TextUPPERUPPER(text) Converts a specified string to uppercase. 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 a SQL-like query. Learn more
DatabaseDCOUNTDCOUNT(database, field, criteria) Counts numeric values selected from a database table-like array or range using a 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 a SQL-like query. Learn more
DatabaseDMAXDMAX(database, field, criteria) Returns the maximum value selected from a database table-like array or range using a SQL-like query. Learn more
DatabaseDMINDMIN(database, field, criteria) Returns the minimum value selected from a database table-like array or range using a SQL-like query. Learn more
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
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
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
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
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
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
ParserTO_DATETO_DATE(value) Converts a provided number to 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 numeric value to a pure number without formatting. Learn more
ParserTO_TEXTTO_TEXT(value) Converts a provided numeric value to a text value. Learn more
ArrayARRAY_CONSTRAINARRAY_CONSTRAIN(input_range, num_rows, num_cols) Constrains an array result to a specified size. Only available in the new Google Sheets. Learn more
ArrayARRAY_LITERALARRAY_LITERAL(input_arrays, ...) Returns an array with M rows and N columns from M 1xN arrays. Only available in the new Google Sheets. Learn more
ArrayARRAY_ROWARRAY_ROW(elements, ...) Returns an array made up of the elements passed in as arguments. Only available in the new Google Sheets. Learn more
ArrayEXPANDEXPAND(array_formula) Forces the automatic expansion of array formula output as the output size grows. 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, b, verbose) Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method. Learn more
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
ArrayMDETERMMDETERM(square_matrix) Returns the matrix determinant of a square matrix specified as an array or range. Learn more
ArrayMINVERSEMINVERSE(square_matrix) Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more
ArrayMMULTMMULT(matrix1, matrix2) Calculates the matrix product of two matrices specified as arrays or ranges. Learn more
ArrayNOEXPANDNOEXPAND(array_formula) Prevents the automatic expansion of array formula output as the output size grows. 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
ArraySUMX2PY2SUMX2PY2(array_x, array_y) Calculates the sum of the sums of the squares of values in two arrays. Learn more
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
Try your keywords on Google Web Search.