DateDATEDATE(year, month, day) Converts a provided year, month, and day into a date. Learn moreDateDATEDIFDATEDIF(start_date, end_date, unit) Calculates the number of days, months, or years between two dates. Learn moreDateDATEVALUEDATEVALUE(date_string) Converts a provided date string in a known format to a date value. Learn moreDateDAYDAY(date) Returns the day of the month that a specific date falls on, in numeric format. Learn moreDateDAYSDAYS(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 moreDateEDATEEDATE(start_date, months) Returns a date a specified number of months before or after another date. Learn moreDateEOMONTHEOMONTH(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 moreDateEPOCHTODATEEPOCHTODATE(timestamp, [unit]) Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC. Learn moreDateHOURHOUR(time) Returns the hour component of a specific time, in numeric format. Learn moreDateISOWEEKNUMISOWEEKNUM(date)Returns the number of the ISO week of the year where the provided date falls. Learn more DateMINUTEMINUTE(time) Returns the minute component of a specific time, in numeric format. Learn moreDateMONTHMONTH(date) Returns the month of the year a specific date falls in, in numeric format. Learn moreDateNETWORKDAYSNETWORKDAYS(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 moreDateNOWNOW() Returns the current date and time as a date value. Learn moreDateSECONDSECOND(time) Returns the second component of a specific time, in numeric format. Learn moreDateTIMETIME(hour, minute, second) Converts a provided hour, minute, and second into a time. Learn moreDateTIMEVALUETIMEVALUE(time_string) Returns the fraction of a 24-hour day the time represents. Learn moreDateTODAYTODAY() Returns the current date as a date value. Learn moreDateWEEKDAYWEEKDAY(date, [type]) Returns a number representing the day of the week of the date provided. Learn moreDateWEEKNUMWEEKNUM(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 moreDateWORKDAY.INTLWORKDAY.INTL(start_date, num_days, [weekend], [holidays]) Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Learn more DateYEARYEAR(date) Returns the year specified by a given date. Learn moreDateYEARFRACYEARFRAC(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 moreEngineeringBIN2DECBIN2DEC(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 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 2 numbers. Learn more. EngineeringCOMPLEXCOMPLEX(real_part, imaginary_part, [suffix])Creates a complex number given real and imaginary coefficients. Learn moreEngineeringDEC2BINDEC2BIN(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. 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. 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 moreEngineeringHEX2OCTHEX2OCT(signed_hexadecimal_number, significant_digits)Converts a signed hexadecimal number to signed octal format. Learn more EngineeringIMABSIMABS(number)Returns absolute value of a complex number. Learn moreEngineeringIMAGINARYIMAGINARY(complex_number)Returns the imaginary coefficient of a complex number. Learn moreEngineeringIMARGUMENTIMARGUMENT(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 moreEngineeringIMCOSIMCOS(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 moreEngineeringIMEXPIMEXP(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 moreEngineeringIMREALIMREAL(complex_number)Returns the real coefficient of a complex number. Learn moreEngineeringIMSECIMSEC(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 moreEngineeringIMSUMIMSUM(value1, [value2, ...])Returns the sum of a series of complex numbers. Learn moreEngineeringIMTANIMTAN(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.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 moreFilterSORTSORT(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 moreFilterSORTNSORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)Returns the first n items in a data set after performing a sort. Learn moreFilterUNIQUEUNIQUE(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 moreFinancialACCRINTACCRINT(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 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. 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(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 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 moreFinancialFVSCHEDULEFVSCHEDULE(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 moreFinancialIRRIRR(cashflow_amounts, [rate_guess]) Calculates the internal rate of return on an investment based on a series of periodic cash flows. Learn moreFinancialISPMTISPMT(rate, period, number_of_periods, present_value)The ISPMT function calculates the interest paid during a particular period of an investment. 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 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 moreFinancialPPMTPPMT(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 moreFinancialPRICEPRICE(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 moreFinancialRATERATE(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 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.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 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 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 FinancialYIELDMATYIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])Calculates the annual yield of a security paying interest at maturity, based on price. Learn moreGoogleARRAYFORMULAARRAYFORMULA(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 moreGoogleDETECTLANGUAGEDETECTLANGUAGE(text_or_range) Identifies the language used in text within the specified range. Learn moreGoogleGOOGLEFINANCEGOOGLEFINANCE(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 moreGoogleIMAGEIMAGE(url, [mode], [height], [width]) Inserts an image into a cell. Learn moreGoogleQUERYQUERY(data, query, [headers]) Runs a Google Visualization API Query Language query across data. Learn moreGoogleSPARKLINESPARKLINE(data, [options]) Creates a miniature chart contained within a single cell. Learn moreInfoERROR.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 moreInfoISDATEISDATE(value)Returns whether a value is a date. Learn more. InfoISEMAILISEMAIL(value) Checks whether a value is a valid email address. 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 moreInfoISFORMULAISFORMULA(cell)Checks whether a formula is in the referenced cell. Learn more InfoISLOGICALISLOGICAL(value) Checks whether a value is `TRUE` or `FALSE`. Learn moreInfoISNAISNA(value) Checks whether a value is the error `#N/A`. Learn moreInfoISNONTEXTISNONTEXT(value)Checks whether a value is non-textual. Learn more InfoISNUMBERISNUMBER(value) Checks whether a value is a number. Learn moreInfoISREFISREF(value)Checks whether a value is a valid cell reference. Learn more InfoISTEXTISTEXT(value) Checks whether a value is text. Learn moreInfoNN(value) Returns the argument provided as a number. Learn moreInfoNANA() Returns the "value not available" error, `#N/A`. Learn moreInfoTYPETYPE(value) Returns a number associated with the type of data passed into the function. Learn moreInfoCELLCELL(info_type, reference) Returns the requested information about the specified cell. Learn moreLogicalANDAND(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 moreLogicalFALSEFALSE() Returns the logical value `FALSE`. Learn moreLogicalIFIF(logical_expression, value_if_true, value_if_false) Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Learn moreLogicalIFERRORIFERROR(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. LogicalLAMBDALAMBDA(name, formula_expression) Creates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares. Learn moreLogicalLETLET(name1, value_expression1, [name2, …], [value_expression2, …], formula_expression )Assigns name with the value_expression results and returns the result of the formula_expression. The formula_expression can use the names defined in the scope of the LET function. The value_expressions are evaluated only once in the LET function even if the following value_expressions or the formula_expression use them multiple times. Learn moreLogicalNOTNOT(logical_expression) Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. Learn moreLogicalOROR(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 moreLogicalSWITCHSWITCH(expression, case1, value1, [default or case2, value2], …) Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met. Learn more LogicalTRUETRUE() Returns the logical value `TRUE`. Learn moreLogicalXORXOR(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 moreLookupCHOOSECHOOSE(index, choice1, [choice2, ...]) Returns an element from a list of choices based on index. Learn moreLookupCOLUMNCOLUMN([cell_reference]) Returns the column number of a specified cell, with `A=1`. Learn moreLookupCOLUMNSCOLUMNS(range) Returns the number of columns in a specified array or range. Learn moreLookupFORMULATEXTFORMULATEXT(cell)Returns the formula as a string. Learn more.LookupGETPIVOTDATAGETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings. 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 moreLookupINDEXINDEX(reference, [row], [column]) Returns the content of a cell, specified by row and column offset. Learn moreLookupINDIRECTINDIRECT(cell_reference_as_string, [is_A1_notation]) Returns a cell reference specified by a string. Learn moreLookupLOOKUPLOOKUP(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 moreLookupMATCHMATCH(search_key, range, [search_type]) Returns the relative position of an item in a range that matches a specified value. Learn moreLookupOFFSETOFFSET(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 moreLookupROWROW([cell_reference]) Returns the row number of a specified cell. Learn moreLookupROWSROWS(range) Returns the number of rows in a specified array or range. Learn moreLookupVLOOKUPVLOOKUP(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 moreLookupXLOOKUPXLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode]) Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match. Learn moreMathABSABS(value) Returns the absolute value of a number. Learn moreMathACOSACOS(value)Returns the inverse cosine of a value, in radians. Learn more MathACOSHACOSH(value)Returns the inverse hyperbolic cosine of a number. Learn more MathACOTACOT(value)Returns the inverse cotangent of a value, in radians. Learn more.MathACOTHACOTH(value)Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive. 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 MathBASEBASE(value, base, [min_length])Converts a number into a text representation in another base, for example, base 2 for binary. Learn more.MathCEILINGCEILING(value, [factor]) Rounds a number up to the nearest integer multiple of specified significance. Learn moreMathCEILING.MATHCEILING.MATH(number, [significance], [mode])Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more. MathCEILING.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. 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 MathCOMBINACOMBINA(n, k)Returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways that choose the same object multiple times. 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 MathCOTCOT(angle)Cotangent of an angle provided in radians. Learn more.MathCOTHCOTH(value)Returns the hyperbolic cotangent of any real number. Learn more.MathCOUNTBLANKCOUNTBLANK(range) Returns the number of empty cells in a given range. Learn moreMathCOUNTIFCOUNTIF(range, criterion) Returns a conditional count across a range. Learn moreMathCOUNTIFSCOUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...]) Returns the count of a range depending on multiple criteria. Learn moreMathCOUNTUNIQUECOUNTUNIQUE(value1, [value2, ...]) Counts the number of unique values in a list of specified values and ranges. Learn moreMathCSCCSC(angle)Returns the cosecant of an angle provided in radians. Learn more.MathCSCHCSCH(value)The CSCH function returns the hyperbolic cosecant of any real number. Learn more.MathDECIMALDECIMAL(value, base)The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal). Learn more.MathDEGREESDEGREES(angle) Converts an angle value in radians to degrees. Learn moreMathERFCERFC(z)Returns the complementary Gauss error function of a value. Learn more MathERFC.PRECISEERFC.PRECISE(z) See ERFC 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 moreMathFLOOR.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. MathFLOOR.PRECISEFLOOR.PRECISE(number, [significance])The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance. Learn more.MathGAMMALNGAMMALN(value)Returns the the logarithm of a specified Gamma function, base e (Euler's number). Learn more MathGAMMALN.PRECISEGAMMALN.PRECISE(value) See GAMMALN MathGCDGCD(value1, value2)Returns the greatest common divisor of one or more integers. Learn more MathIMLNIMLN(complex_value)Returns the logarithm of a complex number, base e (Euler's number). Learn moreMathIMPOWERIMPOWER(complex_base, exponent)Returns a complex number raised to a power. Learn moreMathIMSQRTIMSQRT(complex_number)Computes the square root of a complex number. Learn moreMathINTINT(value) Rounds a number down to the nearest integer that is less than or equal to it. Learn moreMathISEVENISEVEN(value)Checks whether the provided value is even. Learn more MathISO.CEILINGISO.CEILING(number, [significance]) See CEILING.PRECISE 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 moreMathMROUNDMROUND(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 MathMUNITMUNIT(dimension)Returns a unit matrix of size dimension x dimension. 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 moreMathPRODUCTPRODUCT(factor1, [factor2, ...]) Returns the result of multiplying a series of numbers together. Learn moreMathQUOTIENTQUOTIENT(dividend, divisor) Returns one number divided by another. Learn moreMathRADIANSRADIANS(angle)Converts an angle value in degrees to radians. Learn more MathRANDRAND() Returns a random number between 0 inclusive and 1 exclusive. Learn moreMathRANDARRAYRANDARRAY(rows, columns)Generates an array of random numbers between 0 and 1. Learn more.MathRANDBETWEENRANDBETWEEN(low, high) Returns a uniformly random integer between two values, inclusive. Learn moreMathROUNDROUND(value, [places]) Rounds a number to a certain number of decimal places according to standard rules. Learn moreMathROUNDDOWNROUNDDOWN(value, [places]) Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. Learn moreMathROUNDUPROUNDUP(value, [places]) Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn moreMathSECSEC(angle)The SEC function returns the secant of an angle, measured in radians. Learn more.MathSECHSECH(value)The SECH function returns the hyperbolic secant of an angle. Learn more MathSEQUENCESEQUENCE(rows, columns, start, step)Returns an array of sequential numbers, such as 1, 2, 3, 4. Learn more.MathSERIESSUMSERIESSUM(x, n, m, a) Given parameters x, n, m, and a, returns the power series sum a₁xⁿ + a₂x^(n+m) + ... + a_ix^(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 moreMathSQRTPISQRTPI(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 moreMathSUMSUM(value1, [value2, ...]) Returns the sum of a series of numbers and/or cells. Learn moreMathSUMIFSUMIF(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. Learn moreMathSUMSQSUMSQ(value1, [value2, ...]) Returns the sum of the squares of a series of numbers and/or cells. Learn moreMathTANTAN(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 moreOperatorADDADD(value1, value2) Returns the sum of two numbers. Equivalent to the `+` operator. Learn moreOperatorCONCATCONCAT(value1, value2) Returns the concatenation of two values. Equivalent to the `&` operator. Learn moreOperatorDIVIDEDIVIDE(dividend, divisor) Returns one number divided by another. Equivalent to the `/` operator. Learn moreOperatorEQEQ(value1, value2) Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator. Learn moreOperatorGTGT(value1, value2) Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator. Learn moreOperatorGTEGTE(value1, value2) Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator. Learn moreOperatorISBETWEENISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive) Checks whether a provided number is between two other numbers either inclusively or exclusively. Learn moreOperatorLTLT(value1, value2) Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator. Learn moreOperatorLTELTE(value1, value2) Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator. Learn moreOperatorMINUSMINUS(value1, value2) Returns the difference of two numbers. Equivalent to the `-` operator. Learn moreOperatorMULTIPLYMULTIPLY(factor1, factor2) Returns the product of two numbers. Equivalent to the `*` operator. Learn moreOperatorNENE(value1, value2) Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator. Learn moreOperatorPOWPOW(base, exponent) Returns a number raised to a power. Learn moreOperatorUMINUSUMINUS(value) Returns a number with the sign reversed. Learn moreOperatorUNARY_PERCENTUNARY_PERCENT(percentage) Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`. Learn moreOperatorUNIQUEUNIQUE(range, by_column, exactly_once) 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 moreOperatorUPLUSUPLUS(value) Returns a specified number, unchanged. Learn moreStatisticalAVEDEVAVEDEV(value1, [value2, ...]) Calculates the average of the magnitudes of deviations of data from a dataset's mean. Learn moreStatisticalAVERAGEAVERAGE(value1, [value2, ...]) Returns the numerical average value in a dataset, ignoring text. Learn moreStatisticalAVERAGE.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 dataset. Learn moreStatisticalAVERAGEIFAVERAGEIF(criteria_range, criterion, [average_range]) Returns the average of a range depending on criteria. Learn moreStatisticalAVERAGEIFSAVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) Returns the average of a range depending on multiple criteria. Learn moreStatisticalBETA.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 CRITBINOMStatisticalBINOMDISTBINOMDIST(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 StatisticalCHIDISTCHIDIST(x, degrees_freedom) Calculates the right-tailed chi-squared distribution, often used in hypothesis testing. Learn more 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 StatisticalCHISQ.DIST.RTCHISQ.DIST.RT(x, degrees_freedom) Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing. Learn more StatisticalCHISQ.INVCHISQ.INV(probability, degrees_freedom) Calculates the inverse of the left-tailed chi-squared distribution. Learn more StatisticalCHISQ.INV.RTCHISQ.INV.RT(probability, degrees_freedom) Calculates the inverse of the right-tailed chi-squared distribution. Learn moreStatisticalCHISQ.TESTCHISQ.TEST(observed_range, expected_range)See CHITESTStatisticalCHITESTCHITEST(observed_range, expected_range) Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution. Learn more StatisticalCONFIDENCECONFIDENCE(alpha, standard_deviation, pop_size)See CONFIDENCE.NORMStatisticalCONFIDENCE.NORMCONFIDENCE.NORM(alpha, standard_deviation, pop_size)Calculates the width of half 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 dataset. Learn moreStatisticalCOUNTCOUNT(value1, [value2, ...]) Returns a count of the number of numeric values in a dataset. Learn moreStatisticalCOUNTACOUNTA(value1, [value2, ...]) Returns a count of the number of values in a dataset. Learn moreStatisticalCOVARCOVAR(data_y, data_x)Calculates the covariance of a dataset. Learn more StatisticalCOVARIANCE.PCOVARIANCE.P(data_y, data_x) See COVARStatisticalCOVARIANCE.SCOVARIANCE.S(data_y, data_x)Calculates the covariance of a dataset, where the dataset is a sample of the total population. 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 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.DISTStatisticalF.DISTF.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution. Learn more StatisticalF.DIST.RTF.DIST.RT(x, degrees_freedom1, degrees_freedom2)Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution. Learn more StatisticalF.INVF.INV(probability, degrees_freedom1, degrees_freedom2) Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn moreStatisticalF.INV.RTF.INV.RT(probability, degrees_freedom1, degrees_freedom2) Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more StatisticalF.TESTF.TEST(range1, range2) See FTEST.StatisticalFDISTFDIST(x, degrees_freedom1, degrees_freedom2)See F.DIST.RT.StatisticalFINVFINV(probability, degrees_freedom1, degrees_freedom2) See F.INV.RTStatisticalFISHERFISHER(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 moreStatisticalFORECAST.LINEARFORECAST.LINEAR(x, data_y, data_x) See FORECAST StatisticalFTESTFTEST(range1, range2) Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance. Learn more StatisticalGAMMAGAMMA(number)Returns the Gamma function evaluated at the specified value. Learn more.StatisticalGAMMA.DISTGAMMA.DIST(x, alpha, beta, cumulative) Calculates the gamma distribution, a two-parameter continuous probability distribution. Learn more 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.StatisticalGAMMADISTGAMMADIST(x, alpha, beta, cumulative)See GAMMA.DIST 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.StatisticalGEOMEANGEOMEAN(value1, value2)Calculates the geometric mean of a dataset. Learn more StatisticalHARMEANHARMEAN(value1, value2)Calculates the harmonic mean of a dataset. Learn more 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 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 moreStatisticalLOGINVLOGINV(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 StatisticalLOGNORM.DISTLOGNORM.DIST(x, mean, standard_deviation)See LOGNORMDISTStatisticalLOGNORM.INVLOGNORM.INV(x, mean, standard_deviation)See LOGINVStatisticalLOGNORMDISTLOGNORMDIST(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 StatisticalMARGINOFERRORMARGINOFERROR(range, confidence)Calculates the amount of random sampling error given a range of values and a confidence level. Learn moreStatisticalMAXMAX(value1, [value2, ...]) Returns the maximum value in a numeric dataset. Learn moreStatisticalMAXAMAXA(value1, value2)Returns the maximum numeric value in a dataset. Learn more 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 numeric dataset. Learn moreStatisticalMINMIN(value1, [value2, ...]) Returns the minimum value in a numeric dataset. Learn moreStatisticalMINAMINA(value1, value2)Returns the minimum numeric value in a dataset. Learn more StatisticalMINIFSMINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …) Returns the minimum value in a range of cells, filtered by a set of criteria. Learn more. StatisticalMODEMODE(value1, [value2, ...]) Returns the most commonly occurring value in a dataset. Learn moreStatisticalMODE.MULTMODE.MULT(value1, value2)Returns the most commonly occurring values in a dataset. Learn more.StatisticalMODE.SNGLMODE.SNGL(value1, [value2, ...]) See MODE StatisticalNEGBINOM.DISTNEGBINOM.DIST(num_failures, num_successes, prob_success) See NEGBINOMDIST 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 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 NORMSDISTStatisticalNORM.S.INVNORM.S.INV(x)See NORMSINVStatisticalNORMDISTNORMDIST(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 moreStatisticalNORMINVNORMINV(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 moreStatisticalPERCENTILE.EXCPERCENTILE.EXC(data, percentile)Returns the value at a given percentile of a dataset, exclusive of 0 and 1. Learn more.StatisticalPERCENTILE.INCPERCENTILE.INC(data, percentile)See PERCENTILEStatisticalPERCENTRANKPERCENTRANK(data, value, [significant_digits]) Returns the percentage rank (percentile) of a specified value in a dataset. Learn moreStatisticalPERCENTRANK.EXCPERCENTRANK.EXC(data, value, [significant_digits]) Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset. 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. 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.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 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.DISTStatisticalPOISSON.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. 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 moreStatisticalQUARTILE.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 QUARTILEStatisticalRANKRANK(value, data, [is_ascending]) Returns the rank of a specified value in a dataset. Learn moreStatisticalRANK.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. 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. 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 StatisticalSKEW.PSKEW.P(value1, value2)Calculates the skewness of a dataset that represents the entire population. Learn more.StatisticalSLOPESLOPE(data_y, data_x) Calculates the slope of the line resulting from linear regression of a dataset. Learn moreStatisticalSMALLSMALL(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 the standard deviation based on a sample. Learn moreStatisticalSTDEV.PSTDEV.P(value1, [value2, ...])See STDEVPStatisticalSTDEV.SSTDEV.S(value1, [value2, ...])See STDEVStatisticalSTDEVASTDEVA(value1, value2)Calculates the standard deviation based on a sample, setting text to the value `0`. Learn more StatisticalSTDEVPSTDEVP(value1, value2)Calculates the standard deviation based on an entire population. Learn more StatisticalSTDEVPASTDEVPA(value1, value2)Calculates the 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 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.StatisticalT.INVT.INV(probability, degrees_freedom)Calculates the negative inverse of the one-tailed TDIST function. Learn more StatisticalT.INV.2TT.INV.2T(probability, degrees_freedom)Calculates the inverse of the two-tailed TDIST function. Learn more StatisticalT.TESTT.TEST(range1, range2, tails, type)Returns the probability associated with 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 StatisticalTINVTINV(probability, degrees_freedom)See T.INV.2TStatisticalTRIMMEANTRIMMEAN(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 StatisticalTTESTTTEST(range1, range2, tails, type)See T.TEST.StatisticalVARVAR(value1, [value2, ...]) Calculates the variance based on a sample. Learn moreStatisticalVAR.PVAR.P(value1, [value2, ...])See VARPStatisticalVAR.SVAR.S(value1, [value2, ...])See VARStatisticalVARAVARA(value1, value2)Calculates an estimate of variance based on a sample, setting text to the value `0`. Learn more StatisticalVARPVARP(value1, value2)Calculates the variance based on an entire population. Learn more StatisticalVARPAVARPA(value1, value2,...)Calculates the 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 StatisticalWEIBULL.DISTWEIBULL.DIST(x, shape, scale, cumulative)See WEIBULLStatisticalZ.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.TextARABICARABIC(roman_numeral) Computes the value of a Roman numeral. Learn more 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) Convert a number into a character according to the current Unicode table. Learn moreTextCLEANCLEAN(text) Returns the text with the non-printable ASCII characters removed. 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 moreTextDOLLARDOLLAR(number, [number_of_places]) Formats a number into the locale-specific currency format. Learn moreTextEXACTEXACT(string1, string2) Tests whether two strings are identical. Learn moreTextFINDFIND(search_for, text_to_search, [starting_at]) Returns the position at which a string is first found within text. Learn moreTextFINDBFINDB(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 moreTextFIXEDFIXED(number, [number_of_places], [suppress_separator]) Formats a number with a fixed number of decimal places. Learn moreTextJOINJOIN(delimiter, value_or_array1, [value_or_array2, ...]) Concatenates the elements of one or more one-dimensional arrays using a specified delimiter. Learn moreTextLEFTLEFT(string, [number_of_characters]) Returns a substring from the beginning of a specified string. Learn moreTextLEFTBLEFTB(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 moreTextLENBLENB(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 moreTextMIDBMIDB(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_capitalize) Capitalizes each word in a specified string. Learn moreTextREGEXEXTRACTREGEXEXTRACT(text, regular_expression) Extracts matching substrings according to a regular expression. Learn moreTextREGEXMATCHREGEXMATCH(text, regular_expression) Whether a piece of text matches a regular expression. Learn moreTextREGEXREPLACEREGEXREPLACE(text, regular_expression, replacement) Replaces part of a text string with a different text string using regular expressions. Learn moreTextREPLACEREPLACE(text, position, length, new_text) Replaces part of a text string with a different text string. Learn moreTextREPLACEBREPLACEB(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 moreTextRIGHTRIGHT(string, [number_of_characters]) Returns a substring from the end of a specified string. Learn moreTextRIGHTBRIGHTB(string, num_of_bytes)Returns the right portion of a string up to a certain number of bytes. 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 moreTextSEARCHBSEARCHB(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 moreTextSUBSTITUTESUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number]) Replaces existing text with new text in a string. Learn moreTextTT(value) Returns string arguments as text. Learn moreTextTEXTTEXT(number, format) Converts a number into text according to a specified format. Learn moreTextTEXTJOINTEXTJOIN(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 moreTextUNICHARUNICHAR(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 uppercase. Learn moreTextVALUEVALUE(text) Converts a string in any of the date, time or number formats that Google Sheets understands into a number. Learn moreDatabaseDAVERAGEDAVERAGE(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 moreDatabaseDCOUNTDCOUNT(database, field, criteria) Counts numeric values selected from a database table-like array or range using a SQL-like query. Learn moreDatabaseDCOUNTADCOUNTA(database, field, criteria) Counts values, including text, selected from a database table-like array or range using a SQL-like query. Learn moreDatabaseDGETDGET(database, field, criteria) Returns a single value from a database table-like array or range using a SQL-like query. Learn moreDatabaseDMAXDMAX(database, field, criteria) Returns the maximum value selected from a database table-like array or range using a SQL-like query. Learn moreDatabaseDMINDMIN(database, field, criteria) Returns the minimum value selected from a database table-like array or range using a SQL-like query. Learn moreDatabaseDPRODUCTDPRODUCT(database, field, criteria) Returns the product of values selected from a database table-like array or range using a SQL-like query. Learn moreDatabaseDSTDEVDSTDEV(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 moreDatabaseDSTDEVPDSTDEVP(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 ParserCONVERTCONVERT(value, start_unit, end_unit) Converts a numeric value to a different unit of measure. Learn moreParserTO_DATETO_DATE(value) Converts a provided number to a date. Learn moreParserTO_DOLLARSTO_DOLLARS(value) Converts a provided number to a dollar value. Learn moreParserTO_PERCENTTO_PERCENT(value) Converts a provided number to a percentage. Learn moreParserTO_PURE_NUMBERTO_PURE_NUMBER(value) Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting. Learn moreParserTO_TEXTTO_TEXT(value) Converts a provided numeric value to a text value. Learn moreArrayARRAY_CONSTRAINARRAY_CONSTRAIN(input_range, num_rows, num_cols) Constrains an array result to a specified size. Learn moreArrayBYCOLBYCOL(array_or_range, LAMBDA)Groups an array by columns by application of a LAMBDA function to each column. Learn moreArrayBYROWBYROW(array_or_range, LAMBDA)Groups an array by rows by application of a LAMBDA function to each row. Learn moreArrayCHOOSECOLSCHOOSECOLS(array, col_num1, [col_num2]) Creates a new array from the selected columns in the existing range. Learn moreArrayCHOOSEROWSCHOOSEROWS(array, row_num1, [row_num2])Creates a new array from the selected rows in the existing range. Learn moreArrayFLATTENFLATTEN(range1,[range2,...])Flattens all the values from one or more ranges into a single column. Learn moreArrayFREQUENCYFREQUENCY(data, classes) Calculates the frequency distribution of a one-column array into specified classes. Learn moreArrayGROWTHGROWTH(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 moreArrayHSTACKHSTACK(range1; [range2, …])Appends ranges horizontally and in sequence to return a larger array. Learn moreArrayLINESTLINEST(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 moreArrayLOGESTLOGEST(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 ArrayMAKEARRAYMAKEARRAY(rows, columns, LAMBDA)Returns an array of specified dimensions with values calculated by application of a LAMBDA function. Learn moreArrayMAPMAP(array1, [array2, ...], LAMBDA) Maps each value in the given arrays to a new value by application of a LAMBDA function to each value. Learn moreArrayMDETERMMDETERM(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 moreArrayREDUCEREDUCE(initial_value, array_or_range, LAMBDA)Reduces an array to an accumulated result by application of a LAMBDA function to each value. Learn moreArraySCANSCAN(initial_value, array_or_range, LAMBDA)Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step. Learn moreArraySUMPRODUCTSUMPRODUCT(array1, [array2, ...]) Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn moreArraySUMX2MY2SUMX2MY2(array_x, array_y) Calculates the sum of the differences of the squares of values in two arrays. Learn moreArraySUMX2PY2SUMX2PY2(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 moreArrayTOCOLTOCOL(array_or_range, [ignore], [scan_by_column])Transforms an array or range of cells into a single column. Learn moreArrayTOROWTOROW(array_or_range, [ignore], [scan_by_column])Transforms an array or range of cells into a single row. Learn moreArrayTRANSPOSETRANSPOSE(array_or_range) Transposes the rows and columns of an array or range of cells. Learn moreArrayTRENDTREND(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 moreArrayVSTACKVSTACK(range1; [range2, …])Appends ranges vertically and in sequence to return a larger array. Learn moreArrayWRAPCOLSWRAPCOLS(range, wrap_count, [pad_with])Wraps the provided row or column of cells by columns after a specified number of elements to form a new array. Learn moreArrayWRAPROWSWRAPROWS(range, wrap_count, [pad_with])Wraps the provided row or column of cells by rows after a specified number of elements to form a new array. Learn moreWebENCODEURLENCODEURL(text)Encodes a string of text for the purpose of using in a URL query. Learn more.WebHYPERLINKHYPERLINK(url, [link_label]) Creates a hyperlink inside a cell. Learn moreWebIMPORTDATAIMPORTDATA(url) Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format. Learn moreWebIMPORTFEEDIMPORTFEED(url, [query], [headers], [num_items]) Imports a RSS or ATOM feed. Learn moreWebIMPORTHTMLIMPORTHTML(url, query, index) Imports data from a table or list within an HTML page. Learn moreWebIMPORTRANGEIMPORTRANGE(spreadsheet_url, range_string)Imports a range of cells from a specified spreadsheet. Learn moreWebIMPORTXMLIMPORTXML(url, xpath_query) Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Learn moreWebISURLISURL(value) Checks whether a value is a valid URL. Learn more