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.

EngineeringBITAND(value1, value2)

BITAND

Bitwise boolean AND of two numbers.

EngineeringBITLSHIFT(value, shift_amount)

BITLSHIFT

Shifts the bits of the input a certain number of places to the left.

EngineeringBITOR(value1, value2)

BITOR

Bitwise boolean OR of 2 numbers.

EngineeringBITRSHIFT(value, shift_amount)

BITRSHIFT

Shifts the bits of the input a certain number of places to the right.

EngineeringBITXOR(value1, value2)

BITXOR

Bitwise XOR (exclusive OR) of 2 numbers.

ArrayBYCOL(array_or_range, LAMBDA)

BYCOL

Groups an array by columns by application of a LAMBDA function to each column.

ArrayBYROW(array_or_range, LAMBDA)

BYROW

Groups an array by rows by application of a LAMBDA function to each row.

MathCEILING(value, [factor])

CEILING

Rounds a number up to the nearest integer multiple of specified significance.

MathCEILING.MATH(number, [significance], [mode])

CEILING.MATH

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.

MathCEILING.PRECISE(number, [significance])

CEILING.PRECISE

Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up.

InfoCELL(info_type, reference)

CELL

Returns the requested information about the specified cell.

TextCHAR(table_number)

CHAR

Convert a number into a character according to the current Unicode table.

StatisticalCHIDIST(x, degrees_freedom)

CHIDIST

Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.

StatisticalCHIINV(probability, degrees_freedom)

CHIINV

Calculates the inverse of the right-tailed chi-squared distribution.

StatisticalCHISQ.DIST(x, degrees_freedom, cumulative)

CHISQ.DIST

Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.

StatisticalCHISQ.DIST.RT(x, degrees_freedom)

CHISQ.DIST.RT

Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.

StatisticalCHISQ.INV(probability, degrees_freedom)

CHISQ.INV

Calculates the inverse of the left-tailed chi-squared distribution.

StatisticalCHISQ.INV.RT(probability, degrees_freedom)

CHISQ.INV.RT

Calculates the inverse of the right-tailed chi-squared distribution.

StatisticalCHISQ.TEST(observed_range, expected_range)

CHISQ.TEST

See CHITEST

StatisticalCHITEST(observed_range, expected_range)

CHITEST

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.

LookupCHOOSE(index, choice1, [choice2, ...])

CHOOSE

Returns an element from a list of choices based on index.

ArrayCHOOSECOLS(array, col_num1, [col_num2])

CHOOSECOLS

Creates a new array from the selected columns in the existing range.

ArrayCHOOSEROWS(array, row_num1, [row_num2])

CHOOSEROWS

Creates a new array from the selected rows in the existing range.

TextCLEAN(text)

CLEAN

Returns the text with the non-printable ASCII characters removed.

TextCODE(string)

CODE

Returns the numeric Unicode map value of the first character in the string provided.

LookupCOLUMN([cell_reference])

COLUMN

Returns the column number of a specified cell, with `A=1`.

LookupCOLUMNS(range)

COLUMNS

Returns the number of columns in a specified array or range.

MathCOMBIN(n, k)

COMBIN

Returns the number of ways to choose some number of objects from a pool of a given size of objects.

MathCOMBINA(n, k)

COMBINA

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.

EngineeringCOMPLEX(real_part, imaginary_part, [suffix])

COMPLEX

Creates a complex number given real and imaginary coefficients.

OperatorCONCAT(value1, value2)

CONCAT

Returns the concatenation of two values. Equivalent to the `&` operator.

TextCONCATENATE(string1, [string2, ...])

CONCATENATE

Appends strings to one another.

StatisticalCONFIDENCE(alpha, standard_deviation, pop_size)

CONFIDENCE

See CONFIDENCE.NORM

StatisticalCONFIDENCE.NORM(alpha, standard_deviation, pop_size)

CONFIDENCE.NORM

Calculates the width of half the confidence interval for a normal distribution.

StatisticalCONFIDENCE.T(alpha, standard_deviation, size)

CONFIDENCE.T

Calculates the width of half the confidence interval for a Student’s t-distribution.

ParserCONVERT(value, start_unit, end_unit)

CONVERT

Converts a numeric value to a different unit of measure.

StatisticalCORREL(data_y, data_x)

CORREL

Calculates r, the Pearson product-moment correlation coefficient of a dataset.

MathCOS(angle)

COS

Returns the cosine of an angle provided in radians.

MathCOSH(value)

COSH

Returns the hyperbolic cosine of any real number.

MathCOT(angle)

COT

Cotangent of an angle provided in radians.

MathCOTH(value)

COTH

Returns the hyperbolic cotangent of any real number.

StatisticalCOUNT(value1, [value2, ...])

COUNT

Returns a count of the number of numeric values in a dataset.

StatisticalCOUNTA(value1, [value2, ...])

COUNTA

Returns a count of the number of values in a dataset.

MathCOUNTBLANK(range)

COUNTBLANK

Returns the number of empty cells in a given range.

MathCOUNTIF(range, criterion)

COUNTIF

Returns a conditional count across a range.

MathCOUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])

COUNTIFS

Returns the count of a range depending on multiple criteria.

MathCOUNTUNIQUE(value1, [value2, ...])

COUNTUNIQUE

Counts the number of unique values in a list of specified values and ranges.

FinancialCOUPDAYBS(settlement, maturity, frequency, [day_count_convention])

COUPDAYBS

Calculates the number of days from the first coupon, or interest payment, until settlement.

FinancialCOUPDAYS(settlement, maturity, frequency, [day_count_convention])

COUPDAYS

Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.

FinancialCOUPDAYSNC(settlement, maturity, frequency, [day_count_convention])

COUPDAYSNC

Calculates the number of days from the settlement date until the next coupon, or interest payment.

FinancialCOUPNCD(settlement, maturity, frequency, [day_count_convention])

COUPNCD

Calculates next coupon, or interest payment, date after the settlement date.

FinancialCOUPNUM(settlement, maturity, frequency, [day_count_convention])

COUPNUM

Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.

FinancialCOUPPCD(settlement, maturity, frequency, [day_count_convention])

COUPPCD

Calculates last coupon, or interest payment, date before the settlement date.

StatisticalCOVAR(data_y, data_x)

COVAR

Calculates the covariance of a dataset.

StatisticalCOVARIANCE.P(data_y, data_x)

COVARIANCE.P

See COVAR

StatisticalCOVARIANCE.S(data_y, data_x)

COVARIANCE.S

Calculates the covariance of a dataset, where the dataset is a sample of the total population.

StatisticalCRITBINOM(num_trials, prob_success, target_prob)

CRITBINOM

Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.

MathCSC(angle)

CSC

Returns the cosecant of an angle provided in radians.

MathCSCH(value)

CSCH

The CSCH function returns the hyperbolic cosecant of any real number.

FinancialCUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

CUMIPMT

Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

FinancialCUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

CUMPRINC

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.

DateDATE(year, month, day)

DATE

Converts a provided year, month, and day into a date.

DateDATEDIF(start_date, end_date, unit)

DATEDIF

Calculates the number of days, months, or years between two dates.

DateDATEVALUE(date_string)

DATEVALUE

Converts a provided date string in a known format to a date value.

DatabaseDAVERAGE(database, field, criteria)

DAVERAGE

Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.

DateDAY(date)

DAY

Returns the day of the month that a specific date falls on, in numeric format.

DateDAYS(end_date, start_date)

DAYS

Returns the number of days between two dates.

DateDAYS360(start_date, end_date, [method])

DAYS360

Returns the difference between two days based on the 360 day year used in some financial interest calculations.

FinancialDB(cost, salvage, life, period, [month])

DB

Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.

DatabaseDCOUNT(database, field, criteria)

DCOUNT

Counts numeric values selected from a database table-like array or range using a SQL-like query.

DatabaseDCOUNTA(database, field, criteria)

DCOUNTA

Counts values, including text, selected from a database table-like array or range using a SQL-like query.

FinancialDDB(cost, salvage, life, period, [factor])

DDB

Calculates the depreciation of an asset for a specified period using the double-declining balance method.

EngineeringDEC2BIN(decimal_number, [significant_digits])

DEC2BIN

Converts a decimal number to signed binary format.

EngineeringDEC2HEX(decimal_number, [significant_digits])

DEC2HEX

Converts a decimal number to signed hexadecimal format.

EngineeringDEC2OCT(decimal_number, [significant_digits])

DEC2OCT

Converts a decimal number to signed octal format.

MathDECIMAL(value, base)

DECIMAL

The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal).

MathDEGREES(angle)

DEGREES

Converts an angle value in radians to degrees.

EngineeringDELTA(number1, [number2])

DELTA

Compare two numeric values, returning 1 if they're equal.

GoogleDETECTLANGUAGE(text_or_range)

DETECTLANGUAGE

Identifies the language used in text within the specified range.

StatisticalDEVSQ(value1, value2)

DEVSQ

Calculates the sum of squares of deviations based on a sample.

DatabaseDGET(database, field, criteria)

DGET

Returns a single value from a database table-like array or range using a SQL-like query.

FinancialDISC(settlement, maturity, price, redemption, [day_count_convention])

DISC

Calculates the discount rate of a security based on price.

OperatorDIVIDE(dividend, divisor)

DIVIDE

Returns one number divided by another. Equivalent to the `/` operator.

DatabaseDMAX(database, field, criteria)

DMAX

Returns the maximum value selected from a database table-like array or range using a SQL-like query.

DatabaseDMIN(database, field, criteria)

DMIN

Returns the minimum value selected from a database table-like array or range using a SQL-like query.

TextDOLLAR(number, [number_of_places])

DOLLAR

Formats a number into the locale-specific currency format.

FinancialDOLLARDE(fractional_price, unit)

DOLLARDE

Converts a price quotation given as a decimal fraction into a decimal value.

FinancialDOLLARFR(decimal_price, unit)

DOLLARFR

Converts a price quotation given as a decimal value into a decimal fraction.

DatabaseDPRODUCT(database, field, criteria)

DPRODUCT

Returns the product of values selected from a database table-like array or range using a SQL-like query.

DatabaseDSTDEV(database, field, criteria)

DSTDEV

Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.

DatabaseDSTDEVP(database, field, criteria)

DSTDEVP

Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.

DatabaseDSUM(database, field, criteria)

DSUM

Returns the sum of values selected from a database table-like array or range using a SQL-like query.

FinancialDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .

DURATION

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.

DatabaseDVAR(database, field, criteria)

DVAR

Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.

DatabaseDVARP(database, field, criteria)

DVARP

Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.

DateEDATE(start_date, months)

EDATE

Returns a date a specified number of months before or after another date.

FinancialEFFECT(nominal_rate, periods_per_year)

EFFECT

Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.

WebENCODEURL(text)

ENCODEURL

Encodes a string of text for the purpose of using in a URL query.

DateEOMONTH(start_date, months)

EOMONTH

Returns a date representing the last day of a month which falls a specified number of months before or after another date.

DateEPOCHTODATE(timestamp, [unit])

EPOCHTODATE

Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.

OperatorEQ(value1, value2)

EQ

Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator.

EngineeringERF(lower_bound, [upper_bound])

ERF

The ERF function returns the integral of the Gauss error function over an interval of values.

EngineeringERF.PRECISE(lower_bound, [upper_bound])

ERF.PRECISE

See ERF

MathERFC(z)

ERFC

Returns the complementary Gauss error function of a value.

MathERFC.PRECISE(z)

ERFC.PRECISE

See ERFC

InfoERROR.TYPE(reference)

ERROR.TYPE

Returns a number corresponding to the error value in a different cell.

MathEVEN(value)

EVEN

Rounds a number up to the nearest even integer.

TextEXACT(string1, string2)

EXACT

Tests whether two strings are identical.

MathEXP(exponent)

EXP

Returns Euler's number, e (~2.718) raised to a power.

StatisticalEXPON.DIST(x, LAMBDA, cumulative)

EXPON.DIST

Returns the value of the exponential distribution function with a specified LAMBDA at a specified value.

StatisticalEXPONDIST(x, LAMBDA, cumulative)

EXPONDIST

See EXPON.DIST

StatisticalF.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)

F.DIST

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.

StatisticalF.DIST.RT(x, degrees_freedom1, degrees_freedom2)

F.DIST.RT

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.

StatisticalF.INV(probability, degrees_freedom1, degrees_freedom2)

F.INV

Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.

StatisticalF.INV.RT(probability, degrees_freedom1, degrees_freedom2)

F.INV.RT

Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.

StatisticalF.TEST(range1, range2)

F.TEST

See FTEST.

MathFACT(value)

FACT

Returns the factorial of a number.

MathFACTDOUBLE(value)

FACTDOUBLE

Returns the "double factorial" of a number.

LogicalFALSE()

FALSE

Returns the logical value `FALSE`.

StatisticalFDIST(x, degrees_freedom1, degrees_freedom2)

FDIST

See F.DIST.RT.

FilterFILTER(range, condition1, [condition2])

FILTER

Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.

TextFIND(search_for, text_to_search, [starting_at])

FIND

Returns the position at which a string is first found within text.

TextFINDB(search_for, text_to_search, [starting_at])

FINDB

Returns the position at which a string is first found within text counting each double-character as 2.

StatisticalFINV(probability, degrees_freedom1, degrees_freedom2)

FINV

See F.INV.RT

StatisticalFISHER(value)

FISHER

Returns the Fisher transformation of a specified value.

StatisticalFISHERINV(value)

FISHERINV

Returns the inverse Fisher transformation of a specified value.

TextFIXED(number, [number_of_places], [suppress_separator])

FIXED

Formats a number with a fixed number of decimal places.

ArrayFLATTEN(range1,[range2,...])

FLATTEN

Flattens all the values from one or more ranges into a single column.

MathFLOOR(value, [factor])

FLOOR

Rounds a number down to the nearest integer multiple of specified significance.

MathFLOOR.MATH(number, [significance], [mode])

FLOOR.MATH

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.

MathFLOOR.PRECISE(number, [significance])

FLOOR.PRECISE

The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance.

StatisticalFORECAST(x, data_y, data_x)

FORECAST

Calculates the expected y-value for a specified x based on a linear regression of a dataset.

StatisticalFORECAST.LINEAR(x, data_y, data_x)

FORECAST.LINEAR

See FORECAST

LookupFORMULATEXT(cell)

FORMULATEXT

Returns the formula as a string.

ArrayFREQUENCY(data, classes)

FREQUENCY

Calculates the frequency distribution of a one-column array into specified classes.

StatisticalFTEST(range1, range2)

FTEST

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.

FinancialFV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])

FV

Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

FinancialFVSCHEDULE(principal, rate_schedule)

FVSCHEDULE

Calculates the future value of some principal based on a specified series of potentially varying interest rates.

StatisticalGAMMA(number)

GAMMA

Returns the Gamma function evaluated at the specified value.

StatisticalGAMMA.DIST(x, alpha, beta, cumulative)

GAMMA.DIST

Calculates the gamma distribution, a two-parameter continuous probability distribution.

StatisticalGAMMA.INV(probability, alpha, beta)

GAMMA.INV

The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters.

StatisticalGAMMADIST(x, alpha, beta, cumulative)

GAMMADIST

See GAMMA.DIST

StatisticalGAMMAINV(probability, alpha, beta)

GAMMAINV

See GAMMA.INV.

MathGAMMALN(value)

GAMMALN

Returns the the logarithm of a specified Gamma function, base e (Euler's number).

MathGAMMALN.PRECISE(value)

GAMMALN.PRECISE

See GAMMALN

StatisticalGAUSS(z)

GAUSS

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.

MathGCD(value1, value2)

GCD

Returns the greatest common divisor of one or more integers.

StatisticalGEOMEAN(value1, value2)

GEOMEAN

Calculates the geometric mean of a dataset.

EngineeringGESTEP(value, [step])

GESTEP

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.

LookupGETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]

GETPIVOTDATA

Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.

GoogleGOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

GOOGLEFINANCE

Fetches current or historical securities information from Google Finance.

GoogleGOOGLETRANSLATE(text, [source_language], [target_language])

GOOGLETRANSLATE

Translates text from one language into another Learn more

ArrayGROWTH(known_data_y, [known_data_x], [new_data_x], [b])

GROWTH

Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values.

OperatorGT(value1, value2)

GT

Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator.

OperatorGTE(value1, value2)

GTE

Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator.

StatisticalHARMEAN(value1, value2)

HARMEAN

Calculates the harmonic mean of a dataset.

EngineeringHEX2BIN(signed_hexadecimal_number, [significant_digits])

HEX2BIN

Converts a signed hexadecimal number to signed binary format.

EngineeringHEX2DEC(signed_hexadecimal_number)

HEX2DEC

Converts a signed hexadecimal number to decimal format.

EngineeringHEX2OCT(signed_hexadecimal_number, significant_digits)

HEX2OCT

Converts a signed hexadecimal number to signed octal format.

LookupHLOOKUP(search_key, range, index, [is_sorted])

HLOOKUP

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.

DateHOUR(time)

HOUR

Returns the hour component of a specific time, in numeric format.

ArrayHSTACK(range1; [range2, …])

HSTACK

Appends ranges horizontally and in sequence to return a larger array.

WebHYPERLINK(url, [link_label])

HYPERLINK

Creates a hyperlink inside a cell.

StatisticalHYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)

HYPGEOM.DIST

See HYPGEOMDIST

StatisticalHYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)

HYPGEOMDIST

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.

LogicalIF(logical_expression, value_if_true, value_if_false)

IF

Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.

LogicalIFERROR(value, [value_if_error])

IFERROR

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.

LogicalIFNA(value, value_if_na)

IFNA

Evaluates a value. If the value is an #N/A error, returns the specified value.

LogicalIFS(condition1, value1, [condition2, value2], …)

IFS

Evaluates multiple conditions and returns a value that corresponds to the first true condition.

EngineeringIMABS(number)

IMABS

Returns absolute value of a complex number.

GoogleIMAGE(url, [mode], [height], [width])

IMAGE

Inserts an image into a cell.

EngineeringIMAGINARY(complex_number)

IMAGINARY

Returns the imaginary coefficient of a complex number.

EngineeringIMARGUMENT(number)

IMARGUMENT

The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians.

EngineeringIMCONJUGATE(number)

IMCONJUGATE

Returns the complex conjugate of a number.

EngineeringIMCOS(number)

IMCOS

The IMCOS function returns the cosine of the given complex number.

EngineeringIMCOSH(number)

IMCOSH

Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)." Learn more.

EngineeringIMCOT(number)

IMCOT

Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)." Learn more.

EngineeringIMCOTH(number)

IMCOTH

Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)." Learn more.

EngineeringIMCSC(number)

IMCSC

Returns the cosecant of the given complex number.

EngineeringIMCSCH(number)

IMCSCH

Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)." Learn more.

EngineeringIMDIV(dividend, divisor)

IMDIV

Returns one complex number divided by another.

EngineeringIMEXP(exponent)

IMEXP

Returns Euler's number, e (~2.718) raised to a complex power.

MathIMLN(complex_value)

IMLN

Returns the logarithm of a complex number, base e (Euler's number).

EngineeringIMLOG(value, base)

IMLOG

Returns the logarithm of a complex number for a specified base.

EngineeringIMLOG10(value)

IMLOG10

Returns the logarithm of a complex number with base 10.

EngineeringIMLOG2(value)

IMLOG2

Returns the logarithm of a complex number with base 2.

WebIMPORTDATA(url)

IMPORTDATA

Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

WebIMPORTFEED(url, [query], [headers], [num_items])

IMPORTFEED

Imports a RSS or ATOM feed.

WebIMPORTHTML(url, query, index)

IMPORTHTML

Imports data from a table or list within an HTML page.

WebIMPORTRANGE(spreadsheet_url, range_string)

IMPORTRANGE

Imports a range of cells from a specified spreadsheet.

WebIMPORTXML(url, xpath_query)

IMPORTXML

Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

MathIMPOWER(complex_base, exponent)

IMPOWER

Returns a complex number raised to a power.

EngineeringIMPRODUCT(factor1, [factor2, ...])

IMPRODUCT

Returns the result of multiplying a series of complex numbers together.

EngineeringIMREAL(complex_number)

IMREAL

Returns the real coefficient of a complex number.

EngineeringIMSEC(number)

IMSEC

Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)." Learn more.

EngineeringIMSECH(number)

IMSECH

Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)." Learn more.

EngineeringIMSIN (number)

IMSIN

Returns the sine of the given complex number.

EngineeringIMSINH(number)

IMSINH

Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi)." Learn more.

MathIMSQRT(complex_number)

IMSQRT

Computes the square root of a complex number.

EngineeringIMSUB(first_number, second_number)

IMSUB

Returns the difference between two complex numbers.

EngineeringIMSUM(value1, [value2, ...])

IMSUM

Returns the sum of a series of complex numbers.

EngineeringIMTAN(number)

IMTAN

Returns the tangent of the given complex number.

EngineeringIMTANH(number)

IMTANH

Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)." Learn more.

LookupINDEX(reference, [row], [column])

INDEX

Returns the content of a cell, specified by row and column offset.

LookupINDIRECT(cell_reference_as_string, [is_A1_notation])

INDIRECT

Returns a cell reference specified by a string.

MathINT(value)

INT

Rounds a number down to the nearest integer that is less than or equal to it.

StatisticalINTERCEPT(data_y, data_x)

INTERCEPT

Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).

FinancialINTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])

INTRATE

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.

FinancialIPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

IPMT

Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.

FinancialIRR(cashflow_amounts, [rate_guess])

IRR

Calculates the internal rate of return on an investment based on a series of periodic cash flows.

OperatorISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)

ISBETWEEN

Checks whether a provided number is between two other numbers either inclusively or exclusively.

InfoISBLANK(value)

ISBLANK

Checks whether the referenced cell is empty.

InfoISDATE(value)

ISDATE

Returns whether a value is a date.

InfoISEMAIL(value)

ISEMAIL

Checks whether a value is a valid email address.

InfoISERR(value)

ISERR

Checks whether a value is an error other than `#N/A`.

InfoISERROR(value)

ISERROR

Checks whether a value is an error.

MathISEVEN(value)

ISEVEN

Checks whether the provided value is even.

InfoISFORMULA(cell)

ISFORMULA

Checks whether a formula is in the referenced cell.

InfoISLOGICAL(value)

ISLOGICAL

Checks whether a value is `TRUE` or `FALSE`.

InfoISNA(value)

ISNA

Checks whether a value is the error `#N/A`.

InfoISNONTEXT(value)

ISNONTEXT

Checks whether a value is non-textual.

InfoISNUMBER(value)

ISNUMBER

Checks whether a value is a number.

MathISO.CEILING(number, [significance])

ISO.CEILING

See CEILING.PRECISE

MathISODD(value)

ISODD

Checks whether the provided value is odd.

DateISOWEEKNUM(date)

ISOWEEKNUM

Returns the number of the ISO week of the year where the provided date falls.

FinancialISPMT(rate, period, number_of_periods, present_value)

ISPMT

The ISPMT function calculates the interest paid during a particular period of an investment.

InfoISREF(value)

ISREF

Checks whether a value is a valid cell reference.

InfoISTEXT(value)

ISTEXT

Checks whether a value is text.

WebISURL(value)

ISURL

Checks whether a value is a valid URL.

TextJOIN(delimiter, value_or_array1, [value_or_array2, ...])

JOIN

Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.

StatisticalKURT(value1, value2)

KURT

Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.

LogicalLAMBDA(name, formula_expression)

LAMBDA

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.

StatisticalLARGE(data, n)

LARGE

Returns the nth largest element from a data set, where n is user-defined.

MathLCM(value1, value2)

LCM

Returns the least common multiple of one or more integers.

TextLEFT(string, [number_of_characters])

LEFT

Returns a substring from the beginning of a specified string.

TextLEFTB(string, num_of_bytes)

LEFTB

Returns the left portion of a string up to a certain number of bytes.

TextLEN(text)

LEN

Returns the length of a string.

TextLENB(string)

LENB

Returns the length of a string in bytes." Learn more.

LogicalLET(name1, value_expression1, [name2, …], [value_expression2, …], formula_expression )

LET

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.

ArrayLINEST(known_data_y, [known_data_x], [calculate_b], [verbose])

LINEST

Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method.

MathLN(value)

LN

Returns the the logarithm of a number, base e (Euler's number).

MathLOG(value, base)

LOG

Returns the the logarithm of a number given a base.

MathLOG10(value)

LOG10

Returns the the logarithm of a number, base 10.

ArrayLOGEST(known_data_y, [known_data_x], [b], [verbose])

LOGEST

Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve.

StatisticalLOGINV(x, mean, standard_deviation)

LOGINV

Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value.

StatisticalLOGNORM.DIST(x, mean, standard_deviation)

LOGNORM.DIST

See LOGNORMDIST

StatisticalLOGNORM.INV(x, mean, standard_deviation)

LOGNORM.INV

See LOGINV

StatisticalLOGNORMDIST(x, mean, standard_deviation)

LOGNORMDIST

Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.

LookupLOOKUP(search_key, search_range|search_result_array, [result_range])

LOOKUP

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.

TextLOWER(text)

LOWER

Converts a specified string to lowercase.

OperatorLT(value1, value2)

LT

Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator.

OperatorLTE(value1, value2)

LTE

Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator.

ArrayMAKEARRAY(rows, columns, LAMBDA)

MAKEARRAY

Returns an array of specified dimensions with values calculated by application of a LAMBDA function.

ArrayMAP(array1, [array2, ...], LAMBDA)

MAP

Maps each value in the given arrays to a new value by application of a LAMBDA function to each value.

StatisticalMARGINOFERROR(range, confidence)

MARGINOFERROR

Calculates the amount of random sampling error given a range of values and a confidence level.

LookupMATCH(search_key, range, [search_type])

MATCH

Returns the relative position of an item in a range that matches a specified value.

StatisticalMAX(value1, [value2, ...])

MAX

Returns the maximum value in a numeric dataset.

StatisticalMAXA(value1, value2)

MAXA

Returns the maximum numeric value in a dataset.

StatisticalMAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)

MAXIFS

Returns the maximum value in a range of cells, filtered by a set of criteria.

ArrayMDETERM(square_matrix)

MDETERM

Returns the matrix determinant of a square matrix specified as an array or range.

FinancialMDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])

MDURATION

Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.

StatisticalMEDIAN(value1, [value2, ...])

MEDIAN

Returns the median value in a numeric dataset.

TextMID(string, starting_at, extract_length)

MID

Returns a segment of a string.

TextMIDB(string)

MIDB

Returns a section of a string starting at a given character and up to a specified number of bytes.

StatisticalMIN(value1, [value2, ...])

MIN

Returns the minimum value in a numeric dataset.

StatisticalMINA(value1, value2)

MINA

Returns the minimum numeric value in a dataset.

StatisticalMINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)

MINIFS

Returns the minimum value in a range of cells, filtered by a set of criteria.

OperatorMINUS(value1, value2)

MINUS

Returns the difference of two numbers. Equivalent to the `-` operator.

DateMINUTE(time)

MINUTE

Returns the minute component of a specific time, in numeric format.

ArrayMINVERSE(square_matrix)

MINVERSE

Returns the multiplicative inverse of a square matrix specified as an array or range.

FinancialMIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)

MIRR

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.

ArrayMMULT(matrix1, matrix2)

MMULT

Calculates the matrix product of two matrices specified as arrays or ranges.

MathMOD(dividend, divisor)

MOD

Returns the result of the modulo operator, the remainder after a division operation.

StatisticalMODE(value1, [value2, ...])

MODE

Returns the most commonly occurring value in a dataset.

StatisticalMODE.MULT(value1, value2)

MODE.MULT

Returns the most commonly occurring values in a dataset.

StatisticalMODE.SNGL(value1, [value2, ...])

MODE.SNGL

See MODE

DateMONTH(date)

MONTH

Returns the month of the year a specific date falls in, in numeric format.

MathMROUND(value, factor)

MROUND

Rounds one number to the nearest integer multiple of another.

MathMULTINOMIAL(value1, value2)

MULTINOMIAL

Returns the factorial of the sum of values divided by the product of the values' factorials.

OperatorMULTIPLY(factor1, factor2)

MULTIPLY

Returns the product of two numbers. Equivalent to the `*` operator.

MathMUNIT(dimension)

MUNIT

Returns a unit matrix of size dimension x dimension.

InfoN(value)

N

Returns the argument provided as a number.

InfoNA()

NA

Returns the "value not available" error, `#N/A`.

OperatorNE(value1, value2)

NE

Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator.

StatisticalNEGBINOM.DIST(num_failures, num_successes, prob_success)

NEGBINOM.DIST

See NEGBINOMDIST

StatisticalNEGBINOMDIST(num_failures, num_successes, prob_success)

NEGBINOMDIST

Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.

DateNETWORKDAYS(start_date, end_date, [holidays])

NETWORKDAYS

Returns the number of net working days between two provided days.

DateNETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

NETWORKDAYS.INTL

Returns the number of net working days between two provided days excluding specified weekend days and holidays.

FinancialNOMINAL(effective_rate, periods_per_year)

NOMINAL

Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.

StatisticalNORM.DIST(x, mean, standard_deviation, cumulative)

NORM.DIST

See NORMDIST

StatisticalNORM.INV(x, mean, standard_deviation)

NORM.INV

See NORMINV

StatisticalNORM.S.DIST(x)

NORM.S.DIST

See NORMSDIST

StatisticalNORM.S.INV(x)

NORM.S.INV

See NORMSINV

StatisticalNORMDIST(x, mean, standard_deviation, cumulative)

NORMDIST

Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.

StatisticalNORMINV(x, mean, standard_deviation)

NORMINV

Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.

StatisticalNORMSDIST(x)

NORMSDIST

Returns the value of the standard normal cumulative distribution function for a specified value.

StatisticalNORMSINV(x)

NORMSINV

Returns the value of the inverse standard normal distribution function for a specified value.

LogicalNOT(logical_expression)

NOT

Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.

DateNOW()

NOW

Returns the current date and time as a date value.

FinancialNPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])

NPER

Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

FinancialNPV(discount, cashflow1, [cashflow2, ...])

NPV

Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.

EngineeringOCT2BIN(signed_octal_number, [significant_digits])

OCT2BIN

Converts a signed octal number to signed binary format.

EngineeringOCT2DEC(signed_octal_number)

OCT2DEC

Converts a signed octal number to decimal format.

EngineeringOCT2HEX(signed_octal_number, [significant_digits])

OCT2HEX

Converts a signed octal number to signed hexadecimal format.

MathODD(value)

ODD

Rounds a number up to the nearest odd integer.

LookupOFFSET(cell_reference, offset_rows, offset_columns, [height], [width])

OFFSET

Returns a range reference shifted a specified number of rows and columns from a starting cell reference.

LogicalOR(logical_expression1, [logical_expression2, ...])

OR

Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.

FinancialPDURATION(rate, present_value, future_value)

PDURATION

Returns the number of periods for an investment to reach a specific value at a given rate.

StatisticalPEARSON(data_y, data_x)

PEARSON

Calculates r, the Pearson product-moment correlation coefficient of a dataset.

StatisticalPERCENTILE(data, percentile)

PERCENTILE

Returns the value at a given percentile of a dataset.

StatisticalPERCENTILE.EXC(data, percentile)

PERCENTILE.EXC

Returns the value at a given percentile of a dataset, exclusive of 0 and 1.

StatisticalPERCENTILE.INC(data, percentile)

PERCENTILE.INC

See PERCENTILE

StatisticalPERCENTRANK(data, value, [significant_digits])

PERCENTRANK

Returns the percentage rank (percentile) of a specified value in a dataset.

StatisticalPERCENTRANK.EXC(data, value, [significant_digits])

PERCENTRANK.EXC

Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.

StatisticalPERCENTRANK.INC(data, value, [significant_digits])

PERCENTRANK.INC

Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.

StatisticalPERMUT(n, k)

PERMUT

Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.

StatisticalPERMUTATIONA(number, number_chosen)

PERMUTATIONA

Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects.

StatisticalPHI(x)

PHI

The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1.

MathPI()

PI

Returns the value of Pi to 14 decimal places.

FinancialPMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])

PMT

Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.

StatisticalPOISSON(x, mean, cumulative)

POISSON

See POISSON.DIST

StatisticalPOISSON.DIST(x, mean, [cumulative])

POISSON.DIST

Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.

OperatorPOW(base, exponent)

POW

Returns a number raised to a power.

MathPOWER(base, exponent)

POWER

Returns a number raised to a power.

FinancialPPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

PPMT

Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.

FinancialPRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])

PRICE

Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.

FinancialPRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])

PRICEDISC

Calculates the price of a discount (non-interest-bearing) security, based on expected yield.

FinancialPRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])

PRICEMAT

Calculates the price of a security paying interest at maturity, based on expected yield.

StatisticalPROB(data, probabilities, low_limit, [high_limit])

PROB

Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits.

MathPRODUCT(factor1, [factor2, ...])

PRODUCT

Returns the result of multiplying a series of numbers together.

TextPROPER(text_to_capitalize)

PROPER

Capitalizes each word in a specified string.

FinancialPV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])

PV

Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

StatisticalQUARTILE(data, quartile_number)

QUARTILE

Returns a value nearest to a specified quartile of a dataset.

StatisticalQUARTILE.EXC(data, quartile_number)

QUARTILE.EXC

Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4.

StatisticalQUARTILE.INC(data, quartile_number)

QUARTILE.INC

See QUARTILE

GoogleQUERY(data, query, [headers])

QUERY

Runs a Google Visualization API Query Language query across data.

MathQUOTIENT(dividend, divisor)

QUOTIENT

Returns one number divided by another.

MathRADIANS(angle)

RADIANS

Converts an angle value in degrees to radians.

MathRAND()

RAND

Returns a random number between 0 inclusive and 1 exclusive.

MathRANDARRAY(rows, columns)

RANDARRAY

Generates an array of random numbers between 0 and 1.

MathRANDBETWEEN(low, high)

RANDBETWEEN

Returns a uniformly random integer between two values, inclusive.

StatisticalRANK(value, data, [is_ascending])

RANK

Returns the rank of a specified value in a dataset.

StatisticalRANK.AVG(value, data, [is_ascending])

RANK.AVG

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.

StatisticalRANK.EQ(value, data, [is_ascending])

RANK.EQ

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.

FinancialRATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])

RATE

Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate.

FinancialRECEIVED(settlement, maturity, investment, discount, [day_count_convention])

RECEIVED

Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date.

ArrayREDUCE(initial_value, array_or_range, LAMBDA)

REDUCE

Reduces an array to an accumulated result by application of a LAMBDA function to each value.

TextREGEXEXTRACT(text, regular_expression)

REGEXEXTRACT

Extracts matching substrings according to a regular expression.

TextREGEXMATCH(text, regular_expression)

REGEXMATCH

Whether a piece of text matches a regular expression.

TextREGEXREPLACE(text, regular_expression, replacement)

REGEXREPLACE

Replaces part of a text string with a different text string using regular expressions.

TextREPLACE(text, position, length, new_text)

REPLACE

Replaces part of a text string with a different text string.

TextREPLACEB(text, position, num_bytes, new_text)

REPLACEB

Replaces part of a text string, based on a number of bytes, with a different text string.

TextREPT(text_to_repeat, number_of_repetitions)

REPT

Returns specified text repeated a number of times.

TextRIGHT(string, [number_of_characters])

RIGHT

Returns a substring from the end of a specified string.

TextRIGHTB(string, num_of_bytes)

RIGHTB

Returns the right portion of a string up to a certain number of bytes.

TextROMAN(number, [rule_relaxation])

ROMAN

Formats a number in Roman numerals.

MathROUND(value, [places])

ROUND

Rounds a number to a certain number of decimal places according to standard rules.

MathROUNDDOWN(value, [places])

ROUNDDOWN

Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

MathROUNDUP(value, [places])

ROUNDUP

Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

LookupROW([cell_reference])

ROW

Returns the row number of a specified cell.

LookupROWS(range)

ROWS

Returns the number of rows in a specified array or range.

FinancialRRI(number_of_periods, present_value, future_value)

RRI

Returns the interest rate needed for an investment to reach a specific value within a given number of periods.

StatisticalRSQ(data_y, data_x)

RSQ

Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.

ArraySCAN(initial_value, array_or_range, LAMBDA)

SCAN

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.

TextSEARCH(search_for, text_to_search, [starting_at])

SEARCH

Returns the position at which a string is first found within text.

TextSEARCHB(search_for, text_to_search, [starting_at])

SEARCHB

Returns the position at which a string is first found within text counting each double-character as 2.

MathSEC(angle)

SEC

The SEC function returns the secant of an angle, measured in radians.

MathSECH(value)

SECH

The SECH function returns the hyperbolic secant of an angle.

DateSECOND(time)

SECOND

Returns the second component of a specific time, in numeric format.

MathSEQUENCE(rows, columns, start, step)

SEQUENCE

Returns an array of sequential numbers, such as 1, 2, 3, 4.

MathSERIESSUM(x, n, m, a)

SERIESSUM

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`.

MathSIGN(value)

SIGN

Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.

MathSIN(angle)

SIN

Returns the sine of an angle provided in radians.

MathSINH(value)

SINH

Returns the hyperbolic sine of any real number.

StatisticalSKEW(value1, value2)

SKEW

Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.

StatisticalSKEW.P(value1, value2)

SKEW.P

Calculates the skewness of a dataset that represents the entire population.

FinancialSLN(cost, salvage, life)

SLN

Calculates the depreciation of an asset for one period using the straight-line method.

StatisticalSLOPE(data_y, data_x)

SLOPE

Calculates the slope of the line resulting from linear regression of a dataset.

StatisticalSMALL(data, n)

SMALL

Returns the nth smallest element from a data set, where n is user-defined.

FilterSORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])

SORT

Sorts the rows of a given array or range by the values in one or more columns.

FilterSORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)

SORTN

Returns the first n items in a data set after performing a sort.

GoogleSPARKLINE(data, [options])

SPARKLINE

Creates a miniature chart contained within a single cell.

TextSPLIT(text, delimiter, [split_by_each], [remove_empty_text])

SPLIT

Divides text around a specified character or string, and puts each fragment into a separate cell in the row.

MathSQRT(value)

SQRT

Returns the positive square root of a positive number.

MathSQRTPI(value)

SQRTPI

Returns the positive square root of the product of Pi and the given positive number.

StatisticalSTANDARDIZE(value, mean, standard_deviation)

STANDARDIZE

Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.

StatisticalSTDEV(value1, [value2, ...])

STDEV

Calculates the standard deviation based on a sample.

StatisticalSTDEV.P(value1, [value2, ...])

STDEV.P

See STDEVP

StatisticalSTDEV.S(value1, [value2, ...])

STDEV.S

See STDEV

StatisticalSTDEVA(value1, value2)

STDEVA

Calculates the standard deviation based on a sample, setting text to the value `0`.

StatisticalSTDEVP(value1, value2)

STDEVP

Calculates the standard deviation based on an entire population.

StatisticalSTDEVPA(value1, value2)

STDEVPA

Calculates the standard deviation based on an entire population, setting text to the value `0`.

StatisticalSTEYX(data_y, data_x)

STEYX

Calculates the standard error of the predicted y-value for each x in the regression of a dataset.

TextSUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])

SUBSTITUTE

Replaces existing text with new text in a string.

MathSUBTOTAL(function_code, range1, [range2, ...])

SUBTOTAL

Returns a subtotal for a vertical range of cells using a specified aggregation function.

MathSUM(value1, [value2, ...])

SUM

Returns the sum of a series of numbers and/or cells.

MathSUMIF(range, criterion, [sum_range])

SUMIF

Returns a conditional sum across a range.

MathSUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

SUMIFS

Returns the sum of a range depending on multiple criteria.

ArraySUMPRODUCT(array1, [array2, ...])

SUMPRODUCT

Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.

MathSUMSQ(value1, [value2, ...])

SUMSQ

Returns the sum of the squares of a series of numbers and/or cells.

ArraySUMX2MY2(array_x, array_y)

SUMX2MY2

Calculates the sum of the differences of the squares of values in two arrays.

ArraySUMX2PY2(array_x, array_y)

SUMX2PY2

Calculates the sum of the sums of the squares of values in two arrays.

ArraySUMXMY2(array_x, array_y)

SUMXMY2

Calculates the sum of the squares of differences of values in two arrays.

LogicalSWITCH(expression, case1, value1, [default or case2, value2], …)

SWITCH

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.

FinancialSYD(cost, salvage, life, period)

SYD

Calculates the depreciation of an asset for a specified period using the sum of years digits method.

TextT(value)

T

Returns string arguments as text.

StatisticalT.DIST(x, degrees_freedom, cumulative)

T.DIST

Returns the right tailed Student distribution for a value x.

StatisticalT.DIST.2T(x, degrees_freedom)

T.DIST.2T

Returns the two tailed Student distribution for a value x.

StatisticalT.DIST.RT(x, degrees_freedom)

T.DIST.RT

Returns the right tailed Student distribution for a value x.

StatisticalT.INV(probability, degrees_freedom)

T.INV

Calculates the negative inverse of the one-tailed TDIST function.

StatisticalT.INV.2T(probability, degrees_freedom)

T.INV.2T

Calculates the inverse of the two-tailed TDIST function.

StatisticalT.TEST(range1, range2, tails, type)

T.TEST

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.

MathTAN(angle)

TAN

Returns the tangent of an angle provided in radians.

MathTANH(value)

TANH

Returns the hyperbolic tangent of any real number.

FinancialTBILLEQ(settlement, maturity, discount)

TBILLEQ

Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.

FinancialTBILLPRICE(settlement, maturity, discount)

TBILLPRICE

Calculates the price of a US Treasury Bill based on discount rate.

FinancialTBILLYIELD(settlement, maturity, price)

TBILLYIELD

Calculates the yield of a US Treasury Bill based on price.

StatisticalTDIST(x, degrees_freedom, tails)

TDIST

Calculates the probability for Student's t-distribution with a given input (x).

TextTEXT(number, format)

TEXT

Converts a number into text according to a specified format.

TextTEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

TEXTJOIN

Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.

DateTIME(hour, minute, second)

TIME

Converts a provided hour, minute, and second into a time.

DateTIMEVALUE(time_string)

TIMEVALUE

Returns the fraction of a 24-hour day the time represents.

StatisticalTINV(probability, degrees_freedom)

TINV

See T.INV.2T

ParserTO_DATE(value)

TO_DATE

Converts a provided number to a date.

ParserTO_DOLLARS(value)

TO_DOLLARS

Converts a provided number to a dollar value.

ParserTO_PERCENT(value)

TO_PERCENT

Converts a provided number to a percentage.

ParserTO_PURE_NUMBER(value)

TO_PURE_NUMBER

Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.

ParserTO_TEXT(value)

TO_TEXT

Converts a provided numeric value to a text value.

ArrayTOCOL(array_or_range, [ignore], [scan_by_column])

TOCOL

Transforms an array or range of cells into a single column.

DateTODAY()

TODAY

Returns the current date as a date value.

ArrayTOROW(array_or_range, [ignore], [scan_by_column])

TOROW

Transforms an array or range of cells into a single row.

ArrayTRANSPOSE(array_or_range)

TRANSPOSE

Transposes the rows and columns of an array or range of cells.

ArrayTREND(known_data_y, [known_data_x], [new_data_x], [b])

TREND

Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.

TextTRIM(text)

TRIM

Removes leading and trailing spaces in a specified string.

StatisticalTRIMMEAN(data, exclude_proportion)

TRIMMEAN

Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.

LogicalTRUE()

TRUE

Returns the logical value `TRUE`.

MathTRUNC(value, [places])

TRUNC

Truncates a number to a certain number of significant digits by omitting less significant digits.

StatisticalTTEST(range1, range2, tails, type)

TTEST

See T.TEST.

InfoTYPE(value)

TYPE

Returns a number associated with the type of data passed into the function.

OperatorUMINUS(value)

UMINUS

Returns a number with the sign reversed.

OperatorUNARY_PERCENT(percentage)

UNARY_PERCENT

Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.

TextUNICHAR(number)

UNICHAR

Returns the Unicode character for a number.

TextUNICODE(text)

UNICODE

Returns the decimal Unicode value of the first character of the text.

FilterUNIQUE(range)

UNIQUE

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.

OperatorUNIQUE(range, by_column, exactly_once)

UNIQUE

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.

OperatorUPLUS(value)

UPLUS

Returns a specified number, unchanged.

TextUPPER(text)

UPPER

Converts a specified string to uppercase.

TextVALUE(text)

VALUE

Converts a string in any of the date, time or number formats that Google Sheets understands into a number.

StatisticalVAR(value1, [value2, ...])

VAR

Calculates the variance based on a sample.

StatisticalVAR.P(value1, [value2, ...])

VAR.P

See VARP

StatisticalVAR.S(value1, [value2, ...])

VAR.S

See VAR

StatisticalVARA(value1, value2)

VARA

Calculates an estimate of variance based on a sample, setting text to the value `0`.

StatisticalVARP(value1, value2)

VARP

Calculates the variance based on an entire population.

StatisticalVARPA(value1, value2,...)

VARPA

Calculates the variance based on an entire population, setting text to the value `0`.

FinancialVDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])

VDB

Returns the depreciation of an asset for a particular period (or partial period).

LookupVLOOKUP(search_key, range, index, [is_sorted])

VLOOKUP

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.

ArrayVSTACK(range1; [range2, …])

VSTACK

Appends ranges vertically and in sequence to return a larger array.

DateWEEKDAY(date, [type])

WEEKDAY

Returns a number representing the day of the week of the date provided.

DateWEEKNUM(date, [type])

WEEKNUM

Returns a number representing the week of the year where the provided date falls.

StatisticalWEIBULL(x, shape, scale, cumulative)

WEIBULL

Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.

StatisticalWEIBULL.DIST(x, shape, scale, cumulative)

WEIBULL.DIST

See WEIBULL

DateWORKDAY(start_date, num_days, [holidays])

WORKDAY

Calculates the end date after a specified number of working days.

DateWORKDAY.INTL(start_date, num_days, [weekend], [holidays])

WORKDAY.INTL

Calculates the date after a specified number of workdays excluding specified weekend days and holidays.

ArrayWRAPCOLS(range, wrap_count, [pad_with])

WRAPCOLS

Wraps the provided row or column of cells by columns after a specified number of elements to form a new array.

ArrayWRAPROWS(range, wrap_count, [pad_with])

WRAPROWS

Wraps the provided row or column of cells by rows after a specified number of elements to form a new array.

FinancialXIRR(cashflow_amounts, cashflow_dates, [rate_guess])

XIRR

Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows.

LookupXLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])

XLOOKUP

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.

FinancialXNPV(discount, cashflow_amounts, cashflow_dates)

XNPV

Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate.

LogicalXOR(logical_expression1, [logical_expression2, ...])

XOR

The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise.

DateYEAR(date)

YEAR

Returns the year specified by a given date.

DateYEARFRAC(start_date, end_date, [day_count_convention])

YEARFRAC

Returns the number of years, including fractional years, between two dates using a specified day count convention.

FinancialYIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])

YIELD

Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price.

FinancialYIELDDISC(settlement, maturity, price, redemption, [day_count_convention])

YIELDDISC

Calculates the annual yield of a discount (non-interest-bearing) security, based on price.

FinancialYIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])

YIELDMAT

Calculates the annual yield of a security paying interest at maturity, based on price.

StatisticalZ.TEST(data, value, [standard_deviation])

Z.TEST

Returns the one-tailed P-value of a Z-test with standard distribution.

StatisticalZTEST(data, value, [standard_deviation])

ZTEST

See Z.TEST.