Google Sheets function list

All 515 functions

Every function name in Google’s own Google Sheets function list, with its type and Google’s one-line description. Each name opens a page with the full printed syntax and a link to Google’s article for it.

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

Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026. Record id is printed on each function page.