# google sheets Functions

## references

references

- Google Sheets function list (Google Sheets Help Page)

## articles/blogs

articles/blogs

- 18 Google Sheets Formula Tips & Techniques You Should Know (Ben Collins)
- Google Sheets - Working with Functions (GCF Global)
- The 7 Most Useful Google Sheets Formulas (HubSpot)
- The only functions you'll ever need, in one tutorial (Coding is for Losers)
- Back to Basics: formulas in Google Sheets (Ablebits.com)
- 6 Google Sheets Functions You Probably Don’t Know But Should - Part 1 (Geckoboard)
- 6 Google Sheets Functions You Probably Don’t Know But Should - Part 2 (Geckoboard)
- 18 Google Spreadsheet Formulas You Must Know! (Automate.io)
- 5 Google Sheets Formulas for HR Managers (BeeBole)

# Google Sheets functions reference

Google Sheets functions reference

## Date

Date

- DATE - Converts a provided year, month, and day into a date.
- How to use the DATE formula in Google Sheets (SheetGo)
- Reset Week Number in Google Sheets Using Array or Non-Array Formulas (Info Inspired)
- Create a Monthly Calendar in Google Sheets in 9 Steps (Info Inspired)

- DATEDIF - Calculates the number of days, months, or years between two dates. *
- Create a Monthly Calendar in Google Sheets in 9 Steps (Info Inspired)

- DATEVALUE - Converts a provided date string in a known format to a date value.
- DAY - Returns the day of the month that a specific date falls on, in numeric format.
- DAYS - Returns the number of days between two dates.
- DAYS360 - Returns the difference between two days based on the 360 day year used in some financial interest calculations.
- EDATE - Returns a date a specified number of months before or after another date.
- EOMONTH - Returns a date representing the last day of a month which falls a specified number of months before or after another date.
- Create a Monthly Calendar in Google Sheets in 9 Steps (Info Inspired)

- HOUR - Returns the hour component of a specific time, in numeric format.
- ISOWEEKNUM - Returns the number of the ISO week of the year where the provided date falls.
- MINUTE - Returns the minute component of a specific time, in numeric format.
- MONTH - Returns the month of the year a specific date falls in, in numeric format.
- NETWORKDAYS - Returns the number of net working days between two provided days.
- NETWORKDAYS.INTL - Returns the number of net working days between two provided days excluding specified weekend days and holidays.
- NOW - Returns the current date and time as a date value.
- SECOND - Returns the second component of a specific time, in numeric format.
- TIME - Converts a provided hour, minute, and second into a time.
- TIMEVALUE - Returns the fraction of a 24-hour day the time represents.
- TODAY - Returns the current date as a date value.
- WEEKDAY - Returns a number representing the day of the week of the date provided.
- Create a Monthly Calendar in Google Sheets in 9 Steps (Info Inspired)

- WEEKNUM - Returns a number representing the week of the year where the provided date falls.
- WORKDAY - Calculates the end date after a specified number of working days.
- WORKDAY.INTL - Calculates the date after a specified number of workdays excluding specified weekend days and holidays.
- YEAR - Returns the year specified by a given date.
- YEARFRAC - Returns the number of years, including fractional years, between two dates using a specified day count convention.

## Engineering

Engineering

- BIN2DEC - Converts a signed binary number to decimal format.
- BIN2HEX - Converts a signed binary number to signed hexadecimal format.
- BIN2OCT - Converts a signed binary number to signed octal format.
- BITAND - Bitwise boolean AND of two numbers.
- BITLSHIFT - Shifts the bits of the input a certain number of places to the left.
- BITOR - Bitwise boolean OR of 2 numbers.
- BITRSHIFT - Shifts the bits of the input a certain number of places to the right.
- BITXOR - Bitwise XOR (exclusive OR) of 2 numbers.
- COMPLEX - Creates a complex number given real and imaginary coefficients.
- DEC2BIN - Converts a decimal number to signed binary format.
- DEC2HEX - Converts a decimal number to signed hexadecimal format.
- DEC2OCT - Converts a decimal number to signed octal format.
- DELTA - Compare two numeric values, returning 1 if they're equal.
- How to Use the Delta Function (Info Inspired)

- ERF - The ERF function returns the integral of the Gauss error function over an interval of values.
- ERF.PRECISE - See ERF
- 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.
- HEX2BIN - Converts a signed hexadecimal number to signed binary format.
- HEX2DEC - Converts a signed hexadecimal number to decimal format.
- HEX2OCT - Converts a signed hexadecimal number to signed octal format.
- IMABS - Returns absolute value of a complex number.
- IMAGINARY - Returns the imaginary coefficient of a complex number.
- IMARGUMENT - The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians.
- IMCONJUGATE - Returns the complex conjugate of a number.
- IMCOS - The IMCOS function returns the cosine of the given complex number.
- IMCOSH - Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)."
- IMCOT - Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)."
- IMCOTH - Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)."
- IMCSC - Returns the cosecant of the given complex number.
- IMCSCH - Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)."
- IMDIV - Returns one complex number divided by another.
- IMEXP - Returns Euler's number, e (~2.718) raised to a complex power.
- IMLOG - Returns the logarithm of a complex number for a specified base.
- IMLOG10 - Returns the logarithm of a complex number with base 10.
- IMLOG2 - Returns the logarithm of a complex number with base 2.
- IMPRODUCT - Returns the result of multiplying a series of complex numbers together.
- IMREAL - Returns the real coefficient of a complex number.
- IMSEC - Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)."
- IMSECH - Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)."
- IMSIN - Returns the sine of the given complex number.
- IMSINH - Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi)."
- IMSUB - Returns the difference between two complex numbers.
- IMSUM - Returns the sum of a series of complex numbers.
- IMTAN - Returns the tangent of the given complex number.
- IMTANH - Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)."
- OCT2BIN - Converts a signed octal number to signed binary format.
- OCT2DEC - Converts a signed octal number to decimal format.
- OCT2HEX - Converts a signed octal number to signed hexadecimal format.

## Filter

Filter

- FILTER - Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.
- SORT - Sorts the rows of a given array or range by the values in one or more columns.
- How to Properly Sort Alphanumeric Values (Info Inspired)

- SORTN - Returns the first n items in a data set after performing a sort.
- 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.

## Financial

Financial

- ACCRINT - Calculates the accrued interest of a security that has periodic payments.
- ACCRINTM - Calculates the accrued interest of a security that pays interest at maturity.
- AMORLINC - Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.
- COUPDAYBS - Calculates the number of days from the first coupon, or interest payment, until settlement.
- COUPDAYS - Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.
- COUPDAYSNC - Calculates the number of days from the settlement date until the next coupon, or interest payment.
- COUPNCD - Calculates next coupon, or interest payment, date after the settlement date.
- COUPNUM - Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.
- How to Use COUPNUM Function in Google Sheets (Info Inspired)

- COUPPCD - Calculates last coupon, or interest payment, date before the settlement date.
- 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.
- 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.
- How to Use the CUMPRINC Function in Google Sheets (Info Inspired)

- DB - Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
- DDB - Calculates the depreciation of an asset for a specified period using the double-declining balance method.
- DISC - Calculates the discount rate of a security based on price.
- DOLLARDE - Converts a price quotation given as a decimal fraction into a decimal value.
- DOLLARFR - Converts a price quotation given as a decimal value into a decimal fraction.
- 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.
- EFFECT - Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.
- FV - Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
- FVSCHEDULE - Calculates the future value of some principal based on a specified series of potentially varying interest rates.
- 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.
- IPMT - Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.
- IRR - Calculates the internal rate of return on an investment based on a series of periodic cash flows.
- ISPMT - The ISPMT function calculates the interest paid during a particular period of an investment.
- MDURATION - Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.
- 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.
- NOMINAL - Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.
- NPER - Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.
- NPV - Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.
- PDURATION - Returns the number of periods for an investment to reach a specific value at a given rate.
- PMT - Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.
- PPMT - Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.
- PRICE - Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.
- PRICEDISC - Calculates the price of a discount (non-interest-bearing) security, based on expected yield.
- PRICEMAT - Calculates the price of a security paying interest at maturity, based on expected yield.
- PV - Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
- RATE - Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate.
- RECEIVED - Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date.
- RRI - Returns the interest rate needed for an investment to reach a specific value within a given number of periods.
- SLN - Calculates the depreciation of an asset for one period using the straight-line method.
- SYD - Calculates the depreciation of an asset for a specified period using the sum of years digits method.
- TBILLEQ - Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.
- TBILLPRICE - Calculates the price of a US Treasury Bill based on discount rate.
- TBILLYIELD - Calculates the yield of a US Treasury Bill based on price.
- VDB - Returns the depreciation of an asset for a particular period (or partial period).
- XIRR - Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows.
- XNPV - Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate.
- YIELD - Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price.
- YIELDDISC - Calculates the annual yield of a discount (non-interest-bearing) security, based on price.
- YIELDMAT - Calculates the annual yield of a security paying interest at maturity, based on price.

## Google

Google

- ARRAYFORMULA - 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.
- Create a Monthly Calendar in Google Sheets in 9 Steps (Info Inspired)
- How to Stop Array Formula Messing up in Sorting (Info Inspired)
- Average Array Formula Across Rows (Info Inspired)

- DETECTLANGUAGE - Identifies the language used in text within the specified range.
- GOOGLEFINANCE - Fetches current or historical securities information from Google Finance.
- How to calculate currency exchange rates in Google Sheets with GOOGLEFINANCE (AbleBits)
- Use the Google Finance Function📽️ (Ralph Phillips)
- Using Google Spreadsheet to Track a Stock Portfolio (Chris Reining)

- GOOGLETRANSLATE - Translates text from one language into another
- Use the Google Translate Function 📽️ (Ralph Phillips)

- IMAGE - Inserts an image into a cell.
- Use Images in Google Sheets (Sheets Help)

- QUERY - Runs a Google Visualization API Query Language query across data.
- Create a Monthly Calendar in Google Sheets in 9 Steps (Info Inspired)
- Sum Current Month Data Using Query Function (Info Inspired)

- SPARKLINE - Creates a miniature chart contained within a single cell.

## Info

Info

- ERROR.TYPE - Returns a number corresponding to the error value in a different cell.
- ISBLANK - Checks whether the referenced cell is empty.
- ISDATE - Returns whether a value is a date.
- ISEMAIL - Checks whether a value is a valid email address.
- ISERR - Checks whether a value is an error other than `#N/A`.
- ISERROR - Checks whether a value is an error.
- ISFORMULA - Checks whether a formula is in the referenced cell.
- ISLOGICAL - Checks whether a value is `TRUE` or `FALSE`.
- ISNA - Checks whether a value is the error `#N/A`.
- ISNONTEXT - Checks whether a value is non-textual.
- ISNUMBER - Checks whether a value is a number.
- ISREF - Checks whether a value is a valid cell reference.
- ISTEXT - Checks whether a value is text.
- N - Returns the argument provided as a number.
- NA - Returns the "value not available" error, `#N/A`.
- TYPE - Returns a number associated with the type of data passed into the function.
- CELL - Returns the requested information about the specified cell.

## Logical

Logical

- AND - Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.
- FALSE - Returns the logical value `FALSE`.
- IF - Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
- Create a Monthly Calendar in Google Sheets in 9 Steps (Info Inspired)

- 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.
- IFNA - Evaluates a value. If the value is an #N/A error, returns the specified value.
- How to Use Google Sheets IFNA Function (Info Inspired)

- IFS - Evaluates multiple conditions and returns a value that corresponds to the first true condition.
- How to Use IFS Function to Return an Array Result (Info Inspired)

- NOT - Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.
- OR - Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.
- 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.
- TRUE - Returns the logical value `TRUE`.
- XOR - The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise.
- ADDRESS - Returns a cell reference as a string.
- CHOOSE - Returns an element from a list of choices based on index.
- COLUMN - Returns the column number of a specified cell, with `A=1`.
- COLUMNS - Returns the number of columns in a specified array or range.
- FORMULATEXT - Returns the formula as a string.
- Extract Formula from a Cell as a Text (Info Inspired)

- GETPIVOTDATA - Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.
- 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.
- INDEX - Returns the content of a cell, specified by row and column offset.
- INDIRECT - Returns a cell reference specified by a string.
- Create a Monthly Calendar in Google Sheets in 9 Steps (Info Inspired)

- 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.
- MATCH - Returns the relative position of an item in a range that matches a specified value.
- OFFSET - Returns a range reference shifted a specified number of rows and columns from a starting cell reference.
- ROW - Returns the row number of a specified cell.
- ROWS - Returns the number of rows in a specified array or range.
- 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.
- How to Get Dynamic Search Column in Vlookup (Info Inspired)
- Using VLOOKUP Function (sutevski.mk)
- How to Find Data in Google Sheets with VLOOKUP (HowToGeek)
- Common Errors in Vlookup in Google Sheets (Info Inspired)

## Math

Math

- ABS - Returns the absolute value of a number.
- ACOS - Returns the inverse cosine of a value, in radians.
- ACOSH - Returns the inverse hyperbolic cosine of a number.
- ACOT - Returns the inverse cotangent of a value, in radians.
- ACOTH - Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive.
- ASIN - Returns the inverse sine of a value, in radians.
- ASINH - Returns the inverse hyperbolic sine of a number.
- ATAN - Returns the inverse tangent of a value, in radians.
- ATAN2 - 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 - Returns the inverse hyperbolic tangent of a number.
- BASE - Converts a number into a text representation in another base, for example, base 2 for binary.
- CEILING - Rounds a number up to the nearest integer multiple of specified significance.
- 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.
- 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.
- COMBIN - Returns the number of ways to choose some number of objects from a pool of a given size of objects.
- 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.
- COS - Returns the cosine of an angle provided in radians.
- COSH - Returns the hyperbolic cosine of any real number.
- COT - Cotangent of an angle provided in radians.
- COTH - Returns the hyperbolic cotangent of any real number.
- COUNTBLANK - Returns the number of empty cells in a given range.
- COUNTIF - Returns a conditional count across a range.
- COUNTIFS - Returns the count of a range depending on multiple criteria.
- COUNTUNIQUE - Counts the number of unique values in a list of specified values and ranges.
- CSC - Returns the cosecant of an angle provided in radians.
- CSCH - The CSCH function returns the hyperbolic cosecant of any real number.
- DECIMAL - The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal).
- DEGREES - Converts an angle value in radians to degrees.
- ERFC - Returns the complementary Gauss error function of a value.
- ERFC.PRECISE - See ERFC
- EVEN - Rounds a number up to the nearest even integer.
- EXP - Returns Euler's number, e (~2.718) raised to a power.
- FACT - Returns the factorial of a number.
- FACTDOUBLE - Returns the "double factorial" of a number.
- FLOOR - Rounds a number down to the nearest integer multiple of specified significance.
- 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.
- FLOOR.PRECISE - The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance.
- GAMMALN - Returns the the logarithm of a specified Gamma function, base e (Euler's number).
- GAMMALN.PRECISE - See GAMMALN
- GCD - Returns the greatest common divisor of one or more integers.
- IMLN - Returns the logarithm of a complex number, base e (Euler's number).
- IMPOWER - Returns a complex number raised to a power.
- IMSQRT - Computes the square root of a complex number.
- INT - Rounds a number down to the nearest integer that is less than or equal to it.
- ISEVEN - Checks whether the provided value is even.
- ISO.CEILING - See CEILING.PRECISE
- ISODD - Checks whether the provided value is odd.
- LCM - Returns the least common multiple of one or more integers.
- LN - Returns the the logarithm of a number, base e (Euler's number).
- LOG - Returns the the logarithm of a number given a base.
- LOG10 - Returns the the logarithm of a number, base 10.
- MOD - Returns the result of the modulo operator, the remainder after a division operation.
- MROUND - Rounds one number to the nearest integer multiple of another.
- MULTINOMIAL - Returns the factorial of the sum of values divided by the product of the values' factorials.
- MUNIT - Returns a unit matrix of size dimension x dimension.
- ODD - Rounds a number up to the nearest odd integer.
- PI - Returns the value of Pi to 14 decimal places.
- POWER - Returns a number raised to a power.
- PRODUCT - Returns the result of multiplying a series of numbers together.
- QUOTIENT - Returns one number divided by another.
- RADIANS - Converts an angle value in degrees to radians.
- RAND - Returns a random number between 0 inclusive and 1 exclusive.
- RANDARRAY - Generates an array of random numbers between 0 and 1.
- RANDBETWEEN - Returns a uniformly random integer between two values, inclusive.
- ROUND - Rounds a number to a certain number of decimal places according to standard rules.
- ROUNDDOWN - Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.
- ROUNDUP - Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
- SEC - The SEC function returns the secant of an angle, measured in radians.
- SECH - The SECH function returns the hyperbolic secant of an angle.
- SEQUENCE - Returns an array of sequential numbers, such as 1, 2, 3, 4.
- 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`.
- SIGN - Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.
- SIN - Returns the sine of an angle provided in radians.
- SINH - Returns the hyperbolic sine of any real number.
- SQRT - Returns the positive square root of a positive number.
- SQRTPI - Returns the positive square root of the product of Pi and the given positive number.
- SUBTOTAL - Returns a subtotal for a vertical range of cells using a specified aggregation function.
- SUM - Returns the sum of a series of numbers and/or cells.
- SUMIF - Returns a conditional sum across a range.
- SUMIFS - Returns the sum of a range depending on multiple criteria.
- SUMSQ - Returns the sum of the squares of a series of numbers and/or cells.
- TAN - Returns the tangent of an angle provided in radians.
- TANH - Returns the hyperbolic tangent of any real number.
- TRUNC - Truncates a number to a certain number of significant digits by omitting less significant digits.

## Operator

Operator

- ADD - Returns the sum of two numbers. Equivalent to the `+` operator.
- CONCAT - Returns the concatenation of two values. Equivalent to the `&` operator.
- DIVIDE - Returns one number divided by another. Equivalent to the `/` operator.
- EQ - Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator.
- GT - Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator.
- GTE - Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator.
- LT - Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator.
- LTE - Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator.
- MINUS - Returns the difference of two numbers. Equivalent to the `-` operator.
- MULTIPLY - Returns the product of two numbers. Equivalent to the `*` operator.
- How to Multiply Numbers in Google Sheets (How To Geek)

- NE - Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator.
- POW - Returns a number raised to a power.
- UMINUS - Returns a number with the sign reversed.
- UNARY_PERCENT - Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.
- UPLUS - Returns a specified number, unchanged.

## Statistical

Statistical

- AVEDEV - Calculates the average of the magnitudes of deviations of data from a dataset's mean.
- AVERAGE - Returns the numerical average value in a dataset, ignoring text.
- AVERAGE.WEIGHTED - Finds the weighted average of a set of values, given the values and the corresponding weights.
- AVERAGEA - Returns the numerical average value in a dataset.
- AVERAGEIF - Returns the average of a range depending on criteria.
- AVERAGEIFS - Returns the average of a range depending on multiple criteria.
- BETA.DIST - Returns the probability of a given value as defined by the beta distribution function.
- BETA.INV - Returns the value of the inverse beta distribution function for a given probability.
- BETADIST - See BETA.DIST.
- BETAINV - See BETA.INV
- BINOM.DIST - See BINOMDIST
- BINOM.INV - See CRITBINOM
- BINOMDIST - 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.
- CHIDIST - Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.
- CHIINV - Calculates the inverse of the right-tailed chi-squared distribution.
- CHISQ.DIST - Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.
- CHISQ.DIST.RT - Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.
- CHISQ.INV - Calculates the inverse of the left-tailed chi-squared distribution.
- CHISQ.INV.RT - Calculates the inverse of the right-tailed chi-squared distribution.
- CHISQ.TEST - See CHITEST
- 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.
- CONFIDENCE - See CONFIDENCE.NORM
- CONFIDENCE.NORM - Calculates the width of half the confidence interval for a normal distribution.
- CONFIDENCE.T - Calculates the width of half the confidence interval for a Student’s t-distribution.
- CORREL - Calculates r, the Pearson product-moment correlation coefficient of a dataset.
- COUNT - Returns a count of the number of numeric values in a dataset.
- COUNTA - Returns a count of the number of values in a dataset.
- COVAR - Calculates the covariance of a dataset.
- COVARIANCE.P - See COVAR
- COVARIANCE.S - Calculates the covariance of a dataset, where the dataset is a sample of the total population.
- CRITBINOM - Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.
- DEVSQ - Calculates the sum of squares of deviations based on a sample.
- EXPON.DIST - Returns the value of the exponential distribution function with a specified lambda at a specified value.
- EXPONDIST - See EXPON.DIST
- 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.
- 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.
- F.INV - Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.
- F.INV.RT - Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.
- F.TEST - See FTEST.
- FDIST - See F.DIST.RT.
- FINV - See F.INV.RT
- FISHER - Returns the Fisher transformation of a specified value.
- FISHERINV - Returns the inverse Fisher transformation of a specified value.
- FORECAST - Calculates the expected y-value for a specified x based on a linear regression of a dataset.
- FORECAST.LINEAR - See FORECAST
- 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.
- GAMMA - Returns the Gamma function evaluated at the specified value.
- GAMMA.DIST - Calculates the gamma distribution, a two-parameter continuous probability distribution.
- 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.
- GAMMADIST - See GAMMA.DIST
- GAMMAINV - See GAMMA.INV.
- 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.
- GEOMEAN - Calculates the geometric mean of a dataset.
- HARMEAN - Calculates the harmonic mean of a dataset.
- HYPGEOM.DIST - See HYPGEOMDIST
- 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.
- INTERCEPT - Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).
- KURT - Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.
- LARGE - Returns the nth largest element from a data set, where n is user-defined.
- LOGINV - Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value.
- LOGNORM.DIST - See LOGNORMDIST
- LOGNORM.INV - See LOGINV
- LOGNORMDIST - Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.
- MAX - Returns the maximum value in a numeric dataset.
- MAXA - Returns the maximum numeric value in a dataset.
- MAXIFS - Returns the maximum value in a range of cells, filtered by a set of criteria.
- MEDIAN - Returns the median value in a numeric dataset.
- MIN - Returns the minimum value in a numeric dataset.
- MINA - Returns the minimum numeric value in a dataset.
- MINIFS - Returns the minimum value in a range of cells, filtered by a set of criteria.
- MODE - Returns the most commonly occurring value in a dataset.
- MODE.MULT - Returns the most commonly occurring values in a dataset.
- MODE.SNGL - See MODE
- NEGBINOM.DIST - See NEGBINOMDIST
- 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.
- NORM.DIST - See NORMDIST
- NORM.INV - See NORMINV
- NORM.S.DIST - See NORMSDIST
- NORM.S.INV - See NORMSINV
- NORMDIST - Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.
- NORMINV - Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.
- NORMSDIST - Returns the value of the standard normal cumulative distribution function for a specified value.
- NORMSINV - Returns the value of the inverse standard normal distribution function for a specified value.
- PEARSON - Calculates r, the Pearson product-moment correlation coefficient of a dataset.
- PERCENTILE - Returns the value at a given percentile of a dataset.
- PERCENTILE.EXC - Returns the value at a given percentile of a dataset, exclusive of 0 and 1.
- PERCENTILE.INC - See PERCENTILE
- PERCENTRANK - Returns the percentage rank (percentile) of a specified value in a dataset.
- PERCENTRANK.EXC - Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.
- PERCENTRANK.INC - Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.
- PERMUTATIONA - Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects.
- PERMUT - Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.
- PHI - The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1.
- POISSON - See POISSON.DIST
- POISSON.DIST - Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.
- PROB - Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits.
- QUARTILE - Returns a value nearest to a specified quartile of a dataset.
- QUARTILE.EXC - Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4.
- QUARTILE.INC - See QUARTILE
- RANK - Returns the rank of a specified value in a dataset.
- 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.
- 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.
- RSQ - Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.
- SKEW - Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.
- SKEW.P - Calculates the skewness of a dataset that represents the entire population.
- SLOPE - Calculates the slope of the line resulting from linear regression of a dataset.
- SMALL - Returns the nth smallest element from a data set, where n is user-defined.
- STANDARDIZE - Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.
- STDEV - Calculates the standard deviation based on a sample.
- STDEV.P - See STDEVP
- STDEV.S - See STDEV
- STDEVA - Calculates the standard deviation based on a sample, setting text to the value `0`.
- STDEVP - Calculates the standard deviation based on an entire population.
- STDEVPA - Calculates the standard deviation based on an entire population, setting text to the value `0`.
- STEYX - Calculates the standard error of the predicted y-value for each x in the regression of a dataset.
- T.DIST - Returns the right tailed Student distribution for a value x.
- T.DIST.2T - Returns the two tailed Student distribution for a value x.
- T.DIST.RT - Returns the right tailed Student distribution for a value x.
- T.INV - Calculates the negative inverse of the one-tailed TDIST function.
- T.INV.2T - Calculates the inverse of the two-tailed TDIST function.
- 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.
- TDIST - Calculates the probability for Student's t-distribution with a given input (x).
- TINV - See T.INV.2T
- TRIMMEAN - Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.
- TTEST - See T.TEST.
- VAR - Calculates the variance based on a sample.
- VAR.P - See VARP
- VAR.S - See VAR
- VARA - Calculates an estimate of variance based on a sample, setting text to the value `0`.
- VARP - Calculates the variance based on an entire population.
- VARPA - Calculates the variance based on an entire population, setting text to the value `0`.
- WEIBULL - Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.
- WEIBULL.DIST - See WEIBULL
- Z.TEST - Returns the one-tailed P-value of a Z-test with standard distribution.
- ZTEST - See Z.TEST.

## Text

Text

- ARABIC - Computes the value of a Roman numeral.
- ASC - Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged.
- CHAR - Convert a number into a character according to the current Unicode table.
- CLEAN - Returns the text with the non-printable ASCII characters removed.
- CODE - Returns the numeric Unicode map value of the first character in the string provided.
- CONCATENATE - Appends strings to one another.
- DOLLAR - Formats a number into the locale-specific currency format.
- EXACT - Tests whether two strings are identical.
- FIND - Returns the position at which a string is first found within text.
- FINDB - Returns the position at which a string is first found within text counting each double-character as 2.
- FIXED - Formats a number with a fixed number of decimal places.
- JOIN - Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
- LEFT - Returns a substring from the beginning of a specified string.
- LEFTB - Returns the left portion of a string up to a certain number of bytes.
- LEN - Returns the length of a string.
- LENB - Returns the length of a string in bytes."
- LOWER - Converts a specified string to lowercase.
- MID - Returns a segment of a string.
- MIDB - Returns a section of a string starting at a given character and up to a specified number of bytes.
- PROPER - Capitalizes each word in a specified string.
- REGEXEXTRACT - Extracts matching substrings according to a regular expression.
- REGEXMATCH - Whether a piece of text matches a regular expression.
- Regexmatch Dates – Single/Multiple Match (Info Inspired)

- REGEXREPLACE - Replaces part of a text string with a different text string using regular expressions.
- REPLACE - Replaces part of a text string with a different text string.
- REPLACEB - Replaces part of a text string, based on a number of bytes, with a different text string.
- REPT - Returns specified text repeated a number of times.
- RIGHT - Returns a substring from the end of a specified string.
- RIGHTB - Returns the right portion of a string up to a certain number of bytes.
- ROMAN - Formats a number in Roman numerals.
- SEARCH - Returns the position at which a string is first found within text.
- SEARCHB - Returns the position at which a string is first found within text counting each double-character as 2.
- SPLIT - Divides text around a specified character or string, and puts each fragment into a separate cell in the row.
- SUBSTITUTE - Replaces existing text with new text in a string.
- T - Returns string arguments as text.
- TEXT - Converts a number into text according to a specified format.
- TEXTJOIN - Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.
- TRIM - Removes leading and trailing spaces in a specified string.
- UNICHAR - Returns the Unicode character for a number.
- UNICODE - Returns the decimal Unicode value of the first character of the text.
- UPPER - Converts a specified string to uppercase.
- VALUE - Converts a string in any of the date, time or number formats that Google Sheets understands into a number.

## Database

Database

- DAVERAGE - Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.
- DCOUNT - Counts numeric values selected from a database table-like array or range using a SQL-like query.
- DCOUNTA - Counts values, including text, selected from a database table-like array or range using a SQL-like query.
- DGET - Returns a single value from a database table-like array or range using a SQL-like query.
- DMAX - Returns the maximum value selected from a database table-like array or range using a SQL-like query.
- DMIN - Returns the minimum value selected from a database table-like array or range using a SQL-like query.
- DPRODUCT - Returns the product of values selected from a database table-like array or range using a SQL-like query.
- DSTDEV - Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.
- DSTDEVP - Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.
- DSUM - Returns the sum of values selected from a database table-like array or range using a SQL-like query.
- DVAR - Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.
- DVARP - Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.

## Parser

Parser

- CONVERT - Converts a numeric value to a different unit of measure.
- TO_DATE - Converts a provided number to a date.
- TO_DOLLARS - Converts a provided number to a dollar value.
- TO_PERCENT - Converts a provided number to a percentage.
- TO_PURE_NUMBER - Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.
- TO_TEXT - Converts a provided numeric value to a text value.

## Array

Array

- ARRAY_CONSTRAIN - Constrains an array result to a specified size.
- FREQUENCY - Calculates the frequency distribution of a one-column array into specified classes.
- GROWTH - Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values.
- LINEST - Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method.
- LOGEST - Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve.
- MDETERM - Returns the matrix determinant of a square matrix specified as an array or range.
- MINVERSE - Returns the multiplicative inverse of a square matrix specified as an array or range.
- MMULT - Calculates the matrix product of two matrices specified as arrays or ranges.
- SUMPRODUCT - Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.
- SUMX2MY2 - Calculates the sum of the differences of the squares of values in two arrays.
- SUMX2PY2 - Calculates the sum of the sums of the squares of values in two arrays.
- SUMXMY2 - Calculates the sum of the squares of differences of values in two arrays.
- TRANSPOSE - Transposes the rows and columns of an array or range of cells.
- TREND - Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.

## WEB

WEB

- ENCODEURL - Encodes a string of text for the purpose of using in a URL query.
- HYPERLINK - Creates a hyperlink inside a cell.
- IMPORTDATA - Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.
- IMPORTFEED - Imports a RSS or ATOM feed.
- IMPORTHTML - Imports data from a table or list within an HTML page.
- IMPORTRANGE - Imports a range of cells from a specified spreadsheet.
- IMPORTXML - Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.
- The ImportXML Guide for Google Docs (Distilled.net)
- Collect Data from Anywhere with Google Sheet's ImportXML Function (SheetGo)
- How to Use ImportXML With Examples (Counting Characters)

- ISURL - Checks whether a value is a valid URL.