Here is the list of all Google Sheets functions
| Google Function | Syntax | Description | Category | Excel Function Equivalent |
|---|---|---|---|---|
| ARRAY_CONSTRAIN | ARRAY_CONSTRAIN(input_range, num_rows, num_cols) | Constrains an array result to a specified size | Google Array | |
| BYCOL | BYCOL(array_or_range, LAMBDA) | Groups an array by columns by application of a LAMBDA function to each column | Google Array | BYCOL |
| BYROW | BYROW(array_or_range, LAMBDA) | Groups an array by rows by application of a LAMBDA function to each row | Google Array | BYROW |
| CHOOSECOLS | CHOOSECOLS(array, col_num1, [col_num2]) | Creates a new array from the selected columns in the existing range | Google Array | CHOOSECOLS |
| CHOOSECOLS | CHOOSEROWS(array, row_num1, [row_num2]) | Creates a new array from the selected rows in the existing range | Google Array | CHOOSEROWS |
| FLATTEN | FLATTEN(range1,[range2,…]) | Flattens all the values from one or more ranges into a single column | Google Array | |
| FREQUENCY | FREQUENCY(data, classes) | Calculates the frequency distribution of a one-column array into specified classes | Google Array | FREQUENCY |
| GROWTH | GROWTH(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 | Google Array | GROWTH |
| HSTACK | HSTACK(range1; [range2, …]) | Appends ranges horizontally and in sequence to return a larger array. Learn more | Google Array | HSTACK |
| LINEST | LINEST(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 | Google Array | LINEST |
| LOGEST | LOGEST(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 | Google Array | LOGEST |
| MAKEARRAY | MAKEARRAY(rows, columns, LAMBDA) | Returns an array of specified dimensions with values calculated by application of a LAMBDA function | Google Array | MAKEARRAY |
| MAP | MAP(array1, [array2, …], LAMBDA) | Maps each value in the given arrays to a new value by application of a LAMBDA function to each value | Google Array | MAP |
| MDETERM | MDETERM(square_matrix) | Returns the matrix determinant of a square matrix specified as an array or range | Google Array | MDETERM |
| MINVERSE | MINVERSE(square_matrix) | Returns the multiplicative inverse of a square matrix specified as an array or range | Google Array | MINVERSE |
| MMULT | MMULT(matrix1, matrix2) | Calculates the matrix product of two matrices specified as arrays or ranges | Google Array | MMULT |
| REDUCE | REDUCE(initial_value, array_or_range, LAMBDA) | Reduces an array to an accumulated result by application of a LAMBDA function to each value | Google Array | REDUCE |
| SCAN | SCAN(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 | Google Array | SCAN |
| SUMPRODUCT | SUMPRODUCT(array1, [array2, …]) | Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges | Google Array | SUMPRODUCT |
| SUMX2MY2 | SUMX2MY2(array_x, array_y) | Calculates the sum of the differences of the squares of values in two arrays | Google Array | SUMX2MY2 |
| SUMX2PY2 | SUMX2PY2(array_x, array_y) | Calculates the sum of the sums of the squares of values in two arrays | Google Array | SUMX2PY2 |
| SUMXMY2 | SUMXMY2(array_x, array_y) | Calculates the sum of the squares of differences of values in two arrays | Google Array | SUMXMY2 |
| TOCOL | TOCOL(array_or_range, [ignore], [scan_by_column]) | Transforms an array or range of cells into a single column | Google Array | TOCOL |
| TOROW | TOROW(array_or_range, [ignore], [scan_by_column]) | Transforms an array or range of cells into a single row | Google Array | TOROW |
| TRANSPOSE | TRANSPOSE(array_or_range) | Transposes the rows and columns of an array or range of cells | Google Array | TRANSPOSE |
| TREND | TREND(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 | Google Array | TREND |
| VSTACK | VSTACK(range1; [range2, …]) | Appends ranges vertically and in sequence to return a larger array | Google Array | VSTACK |
| WRAPCOLS | WRAPCOLS(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 more | Google Array | WRAPCOLS |
| WRAPROWS | WRAPROWS(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 more | Google Array | WRAPROWS |
| DAVERAGE | DAVERAGE(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 | Google Database | DAVERAGE |
| DCOUNT | DCOUNT(database, field, criteria) | Counts numeric values selected from a database table-like array or range using a SQL-like query | Google Database | DCOUNT |
| DCOUNTA | DCOUNTA(database, field, criteria) | Counts values, including text, selected from a database table-like array or range using a SQL-like query | Google Database | DCOUNTA |
| DGET | DGET(database, field, criteria) | Returns a single value from a database table-like array or range using a SQL-like query | Google Database | DGET |
| DMAX | DMAX(database, field, criteria) | Returns the maximum value selected from a database table-like array or range using a SQL-like query | Google Database | DMAX |
| DMIN | DMIN(database, field, criteria) | Returns the minimum value selected from a database table-like array or range using a SQL-like query | Google Database | DMIN |
| DPRODUCT | DPRODUCT(database, field, criteria) | Returns the product of values selected from a database table-like array or range using a SQL-like query | Google Database | DPRODUCT |
| DSTDEV | DSTDEV(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 | Google Database | DSTDEV |
| DSTDEVP | DSTDEVP(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 | Google Database | DSTDEVP |
| DSUM | DSUM(database, field, criteria) | Returns the sum of values selected from a database table-like array or range using a SQL-like query. Learn more | Google Database | DSUM |
| DVAR | DVAR(database, field, criteria) | Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query | Google Database | DVAR |
| DVARP | DVARP(database, field, criteria) | Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query | Google Database | DVARP |
| DATE | DATE(year, month, day) | Converts a provided year, month, and day into a date | Google Date | DATE |
| DATEDIF | DATEDIF(start_date, end_date, unit) | Calculates the number of days, months, or years between two dates | Google Date | DATEDIF |
| DATEVALUE | DATEVALUE(date_string) | Converts a provided date string in a known format to a date value | Google Date | DATEVALUE |
| DAY | DAY(date) | Returns the day of the month that a specific date falls on, in numeric format | Google Date | DAY |
| DAYS | DAYS(end_date, start_date) | Returns the number of days between two dates | Google Date | DAYS |
| DAYS360 | DAYS360(start_date, end_date, [method]) | Returns the difference between two days based on the 360 day year used in some financial interest calculations | Google Date | DAYS360 |
| EDATE | EDATE(start_date, months) | Returns a date a specified number of months before or after another date | Google Date | EDATE |
| EOMONTH | EOMONTH(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 | Google Date | EOMONTH |
| EPOCHTODATE | EPOCHTODATE(timestamp, [unit]) | Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC | Google Date | |
| HOUR | HOUR(time) | Returns the hour component of a specific time, in numeric format | Google Date | HOUR |
| ISOWEEKNUM | ISOWEEKNUM(date) | Returns the number of the ISO week of the year where the provided date falls | Google Date | ISOWEEKNUM |
| MINUTE | MINUTE(time) | Returns the minute component of a specific time, in numeric format | Google Date | MINUTE |
| MONTH | MONTH(date) | Returns the month of the year a specific date falls in, in numeric format | Google Date | MONTH |
| NETWORKDAYS | NETWORKDAYS(start_date, end_date, [holidays]) | Returns the number of net working days between two provided days | Google Date | NETWORKDAYS |
| NETWORKDAYS.INTL | NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) | Returns the number of net working days between two provided days excluding specified weekend days and holidays | Google Date | NETWORKDAYS.INTL |
| NOW | NOW() | Returns the current date and time as a date value | Google Date | NOW |
| SECOND | SECOND(time) | Returns the second component of a specific time, in numeric format | Google Date | SECOND |
| TIME | TIME(hour, minute, second) | Converts a provided hour, minute, and second into a time | Google Date | TIME |
| TIMEVALUE | TIMEVALUE(time_string) | Returns the fraction of a 24-hour day the time represents | Google Date | TIMEVALUE |
| TODAY | TODAY() | Returns the current date as a date value | Google Date | TODAY |
| WEEKDAY | WEEKDAY(date, [type]) | Returns a number representing the day of the week of the date provided | Google Date | WEEKDAY |
| WEEKNUM | WEEKNUM(date, [type]) | Returns a number representing the week of the year where the provided date falls | Google Date | WEEKNUM |
| WORKDAY | WORKDAY(start_date, num_days, [holidays]) | Calculates the end date after a specified number of working days | Google Date | WORKDAY |
| WORKDAY.INTL | WORKDAY.INTL(start_date, num_days, [weekend], [holidays]) | Calculates the date after a specified number of workdays excluding specified weekend days and holidays | Google Date | WORKDAY.INTL |
| YEAR | YEAR(date) | Returns the year specified by a given date | Google Date | YEAR |
| YEARFRAC | YEARFRAC(start_date, end_date, [day_count_convention]) | Returns the number of years, including fractional years, between two dates using a specified day count convention | Google Date | YEARFRAC |
| BIN2DEC | BIN2DEC(signed_binary_number) | Converts a signed binary number to decimal format | Google Engineering | BIN2DEC |
| BIN2HEX | BIN2HEX(signed_binary_number, [significant_digits]) | Converts a signed binary number to signed hexadecimal format | Google Engineering | BIN2HEX |
| BIN2OCT | BIN2OCT(signed_binary_number, [significant_digits]) | Converts a signed binary number to signed octal format | Google Engineering | BIN2OCT |
| BITAND | BITAND(value1, value2) | Bitwise boolean AND of two numbers | Google Engineering | BITAND |
| BITLSHIFT | BITLSHIFT(value, shift_amount) | Shifts the bits of the input a certain number of places to the left | Google Engineering | BITLSHIFT |
| BITOR | BITOR(value1, value2) | Bitwise boolean OR of 2 numbers | Google Engineering | BITOR |
| BITRSHIFT | BITRSHIFT(value, shift_amount) | Shifts the bits of the input a certain number of places to the right | Google Engineering | BITRSHIFT |
| BITXOR | BITXOR(value1, value2) | Bitwise XOR (exclusive OR) of 2 numbers | Google Engineering | BITXOR |
| COMPLEX | COMPLEX(real_part, imaginary_part, [suffix]) | Creates a complex number given real and imaginary coefficients | Google Engineering | COMPLEX |
| DEC2BIN | DEC2BIN(decimal_number, [significant_digits]) | Converts a decimal number to signed binary format | Google Engineering | DEC2BIN |
| DEC2HEX | DEC2HEX(decimal_number, [significant_digits]) | Converts a decimal number to signed hexadecimal format | Google Engineering | DEC2HEX |
| DEC2OCT | DEC2OCT(decimal_number, [significant_digits]) | Converts a decimal number to signed octal format | Google Engineering | DEC2OCT |
| DELTA | DELTA(number1, [number2]) | Compare two numeric values, returning 1 if they’re equal | Google Engineering | DELTA |
| ERF | ERF(lower_bound, [upper_bound]) | The ERF function returns the integral of the Gauss error function over an interval of values | Google Engineering | ERF |
| ERF.PRECISE | ERF.PRECISE(lower_bound, [upper_bound]) | See ERF | Google Engineering | ERF.PRECISE |
| GESTEP | GESTEP(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 | Google Engineering | GESTEP |
| HEX2BIN | HEX2BIN(signed_hexadecimal_number, [significant_digits]) | Converts a signed hexadecimal number to signed binary format | Google Engineering | HEX2BIN |
| HEX2DEC | HEX2DEC(signed_hexadecimal_number) | Converts a signed hexadecimal number to decimal format | Google Engineering | HEX2DEC |
| HEX2OCT | HEX2OCT(signed_hexadecimal_number, significant_digits) | Converts a signed hexadecimal number to signed octal format | Google Engineering | HEX2OCT |
| IMABS | IMABS(number) | Returns absolute value of a complex number | Google Engineering | IMABS |
| IMAGINARY | IMAGINARY(complex_number) | Returns the imaginary coefficient of a complex number | Google Engineering | IMAGINARY |
| IMARGUMENT | IMARGUMENT(number) | The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians | Google Engineering | IMARGUMENT |
| IMCONJUGATE | IMCONJUGATE(number) | Returns the complex conjugate of a number | Google Engineering | IMCONJUGATE |
| IMCOS | IMCOS(number) | The IMCOS function returns the cosine of the given complex number | Google Engineering | IMCOS |
| IMCOSH | IMCOSH(number) | Returns the hyperbolic cosine of the given complex number. For example, a given complex number “x+yi” returns “cosh(x+yi).” Learn more. | Google Engineering | IMCOSH |
| IMCOT | IMCOT(number) | Returns the cotangent of the given complex number. For example, a given complex number “x+yi” returns “cot(x+yi).” Learn more. | Google Engineering | IMCOT |
| IMCOTH | IMCOTH(number) | Returns the hyperbolic cotangent of the given complex number. For example, a given complex number “x+yi” returns “coth(x+yi).” Learn more. | Google Engineering | |
| IMCSC | IMCSC(number) | Returns the cosecant of the given complex number | Google Engineering | IMCSC |
| IMCSCH | IMCSCH(number) | Returns the hyperbolic cosecant of the given complex number. For example, a given complex number “x+yi” returns “csch(x+yi).” Learn more. | Google Engineering | IMCSCH |
| IMDIV | IMDIV(dividend, divisor) | Returns one complex number divided by another | Google Engineering | IMDIV |
| IMEXP | IMEXP(exponent) | Returns Euler’s number, e (~2.718) raised to a complex power | Google Engineering | IMEXP |
| IMLOG | IMLOG(value, base) | Returns the logarithm of a complex number for a specified base. Learn more. | Google Engineering | |
| IMLOG10 | IMLOG10(value) | Returns the logarithm of a complex number with base 10. Learn more. | Google Engineering | IMLOG10 |
| IMLOG2 | IMLOG2(value) | Returns the logarithm of a complex number with base 2. Learn more. | Google Engineering | IMLOG2 |
| IMPRODUCT | IMPRODUCT(factor1, [factor2, …]) | Returns the result of multiplying a series of complex numbers together | Google Engineering | IMPRODUCT |
| IMREAL | IMREAL(complex_number) | Returns the real coefficient of a complex number | Google Engineering | IMREAL |
| IMSEC | IMSEC(number) | Returns the secant of the given complex number. For example, a given complex number “x+yi” returns “sec(x+yi).” Learn more. | Google Engineering | IMSEC |
| IMSECH | IMSECH(number) | Returns the hyperbolic secant of the given complex number. For example, a given complex number “x+yi” returns “sech(x+yi).” Learn more. | Google Engineering | IMSECH |
| IMSIN | IMSIN (number) | Returns the sine of the given complex number | Google Engineering | IMSIN |
| IMSINH | IMSINH(number) | Returns the hyperbolic sine of the given complex number. For example, a given complex number “x+yi” returns “sinh(x+yi).” Learn more. | Google Engineering | IMSINH |
| IMSUB | IMSUB(first_number, second_number) | Returns the difference between two complex numbers | Google Engineering | IMSUB |
| IMSUM | IMSUM(value1, [value2, …]) | Returns the sum of a series of complex numbers | Google Engineering | IMSUM |
| IMTAN | IMTAN(number) | Returns the tangent of the given complex number | Google Engineering | IMTAN |
| IMTANH | IMTANH(number) | Returns the hyperbolic tangent of the given complex number. For example, a given complex number “x+yi” returns “tanh(x+yi).” Learn more. | Google Engineering | |
| OCT2BIN | OCT2BIN(signed_octal_number, [significant_digits]) | Converts a signed octal number to signed binary format | Google Engineering | OCT2BIN |
| OCT2DEC | OCT2DEC(signed_octal_number) | Converts a signed octal number to decimal format | Google Engineering | OCT2DEC |
| OCT2HEX | OCT2HEX(signed_octal_number, [significant_digits]) | Converts a signed octal number to signed hexadecimal format | Google Engineering | OCT2HEX |
| FILTER | FILTER(range, condition1, [condition2]) | Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions | Google Filter | FILTER |
| SORT | SORT(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 | Google Filter | SORT |
| SORTN | SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], …) | Returns the first n items in a data set after performing a sort | Google Filter | |
| UNIQUE | UNIQUE(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 | Google Filter | UNIQUE |
| ACCRINT | ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention]) | Calculates the accrued interest of a security that has periodic payments | Google Financial | ACCRINT |
| ACCRINTM | ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention]) | Calculates the accrued interest of a security that pays interest at maturity | Google Financial | ACCRINTM |
| AMORLINC | AMORLINC(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 | Google Financial | AMORLINC |
| COUPDAYBS | COUPDAYBS(settlement, maturity, frequency, [day_count_convention]) | Calculates the number of days from the first coupon, or interest payment, until settlement | Google Financial | COUPDAYBS |
| COUPDAYS | COUPDAYS(settlement, maturity, frequency, [day_count_convention]) | Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date | Google Financial | COUPDAYS |
| COUPDAYSNC | COUPDAYSNC(settlement, maturity, frequency, [day_count_convention]) | Calculates the number of days from the settlement date until the next coupon, or interest payment | Google Financial | COUPDAYSNC |
| COUPNCD | COUPNCD(settlement, maturity, frequency, [day_count_convention]) | Calculates next coupon, or interest payment, date after the settlement date | Google Financial | COUPNCD |
| COUPNUM | COUPNUM(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 | Google Financial | COUPNUM |
| COUPPCD | COUPPCD(settlement, maturity, frequency, [day_count_convention]) | Calculates last coupon, or interest payment, date before the settlement date | Google Financial | COUPPCD |
| CUMIPMT | CUMIPMT(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 | Google Financial | CUMIPMT |
| CUMPRINC | CUMPRINC(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 | Google Financial | CUMPRINC |
| DB | DB(cost, salvage, life, period, [month]) | Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method | Google Financial | DB |
| DDB | DDB(cost, salvage, life, period, [factor]) | Calculates the depreciation of an asset for a specified period using the double-declining balance method | Google Financial | DDB |
| DISC | DISC(settlement, maturity, price, redemption, [day_count_convention]) | Calculates the discount rate of a security based on price | Google Financial | DISC |
| DOLLARDE | DOLLARDE(fractional_price, unit) | Converts a price quotation given as a decimal fraction into a decimal value | Google Financial | DOLLARDE |
| DOLLARFR | DOLLARFR(decimal_price, unit) | Converts a price quotation given as a decimal value into a decimal fraction | Google Financial | DOLLARFR |
| DURATION | DURATION(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 | Google Financial | DURATION |
| EFFECT | EFFECT(nominal_rate, periods_per_year) | Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year | Google Financial | EFFECT |
| FV | FV(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 | Google Financial | FV |
| FVSCHEDULE | FVSCHEDULE(principal, rate_schedule) | Calculates the future value of some principal based on a specified series of potentially varying interest rates | Google Financial | FVSCHEDULE |
| INTRATE | INTRATE(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 | Google Financial | INTRATE |
| IPMT | IPMT(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 | Google Financial | IPMT |
| IRR | IRR(cashflow_amounts, [rate_guess]) | Calculates the internal rate of return on an investment based on a series of periodic cash flows | Google Financial | IRR |
| ISPMT | ISPMT(rate, period, number_of_periods, present_value) | The ISPMT function calculates the interest paid during a particular period of an investment | Google Financial | ISPMT |
| MDURATION | MDURATION(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 | Google Financial | MDURATION |
| MIRR | MIRR(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 | Google Financial | MIRR |
| NOMINAL | NOMINAL(effective_rate, periods_per_year) | Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year | Google Financial | NOMINAL |
| NPER | NPER(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 | Google Financial | NPER |
| NPV | NPV(discount, cashflow1, [cashflow2, …]) | Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate | Google Financial | NPV |
| PDURATION | PDURATION(rate, present_value, future_value) | Returns the number of periods for an investment to reach a specific value at a given rate. Learn more. | Google Financial | PDURATION |
| PMT | PMT(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 | Google Financial | PMT |
| PPMT | PPMT(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 | Google Financial | PPMT |
| PRICE | PRICE(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 | Google Financial | PRICE |
| PRICEDISC | PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention]) | Calculates the price of a discount (non-interest-bearing) security, based on expected yield | Google Financial | PRICEDISC |
| PRICEMAT | PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention]) | Calculates the price of a security paying interest at maturity, based on expected yield | Google Financial | PRICEMAT |
| PV | PV(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 | Google Financial | PV |
| RATE | RATE(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 | Google Financial | RATE |
| RECEIVED | RECEIVED(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 | Google Financial | RECEIVED |
| RRI | RRI(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. | Google Financial | RRI |
| SLN | SLN(cost, salvage, life) | Calculates the depreciation of an asset for one period using the straight-line method | Google Financial | SLN |
| SYD | SYD(cost, salvage, life, period) | Calculates the depreciation of an asset for a specified period using the sum of years digits method | Google Financial | SYD |
| TBILLEQ | TBILLEQ(settlement, maturity, discount) | Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate | Google Financial | TBILLEQ |
| TBILLPRICE | TBILLPRICE(settlement, maturity, discount) | Calculates the price of a US Treasury Bill based on discount rate | Google Financial | TBILLPRICE |
| TBILLYIELD | TBILLYIELD(settlement, maturity, price) | Calculates the yield of a US Treasury Bill based on price | Google Financial | TBILLYIELD |
| VDB | VDB(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. | Google Financial | VDB |
| XIRR | XIRR(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 | Google Financial | XIRR |
| XNPV | XNPV(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 | Google Financial | XNPV |
| YIELD | YIELD(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 | Google Financial | YIELD |
| YIELDDISC | YIELDDISC(settlement, maturity, price, redemption, [day_count_convention]) | Calculates the annual yield of a discount (non-interest-bearing) security, based on price | Google Financial | YIELDDISC |
| YIELDMAT | YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention]) | Calculates the annual yield of a security paying interest at maturity, based on price | Google Financial | YIELDMAT |
| ARRAYFORMULA | ARRAYFORMULA(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 | Google Google | |
| DETECTLANGUAGE | DETECTLANGUAGE(text_or_range) | Identifies the language used in text within the specified range | Google Google | |
| GOOGLEFINANCE | GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval]) | Fetches current or historical securities information from Google Finance | Google Google | |
| GOOGLETRANSLATE | GOOGLETRANSLATE(text, [source_language], [target_language]) | Translates text from one language into another Learn more | Google Google | |
| IMAGE | IMAGE(url, [mode], [height], [width]) | Inserts an image into a cell | Google Google | IMAGE |
| QUERY | QUERY(data, query, [headers]) | Runs a Google Visualization API Query Language query across data | Google Google | |
| SPARKLINE | SPARKLINE(data, [options]) | Creates a miniature chart contained within a single cell | Google Google | |
| ERROR.TYPE | ERROR.TYPE(reference) | Returns a number corresponding to the error value in a different cell | Google Info | ERROR.TYPE |
| ISBLANK | ISBLANK(value) | Checks whether the referenced cell is empty | Google Info | ISBLANK |
| ISDATE | ISDATE(value) | Returns whether a value is a date | Google Info | |
| ISEMAIL | ISEMAIL(value) | Checks whether a value is a valid email address | Google Info | |
| ISERR | ISERR(value) | Checks whether a value is an error other than `#N/A` | Google Info | ISERR |
| ISERROR | ISERROR(value) | Checks whether a value is an error | Google Info | ISERROR |
| ISFORMULA | ISFORMULA(cell) | Checks whether a formula is in the referenced cell | Google Info | ISFORMULA |
| ISLOGICAL | ISLOGICAL(value) | Checks whether a value is `TRUE` or `FALSE` | Google Info | ISLOGICAL |
| ISNA | ISNA(value) | Checks whether a value is the error `#N/A` | Google Info | ISNA |
| ISNONTEXT | ISNONTEXT(value) | Checks whether a value is non-textual | Google Info | ISNONTEXT |
| ISNUMBER | ISNUMBER(value) | Checks whether a value is a number | Google Info | ISNUMBER |
| ISREF | ISREF(value) | Checks whether a value is a valid cell reference | Google Info | ISREF |
| ISTEXT | ISTEXT(value) | Checks whether a value is text | Google Info | ISTEXT |
| N | N(value) | Returns the argument provided as a number | Google Info | N |
| NA | NA() | Returns the “value not available” error, `#N/A` | Google Info | NA |
| TYPE | TYPE(value) | Returns a number associated with the type of data passed into the function | Google Info | TYPE |
| CELL | CELL(info_type, reference) | Returns the requested information about the specified cell | Google Info | CELL |
| AND | AND(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 | Google Logical | AND |
| FALSE | FALSE() | Returns the logical value `FALSE` | Google Logical | |
| IF | IF(logical_expression, value_if_true, value_if_false) | Returns one value if a logical expression is `TRUE` and another if it is `FALSE` | Google Logical | IF |
| IFERROR | IFERROR(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 | Google Logical | IFERROR |
| IFNA | IFNA(value, value_if_na) | Evaluates a value. If the value is an #N/A error, returns the specified value | Google Logical | IFNA |
| IFS | IFS(condition1, value1, [condition2, value2], …) | Evaluates multiple conditions and returns a value that corresponds to the first true condition | Google Logical | IFS |
| LAMBDA | LAMBDA(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 | Google Logical | LAMBDA |
| LET | LET(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 | Google Logical | LET |
| NOT | NOT(logical_expression) | Returns the opposite of a logical value – `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE` | Google Logical | NOT |
| OR | OR(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 | Google Logical | OR |
| SWITCH | SWITCH(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 | Google Logical | SWITCH |
| TRUE | TRUE() | Returns the logical value `TRUE` | Google Logical | |
| XOR | XOR(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 | Google Logical | XOR |
| ADDRESS | ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet]) | Returns a cell reference as a string | Google Lookup | ADDRESS |
| CHOOSE | CHOOSE(index, choice1, [choice2, …]) | Returns an element from a list of choices based on index | Google Lookup | CHOOSE |
| COLUMN | COLUMN([cell_reference]) | Returns the column number of a specified cell, with `A=1` | Google Lookup | COLUMN |
| COLUMNS | COLUMNS(range) | Returns the number of columns in a specified array or range | Google Lookup | COLUMNS |
| FORMULATEXT | FORMULATEXT(cell) | Returns the formula as a string. Learn more. | Google Lookup | FORMULATEXT |
| GETPIVOTDATA | GETPIVOTDATA(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 | Google Lookup | GETPIVOTDATA |
| HLOOKUP | HLOOKUP(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 | Google Lookup | HLOOKUP |
| INDEX | INDEX(reference, [row], [column]) | Returns the content of a cell, specified by row and column offset | Google Lookup | INDEX |
| INDIRECT | INDIRECT(cell_reference_as_string, [is_A1_notation]) | Returns a cell reference specified by a string | Google Lookup | INDIRECT |
| LOOKUP | LOOKUP(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 | Google Lookup | LOOKUP |
| MATCH | MATCH(search_key, range, [search_type]) | Returns the relative position of an item in a range that matches a specified value | Google Lookup | MATCH |
| OFFSET | OFFSET(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 | Google Lookup | OFFSET |
| ROW | ROW([cell_reference]) | Returns the row number of a specified cell | Google Lookup | ROW |
| ROWS | ROWS(range) | Returns the number of rows in a specified array or range | Google Lookup | ROWS |
| VLOOKUP | VLOOKUP(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 | Google Lookup | VLOOKUP |
| XLOOKUP | XLOOKUP(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 | Google Lookup | XLOOKUP |
| ABS | ABS(value) | Returns the absolute value of a number | Google Math | ABS |
| ACOS | ACOS(value) | Returns the inverse cosine of a value, in radians | Google Math | ACOS |
| ACOSH | ACOSH(value) | Returns the inverse hyperbolic cosine of a number | Google Math | ACOSH |
| ACOT | ACOT(value) | Returns the inverse cotangent of a value, in radians | Google Math | ACOT |
| ACOTH | ACOTH(value) | Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive | Google Math | ACOTH |
| ASIN | ASIN(value) | Returns the inverse sine of a value, in radians | Google Math | ASIN |
| ASINH | ASINH(value) | Returns the inverse hyperbolic sine of a number | Google Math | ASINH |
| ATAN | ATAN(value) | Returns the inverse tangent of a value, in radians | Google Math | ATAN |
| ATAN2 | ATAN2(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 | Google Math | ATAN2 |
| ATANH | ATANH(value) | Returns the inverse hyperbolic tangent of a number | Google Math | ATANH |
| BASE | BASE(value, base, [min_length]) | Converts a number into a text representation in another base, for example, base 2 for binary | Google Math | BASE |
| CEILING | CEILING(value, [factor]) | Rounds a number up to the nearest integer multiple of specified significance | Google Math | CEILING |
| CEILING.MATH | CEILING.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 | Google Math | CEILING.MATH |
| CEILING.PRECISE | CEILING.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 | Google Math | CEILING.PRECISE |
| COMBIN | COMBIN(n, k) | Returns the number of ways to choose some number of objects from a pool of a given size of objects | Google Math | COMBIN |
| COMBINA | COMBINA(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 | Google Math | COMBINA |
| COS | COS(angle) | Returns the cosine of an angle provided in radians | Google Math | COS |
| COSH | COSH(value) | Returns the hyperbolic cosine of any real number | Google Math | COSH |
| COT | COT(angle) | Cotangent of an angle provided in radians | Google Math | COT |
| COTH | COTH(value) | Returns the hyperbolic cotangent of any real number | Google Math | COTH |
| COUNTBLANK | COUNTBLANK(range) | Returns the number of empty cells in a given range | Google Math | COUNTBLANK |
| COUNTIF | COUNTIF(range, criterion) | Returns a conditional count across a range | Google Math | COUNTIF |
| COUNTIFS | COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, …]) | Returns the count of a range depending on multiple criteria | Google Math | COUNTIFS |
| COUNTUNIQUE | COUNTUNIQUE(value1, [value2, …]) | Counts the number of unique values in a list of specified values and ranges | Google Math | |
| CSC | CSC(angle) | Returns the cosecant of an angle provided in radians | Google Math | CSC |
| CSCH | CSCH(value) | The CSCH function returns the hyperbolic cosecant of any real number | Google Math | CSCH |
| DECIMAL | DECIMAL(value, base) | The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal) | Google Math | DECIMAL |
| DEGREES | DEGREES(angle) | Converts an angle value in radians to degrees | Google Math | DEGREES |
| ERFC | ERFC(z) | Returns the complementary Gauss error function of a value | Google Math | ERFC |
| ERFC.PRECISE | ERFC.PRECISE(z) | See ERFC | Google Math | ERFC.PRECISE |
| EVEN | EVEN(value) | Rounds a number up to the nearest even integer | Google Math | EVEN |
| EXP | EXP(exponent) | Returns Euler’s number, e (~2.718) raised to a power | Google Math | EXP |
| FACT | FACT(value) | Returns the factorial of a number | Google Math | FACT |
| FACTDOUBLE | FACTDOUBLE(value) | Returns the “double factorial” of a number | Google Math | FACTDOUBLE |
| FLOOR | FLOOR(value, [factor]) | Rounds a number down to the nearest integer multiple of specified significance | Google Math | FLOOR |
| FLOOR.MATH | FLOOR.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 | Google Math | FLOOR.MATH |
| FLOOR.PRECISE | FLOOR.PRECISE(number, [significance]) | The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance | Google Math | FLOOR.PRECISE |
| GAMMALN | GAMMALN(value) | Returns the the logarithm of a specified Gamma function, base e (Euler’s number) | Google Math | GAMMALN |
| GAMMALN.PRECISE | GAMMALN.PRECISE(value) | See GAMMALN | Google Math | GAMMALN.PRECISE |
| GCD | GCD(value1, value2) | Returns the greatest common divisor of one or more integers | Google Math | GCD |
| IMLN | IMLN(complex_value) | Returns the logarithm of a complex number, base e (Euler’s number) | Google Math | IMLN |
| IMPOWER | IMPOWER(complex_base, exponent) | Returns a complex number raised to a power | Google Math | IMPOWER |
| IMSQRT | IMSQRT(complex_number) | Computes the square root of a complex number | Google Math | IMSQRT |
| INT | INT(value) | Rounds a number down to the nearest integer that is less than or equal to it | Google Math | INT |
| ISEVEN | ISEVEN(value) | Checks whether the provided value is even | Google Math | ISEVEN |
| ISO.CEILING | ISO.CEILING(number, [significance]) | See CEILING.PRECISE | Google Math | ISO.CEILING |
| ISODD | ISODD(value) | Checks whether the provided value is odd | Google Math | ISODD |
| LCM | LCM(value1, value2) | Returns the least common multiple of one or more integers | Google Math | LCM |
| LN | LN(value) | Returns the the logarithm of a number, base e (Euler’s number) | Google Math | LN |
| LOG | LOG(value, base) | Returns the the logarithm of a number given a base | Google Math | LOG |
| LOG10 | LOG10(value) | Returns the the logarithm of a number, base 10 | Google Math | LOG10 |
| MOD | MOD(dividend, divisor) | Returns the result of the modulo operator, the remainder after a division operation | Google Math | MOD |
| MROUND | MROUND(value, factor) | Rounds one number to the nearest integer multiple of another. Learn more | Google Math | MROUND |
| MULTINOMIAL | MULTINOMIAL(value1, value2) | Returns the factorial of the sum of values divided by the product of the values’ factorials | Google Math | MULTINOMIAL |
| MUNIT | MUNIT(dimension) | Returns a unit matrix of size dimension x dimension. Learn more. | Google Math | MUNIT |
| ODD | ODD(value) | Rounds a number up to the nearest odd integer | Google Math | ODD |
| PI | PI() | Returns the value of Pi to 14 decimal places | Google Math | PI |
| POWER | POWER(base, exponent) | Returns a number raised to a power | Google Math | POWER |
| PRODUCT | PRODUCT(factor1, [factor2, …]) | Returns the result of multiplying a series of numbers together | Google Math | PRODUCT |
| QUOTIENT | QUOTIENT(dividend, divisor) | Returns one number divided by another | Google Math | QUOTIENT |
| RADIANS | RADIANS(angle) | Converts an angle value in degrees to radians | Google Math | RADIANS |
| RAND | RAND() | Returns a random number between 0 inclusive and 1 exclusive | Google Math | RAND |
| RANDARRAY | RANDARRAY(rows, columns) | Generates an array of random numbers between 0 and 1. Learn more. | Google Math | RANDARRAY |
| RANDBETWEEN | RANDBETWEEN(low, high) | Returns a uniformly random integer between two values, inclusive | Google Math | RANDBETWEEN |
| ROUND | ROUND(value, [places]) | Rounds a number to a certain number of decimal places according to standard rules | Google Math | ROUND |
| ROUNDDOWN | ROUNDDOWN(value, [places]) | Rounds a number to a certain number of decimal places, always rounding down to the next valid increment | Google Math | ROUNDDOWN |
| ROUNDUP | ROUNDUP(value, [places]) | Rounds a number to a certain number of decimal places, always rounding up to the next valid increment | Google Math | ROUNDUP |
| SEC | SEC(angle) | The SEC function returns the secant of an angle, measured in radians | Google Math | SEC |
| SECH | SECH(value) | The SECH function returns the hyperbolic secant of an angle | Google Math | SECH |
| SEQUENCE | SEQUENCE(rows, columns, start, step) | Returns an array of sequential numbers, such as 1, 2, 3, 4. Learn more. | Google Math | SEQUENCE |
| SERIESSUM | SERIESSUM(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` | Google Math | SERIESSUM |
| SIGN | SIGN(value) | Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero | Google Math | SIGN |
| SIN | SIN(angle) | Returns the sine of an angle provided in radians | Google Math | SIN |
| SINH | SINH(value) | Returns the hyperbolic sine of any real number | Google Math | SINH |
| SQRT | SQRT(value) | Returns the positive square root of a positive number | Google Math | SQRT |
| SQRTPI | SQRTPI(value) | Returns the positive square root of the product of Pi and the given positive number | Google Math | SQRTPI |
| SUBTOTAL | SUBTOTAL(function_code, range1, [range2, …]) | Returns a subtotal for a vertical range of cells using a specified aggregation function | Google Math | SUBTOTAL |
| SUM | SUM(value1, [value2, …]) | Returns the sum of a series of numbers and/or cells | Google Math | SUM |
| SUMIF | SUMIF(range, criterion, [sum_range]) | Returns a conditional sum across a range. Learn more | Google Math | SUMIF |
| SUMIFS | SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, …]) | Returns the sum of a range depending on multiple criteria | Google Math | SUMIFS |
| SUMSQ | SUMSQ(value1, [value2, …]) | Returns the sum of the squares of a series of numbers and/or cells | Google Math | SUMSQ |
| TAN | TAN(angle) | Returns the tangent of an angle provided in radians | Google Math | TAN |
| TANH | TANH(value) | Returns the hyperbolic tangent of any real number | Google Math | TANH |
| TRUNC | TRUNC(value, [places]) | Truncates a number to a certain number of significant digits by omitting less significant digits | Google Math | TRUNC |
| ADD | ADD(value1, value2) | Returns the sum of two numbers. Equivalent to the `+` operator | Google Operator | |
| CONCAT | CONCAT(value1, value2) | Returns the concatenation of two values. Equivalent to the `&` operator | Google Operator | CONCAT |
| DIVIDE | DIVIDE(dividend, divisor) | Returns one number divided by another. Equivalent to the `/` operator | Google Operator | |
| EQ | EQ(value1, value2) | Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator | Google Operator | |
| GT | GT(value1, value2) | Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator | Google Operator | |
| GTE | GTE(value1, value2) | Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator | Google Operator | |
| ISBETWEEN | ISBETWEEN(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 | Google Operator | |
| LT | LT(value1, value2) | Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator | Google Operator | |
| LTE | LTE(value1, value2) | Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator | Google Operator | |
| MINUS | MINUS(value1, value2) | Returns the difference of two numbers. Equivalent to the `-` operator | Google Operator | |
| MULTIPLY | MULTIPLY(factor1, factor2) | Returns the product of two numbers. Equivalent to the `*` operator | Google Operator | |
| NE | NE(value1, value2) | Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator | Google Operator | |
| POW | POW(base, exponent) | Returns a number raised to a power | Google Operator | |
| UMINUS | UMINUS(value) | Returns a number with the sign reversed | Google Operator | |
| UNARY_PERCENT | UNARY_PERCENT(percentage) | Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1` | Google Operator | |
| UNIQUE | UNIQUE(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 | Google Operator | UNIQUE |
| UPLUS | UPLUS(value) | Returns a specified number, unchanged. Learn more | Google Operator | |
| CONVERT | CONVERT(value, start_unit, end_unit) | Converts a numeric value to a different unit of measure | Google Parser | CONVERT |
| TO_DATE | TO_DATE(value) | Converts a provided number to a date | Google Parser | |
| TO_DOLLARS | TO_DOLLARS(value) | Converts a provided number to a dollar value | Google Parser | |
| TO_PERCENT | TO_PERCENT(value) | Converts a provided number to a percentage | Google Parser | |
| TO_PURE_NUMBER | TO_PURE_NUMBER(value) | Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting | Google Parser | |
| TO_TEXT | TO_TEXT(value) | Converts a provided numeric value to a text value | Google Parser | |
| AVEDEV | AVEDEV(value1, [value2, …]) | Calculates the average of the magnitudes of deviations of data from a dataset’s mean | Google Statistical | AVEDEV |
| AVERAGE | AVERAGE(value1, [value2, …]) | Returns the numerical average value in a dataset, ignoring text | Google Statistical | AVERAGE |
| AVERAGE.WEIGHTED | AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights]) | Finds the weighted average of a set of values, given the values and the corresponding weights | Google Statistical | |
| AVERAGEA | AVERAGEA(value1, [value2, …]) | Returns the numerical average value in a dataset | Google Statistical | AVERAGEA |
| AVERAGEIF | AVERAGEIF(criteria_range, criterion, [average_range]) | Returns the average of a range depending on criteria | Google Statistical | AVERAGEIF |
| AVERAGEIFS | AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, …]) | Returns the average of a range depending on multiple criteria | Google Statistical | AVERAGEIFS |
| BETA.DIST | BETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound) | Returns the probability of a given value as defined by the beta distribution function | Google Statistical | BETA.DIST |
| BETA.INV | BETA.INV(probability, alpha, beta, lower_bound, upper_bound) | Returns the value of the inverse beta distribution function for a given probability | Google Statistical | BETA.INV |
| BETADIST | BETADIST(value, alpha, beta, lower_bound, upper_bound) | See BETA.DIST. | Google Statistical | BETADIST |
| BETAINV | BETAINV(probability, alpha, beta, lower_bound, upper_bound) | See BETA.INV | Google Statistical | BETAINV |
| BINOM.DIST | BINOM.DIST(num_successes, num_trials, prob_success, cumulative) | See BINOMDIST | Google Statistical | BINOM.DIST |
| BINOM.INV | BINOM.INV(num_trials, prob_success, target_prob) | See CRITBINOM | Google Statistical | BINOM.INV |
| BINOMDIST | BINOMDIST(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 | Google Statistical | BINOMDIST |
| CHIDIST | CHIDIST(x, degrees_freedom) | Calculates the right-tailed chi-squared distribution, often used in hypothesis testing | Google Statistical | CHIDIST |
| CHIINV | CHIINV(probability, degrees_freedom) | Calculates the inverse of the right-tailed chi-squared distribution | Google Statistical | CHIINV |
| CHISQ.DIST | CHISQ.DIST(x, degrees_freedom, cumulative) | Calculates the left-tailed chi-squared distribution, often used in hypothesis testing | Google Statistical | CHISQ.DIST |
| CHISQ.DIST.RT | CHISQ.DIST.RT(x, degrees_freedom) | Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing | Google Statistical | CHISQ.DIST.RT |
| CHISQ.INV | CHISQ.INV(probability, degrees_freedom) | Calculates the inverse of the left-tailed chi-squared distribution | Google Statistical | CHISQ.INV |
| CHISQ.INV.RT | CHISQ.INV.RT(probability, degrees_freedom) | Calculates the inverse of the right-tailed chi-squared distribution | Google Statistical | CHISQ.INV.RT |
| CHISQ.TEST | CHISQ.TEST(observed_range, expected_range) | See CHITEST | Google Statistical | CHISQ.TEST |
| CHITEST | CHITEST(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 | Google Statistical | CHITEST |
| CONFIDENCE | CONFIDENCE(alpha, standard_deviation, pop_size) | See CONFIDENCE.NORM | Google Statistical | CONFIDENCE |
| CONFIDENCE.NORM | CONFIDENCE.NORM(alpha, standard_deviation, pop_size) | Calculates the width of half the confidence interval for a normal distribution | Google Statistical | CONFIDENCE.NORM |
| CONFIDENCE.T | CONFIDENCE.T(alpha, standard_deviation, size) | Calculates the width of half the confidence interval for a Student’s t-distribution | Google Statistical | CONFIDENCE.T |
| CORREL | CORREL(data_y, data_x) | Calculates r, the Pearson product-moment correlation coefficient of a dataset | Google Statistical | CORREL |
| COUNT | COUNT(value1, [value2, …]) | Returns a count of the number of numeric values in a dataset | Google Statistical | COUNT |
| COUNTA | COUNTA(value1, [value2, …]) | Returns a count of the number of values in a dataset | Google Statistical | COUNTA |
| COVAR | COVAR(data_y, data_x) | Calculates the covariance of a dataset | Google Statistical | COVAR |
| COVARIANCE.P | COVARIANCE.P(data_y, data_x) | See COVAR | Google Statistical | COVARIANCE.P |
| COVARIANCE.S | COVARIANCE.S(data_y, data_x) | Calculates the covariance of a dataset, where the dataset is a sample of the total population | Google Statistical | COVARIANCE.S |
| CRITBINOM | CRITBINOM(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 | Google Statistical | CRITBINOM |
| DEVSQ | DEVSQ(value1, value2) | Calculates the sum of squares of deviations based on a sample | Google Statistical | DEVSQ |
| EXPON.DIST | EXPON.DIST(x, LAMBDA, cumulative) | Returns the value of the exponential distribution function with a specified LAMBDA at a specified value | Google Statistical | EXPON.DIST |
| EXPONDIST | EXPONDIST(x, LAMBDA, cumulative) | See EXPON.DIST | Google Statistical | EXPONDIST |
| F.DIST | F.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 | Google Statistical | F.DIST |
| F.DIST.RT | F.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 | Google Statistical | F.DIST.RT |
| F.INV | F.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 | Google Statistical | F.INV |
| F.INV.RT | F.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 | Google Statistical | F.INV.RT |
| F.TEST | F.TEST(range1, range2) | See FTEST. | Google Statistical | F.TEST |
| FDIST | FDIST(x, degrees_freedom1, degrees_freedom2) | See F.DIST.RT. | Google Statistical | FDIST |
| FINV | FINV(probability, degrees_freedom1, degrees_freedom2) | See F.INV.RT | Google Statistical | FINV |
| FISHER | FISHER(value) | Returns the Fisher transformation of a specified value | Google Statistical | FISHER |
| FISHERINV | FISHERINV(value) | Returns the inverse Fisher transformation of a specified value | Google Statistical | FISHERINV |
| FORECAST | FORECAST(x, data_y, data_x) | Calculates the expected y-value for a specified x based on a linear regression of a dataset | Google Statistical | FORECAST |
| FORECAST.LINEAR | FORECAST.LINEAR(x, data_y, data_x) | See FORECAST | Google Statistical | FORECAST.LINEAR |
| FTEST | FTEST(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 | Google Statistical | FTEST |
| GAMMA | GAMMA(number) | Returns the Gamma function evaluated at the specified value | Google Statistical | GAMMA |
| GAMMA.DIST | GAMMA.DIST(x, alpha, beta, cumulative) | Calculates the gamma distribution, a two-parameter continuous probability distribution | Google Statistical | GAMMA.DIST |
| GAMMA.INV | GAMMA.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 | Google Statistical | GAMMA.INV |
| GAMMADIST | GAMMADIST(x, alpha, beta, cumulative) | See GAMMA.DIST | Google Statistical | GAMMADIST |
| GAMMAINV | GAMMAINV(probability, alpha, beta) | See GAMMA.INV. | Google Statistical | GAMMAINV |
| GAUSS | GAUSS(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 | Google Statistical | GAUSS |
| GEOMEAN | GEOMEAN(value1, value2) | Calculates the geometric mean of a dataset | Google Statistical | GEOMEAN |
| HARMEAN | HARMEAN(value1, value2) | Calculates the harmonic mean of a dataset | Google Statistical | HARMEAN |
| HYPGEOM.DIST | HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size) | See HYPGEOMDIST | Google Statistical | HYPGEOM.DIST |
| HYPGEOMDIST | HYPGEOMDIST(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 | Google Statistical | HYPGEOMDIST |
| INTERCEPT | INTERCEPT(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) | Google Statistical | INTERCEPT |
| KURT | KURT(value1, value2) | Calculates the kurtosis of a dataset, which describes the shape, and in particular the “peakedness” of that dataset | Google Statistical | KURT |
| LARGE | LARGE(data, n) | Returns the nth largest element from a data set, where n is user-defined | Google Statistical | LARGE |
| LOGINV | LOGINV(x, mean, standard_deviation) | Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value | Google Statistical | LOGINV |
| LOGNORM.DIST | LOGNORM.DIST(x, mean, standard_deviation) | See LOGNORMDIST | Google Statistical | LOGNORM.DIST |
| LOGNORM.INV | LOGNORM.INV(x, mean, standard_deviation) | See LOGINV | Google Statistical | LOGNORM.INV |
| LOGNORMDIST | LOGNORMDIST(x, mean, standard_deviation) | Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value | Google Statistical | LOGNORMDIST |
| MARGINOFERROR | MARGINOFERROR(range, confidence) | Calculates the amount of random sampling error given a range of values and a confidence level | Google Statistical | |
| MAX | MAX(value1, [value2, …]) | Returns the maximum value in a numeric dataset | Google Statistical | MAX |
| MAXA | MAXA(value1, value2) | Returns the maximum numeric value in a dataset | Google Statistical | MAXA |
| MAXIFS | MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …) | Returns the maximum value in a range of cells, filtered by a set of criteria | Google Statistical | MAXIFS |
| MEDIAN | MEDIAN(value1, [value2, …]) | Returns the median value in a numeric dataset | Google Statistical | MEDIAN |
| MIN | MIN(value1, [value2, …]) | Returns the minimum value in a numeric dataset | Google Statistical | MIN |
| MINA | MINA(value1, value2) | Returns the minimum numeric value in a dataset | Google Statistical | MINA |
| MINIFS | MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …) | Returns the minimum value in a range of cells, filtered by a set of criteria | Google Statistical | MINIFS |
| MODE | MODE(value1, [value2, …]) | Returns the most commonly occurring value in a dataset | Google Statistical | MODE |
| MODE.MULT | MODE.MULT(value1, value2) | Returns the most commonly occurring values in a dataset. Learn more. | Google Statistical | MODE.MULT |
| MODE.SNGL | MODE.SNGL(value1, [value2, …]) | See MODE | Google Statistical | MODE.SNGL |
| NEGBINOM.DIST | NEGBINOM.DIST(num_failures, num_successes, prob_success) | See NEGBINOMDIST | Google Statistical | NEGBINOM.DIST |
| NEGBINOMDIST | NEGBINOMDIST(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 | Google Statistical | NEGBINOMDIST |
| NORM.DIST | NORM.DIST(x, mean, standard_deviation, cumulative) | See NORMDIST | Google Statistical | NORM.DIST |
| NORM.INV | NORM.INV(x, mean, standard_deviation) | See NORMINV | Google Statistical | NORM.INV |
| NORM.S.DIST | NORM.S.DIST(x) | See NORMSDIST | Google Statistical | NORM.S.DIST |
| NORM.S.INV | NORM.S.INV(x) | See NORMSINV | Google Statistical | NORM.S.INV |
| NORMDIST | NORMDIST(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 | Google Statistical | NORMDIST |
| NORMINV | NORMINV(x, mean, standard_deviation) | Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation | Google Statistical | NORMINV |
| NORMSDIST | NORMSDIST(x) | Returns the value of the standard normal cumulative distribution function for a specified value | Google Statistical | NORMSDIST |
| NORMSINV | NORMSINV(x) | Returns the value of the inverse standard normal distribution function for a specified value | Google Statistical | NORMSINV |
| PEARSON | PEARSON(data_y, data_x) | Calculates r, the Pearson product-moment correlation coefficient of a dataset | Google Statistical | PEARSON |
| PERCENTILE | PERCENTILE(data, percentile) | Returns the value at a given percentile of a dataset | Google Statistical | PERCENTILE |
| PERCENTILE.EXC | PERCENTILE.EXC(data, percentile) | Returns the value at a given percentile of a dataset, exclusive of 0 and 1. Learn more. | Google Statistical | PERCENTILE.EXC |
| PERCENTILE.INC | PERCENTILE.INC(data, percentile) | See PERCENTILE | Google Statistical | PERCENTILE.INC |
| PERCENTRANK | PERCENTRANK(data, value, [significant_digits]) | Returns the percentage rank (percentile) of a specified value in a dataset | Google Statistical | PERCENTRANK |
| PERCENTRANK.EXC | PERCENTRANK.EXC(data, value, [significant_digits]) | Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset. Learn more | Google Statistical | PERCENTRANK.EXC |
| PERCENTRANK.INC | PERCENTRANK.INC(data, value, [significant_digits]) | Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset | Google Statistical | PERCENTRANK.INC |
| PERMUTATIONA | PERMUTATIONA(number, number_chosen) | Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. Learn more. | Google Statistical | PERMUTATIONA |
| PERMUT | PERMUT(n, k) | Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order | Google Statistical | PERMUT |
| PHI | PHI(x) | The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1 | Google Statistical | PHI |
| POISSON | POISSON(x, mean, cumulative) | See POISSON.DIST | Google Statistical | POISSON |
| POISSON.DIST | POISSON.DIST(x, mean, [cumulative]) | Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean | Google Statistical | POISSON.DIST |
| PROB | PROB(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 | Google Statistical | PROB |
| QUARTILE | QUARTILE(data, quartile_number) | Returns a value nearest to a specified quartile of a dataset | Google Statistical | QUARTILE |
| QUARTILE.EXC | QUARTILE.EXC(data, quartile_number) | Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4. Learn more. | Google Statistical | QUARTILE.EXC |
| QUARTILE.INC | QUARTILE.INC(data, quartile_number) | See QUARTILE | Google Statistical | QUARTILE.INC |
| RANK | RANK(value, data, [is_ascending]) | Returns the rank of a specified value in a dataset | Google Statistical | RANK |
| RANK.AVG | RANK.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 | Google Statistical | RANK.AVG |
| RANK.EQ | RANK.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 | Google Statistical | RANK.EQ |
| RSQ | RSQ(data_y, data_x) | Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset | Google Statistical | RSQ |
| SKEW | SKEW(value1, value2) | Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean | Google Statistical | SKEW |
| SKEW.P | SKEW.P(value1, value2) | Calculates the skewness of a dataset that represents the entire population. Learn more. | Google Statistical | SKEW.P |
| SLOPE | SLOPE(data_y, data_x) | Calculates the slope of the line resulting from linear regression of a dataset | Google Statistical | SLOPE |
| SMALL | SMALL(data, n) | Returns the nth smallest element from a data set, where n is user-defined | Google Statistical | SMALL |
| STANDARDIZE | STANDARDIZE(value, mean, standard_deviation) | Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution | Google Statistical | STANDARDIZE |
| STDEV | STDEV(value1, [value2, …]) | Calculates the standard deviation based on a sample | Google Statistical | STDEV |
| STDEV.P | STDEV.P(value1, [value2, …]) | See STDEVP | Google Statistical | STDEV.P |
| STDEV.S | STDEV.S(value1, [value2, …]) | See STDEV | Google Statistical | STDEV.S |
| STDEVA | STDEVA(value1, value2) | Calculates the standard deviation based on a sample, setting text to the value `0` | Google Statistical | STDEVA |
| STDEVP | STDEVP(value1, value2) | Calculates the standard deviation based on an entire population | Google Statistical | STDEVP |
| STDEVPA | STDEVPA(value1, value2) | Calculates the standard deviation based on an entire population, setting text to the value `0` | Google Statistical | STDEVPA |
| STEYX | STEYX(data_y, data_x) | Calculates the standard error of the predicted y-value for each x in the regression of a dataset | Google Statistical | STEYX |
| T.DIST | T.DIST(x, degrees_freedom, cumulative) | Returns the right tailed Student distribution for a value x. Learn more. | Google Statistical | T.DIST |
| T.DIST.2T | T.DIST.2T(x, degrees_freedom) | Returns the two tailed Student distribution for a value x. Learn more. | Google Statistical | T.DIST.2T |
| T.DIST.RT | T.DIST.RT(x, degrees_freedom) | Returns the right tailed Student distribution for a value x. Learn more. | Google Statistical | T.DIST.RT |
| T.INV | T.INV(probability, degrees_freedom) | Calculates the negative inverse of the one-tailed TDIST function | Google Statistical | T.INV |
| T.INV.2T | T.INV.2T(probability, degrees_freedom) | Calculates the inverse of the two-tailed TDIST function | Google Statistical | T.INV.2T |
| T.TEST | T.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 | Google Statistical | T.TEST |
| TDIST | TDIST(x, degrees_freedom, tails) | Calculates the probability for Student’s t-distribution with a given input (x) | Google Statistical | TDIST |
| TINV | TINV(probability, degrees_freedom) | See T.INV.2T | Google Statistical | TINV |
| TRIMMEAN | TRIMMEAN(data, exclude_proportion) | Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset | Google Statistical | TRIMMEAN |
| TTEST | TTEST(range1, range2, tails, type) | See T.TEST. | Google Statistical | TTEST |
| VAR | VAR(value1, [value2, …]) | Calculates the variance based on a sample | Google Statistical | VAR |
| VAR.P | VAR.P(value1, [value2, …]) | See VARP | Google Statistical | VAR.P |
| VAR.S | VAR.S(value1, [value2, …]) | See VAR | Google Statistical | VAR.S |
| VARA | VARA(value1, value2) | Calculates an estimate of variance based on a sample, setting text to the value `0` | Google Statistical | VARA |
| VARP | VARP(value1, value2) | Calculates the variance based on an entire population | Google Statistical | VARP |
| VARPA | VARPA(value1, value2,…) | Calculates the variance based on an entire population, setting text to the value `0` | Google Statistical | VARPA |
| WEIBULL | WEIBULL(x, shape, scale, cumulative) | Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale | Google Statistical | WEIBULL |
| WEIBULL.DIST | WEIBULL.DIST(x, shape, scale, cumulative) | See WEIBULL | Google Statistical | WEIBULL.DIST |
| Z.TEST | Z.TEST(data, value, [standard_deviation]) | Returns the one-tailed P-value of a Z-test with standard distribution | Google Statistical | Z.TEST |
| ZTEST | ZTEST(data, value, [standard_deviation]) | See Z.TEST. | Google Statistical | ZTEST |
| ARABIC | ARABIC(roman_numeral) | Computes the value of a Roman numeral | Google Text | ARABIC |
| ASC | ASC(text) | Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged | Google Text | ASC |
| CHAR | CHAR(table_number) | Convert a number into a character according to the current Unicode table | Google Text | CHAR |
| CLEAN | CLEAN(text) | Returns the text with the non-printable ASCII characters removed | Google Text | CLEAN |
| CODE | CODE(string) | Returns the numeric Unicode map value of the first character in the string provided. Learn more | Google Text | CODE |
| CONCATENATE | CONCATENATE(string1, [string2, …]) | Appends strings to one another | Google Text | CONCATENATE |
| DOLLAR | DOLLAR(number, [number_of_places]) | Formats a number into the locale-specific currency format | Google Text | DOLLAR |
| EXACT | EXACT(string1, string2) | Tests whether two strings are identical | Google Text | EXACT |
| FIND | FIND(search_for, text_to_search, [starting_at]) | Returns the position at which a string is first found within text | Google Text | |
| FINDB | FINDB(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 | Google Text | |
| FIXED | FIXED(number, [number_of_places], [suppress_separator]) | Formats a number with a fixed number of decimal places | Google Text | FIXED |
| JOIN | JOIN(delimiter, value_or_array1, [value_or_array2, …]) | Concatenates the elements of one or more one-dimensional arrays using a specified delimiter | Google Text | |
| LEFT | LEFT(string, [number_of_characters]) | Returns a substring from the beginning of a specified string | Google Text | |
| LEFTB | LEFTB(string, num_of_bytes) | Returns the left portion of a string up to a certain number of bytes. Learn more. | Google Text | |
| LEN | LEN(text) | Returns the length of a string | Google Text | |
| LENB | LENB(string) | Returns the length of a string in bytes.” Learn more. | Google Text | |
| LOWER | LOWER(text) | Converts a specified string to lowercase | Google Text | LOWER |
| MID | MID(string, starting_at, extract_length) | Returns a segment of a string | Google Text | MID |
| MIDB | MIDB(string) | Returns a section of a string starting at a given character and up to a specified number of bytes. Learn more. | Google Text | |
| PROPER | PROPER(text_to_capitalize) | Capitalizes each word in a specified string | Google Text | PROPER |
| REGEXEXTRACT | REGEXEXTRACT(text, regular_expression) | Extracts matching substrings according to a regular expression | Google Text | |
| REGEXMATCH | REGEXMATCH(text, regular_expression) | Whether a piece of text matches a regular expression | Google Text | |
| REGEXREPLACE | REGEXREPLACE(text, regular_expression, replacement) | Replaces part of a text string with a different text string using regular expressions | Google Text | |
| REPLACE | REPLACE(text, position, length, new_text) | Replaces part of a text string with a different text string | Google Text | REPLACE |
| REPLACEB | REPLACEB(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. | Google Text | |
| REPT | REPT(text_to_repeat, number_of_repetitions) | Returns specified text repeated a number of times | Google Text | REPT |
| RIGHT | RIGHT(string, [number_of_characters]) | Returns a substring from the end of a specified string | Google Text | |
| RIGHTB | RIGHTB(string, num_of_bytes) | Returns the right portion of a string up to a certain number of bytes. Learn more. | Google Text | |
| ROMAN | ROMAN(number, [rule_relaxation]) | Formats a number in Roman numerals | Google Text | ROMAN |
| SEARCH | SEARCH(search_for, text_to_search, [starting_at]) | Returns the position at which a string is first found within text | Google Text | SEARCH |
| SEARCHB | SEARCHB(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 | Google Text | |
| SPLIT | SPLIT(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 | Google Text | |
| SUBSTITUTE | SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number]) | Replaces existing text with new text in a string | Google Text | SUBSTITUTE |
| T | T(value) | Returns string arguments as text | Google Text | T |
| TEXT | TEXT(number, format) | Converts a number into text according to a specified format | Google Text | TEXT |
| TEXTJOIN | TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) | Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts | Google Text | TEXTJOIN |
| TRIM | TRIM(text) | Removes leading and trailing spaces in a specified string | Google Text | TRIM |
| UNICHAR | UNICHAR(number) | Returns the Unicode character for a number. Learn more. | Google Text | UNICHAR |
| UNICODE | UNICODE(text) | Returns the decimal Unicode value of the first character of the text | Google Text | UNICODE |
| UPPER | UPPER(text) | Converts a specified string to uppercase | Google Text | UPPER |
| VALUE | VALUE(text) | Converts a string in any of the date, time or number formats that Google Sheets understands into a number | Google Text | VALUE |
| ENCODEURL | ENCODEURL(text) | Encodes a string of text for the purpose of using in a URL query. Learn more. | Google Web | ENCODEURL |
| HYPERLINK | HYPERLINK(url, [link_label]) | Creates a hyperlink inside a cell | Google Web | HYPERLINK |
| IMPORTDATA | IMPORTDATA(url) | Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format | Google Web | |
| IMPORTFEED | IMPORTFEED(url, [query], [headers], [num_items]) | Imports a RSS or ATOM feed | Google Web | |
| IMPORTHTML | IMPORTHTML(url, query, index) | Imports data from a table or list within an HTML page | Google Web | |
| IMPORTRANGE | IMPORTRANGE(spreadsheet_url, range_string) | Imports a range of cells from a specified spreadsheet | Google Web | |
| IMPORTXML | IMPORTXML(url, xpath_query) | Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds | Google Web | |
| ISURL | ISURL(value) | Checks whether a value is a valid URL | Google Web |