the complete catalogue of spreadsheet functions documented on sheets.wiki, grouped by category. 527 entries.
| name | description |
|---|---|
| ARRAY_CONSTRAIN | Constrains an array result to a specified size. |
| BYCOL | This function groups an array by columns by application of a `LAMBDA` function to each column. |
| BYROW | This function groups an array by rows by application of a `LAMBDA` function to each row. |
| CHOOSECOLS | This function creates a new array from the selected columns in the existing range. |
| CHOOSEROWS | This function creates a new array from the selected rows in the existing range. |
| FLATTEN | Flattens all the values from one or more ranges into a single column. |
| 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. |
| HSTACK | This function appends arrays horizontally and in sequence to return a larger array. |
| 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. |
| MAKEARRAY | This function returns an array of specified dimensions with values calculated by application of a LAMBDA function. |
| MAP | This function maps each value in the given arrays to a new value by application of a `LAMBDA` function to each value. |
| 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. |
| REDUCE | This function reduces an array to an accumulated result by application of a `LAMBDA` function to each value. |
| SCAN | This function scans an array and produces intermediate values by application of a `LAMBDA` function to each value. |
| SINGLE | Constrains an [[Array|array]] to $1 \times 1$. Returns the upper-leftmost [[Data type#scalar-types|scalar value]]. |
| SUMPRODUCT | The SUMPRODUCT function calculates the sum of the products of corresponding entries in 2 equally 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. |
| TOCOL | This function transforms an array or range of cells into a single column. |
| TOROW | This function transforms an array or range of cells into a single row. |
| 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. |
| VSTACK | This function appends ranges vertically and in sequence to return a larger array. |
| WRAPCOLS | This function wraps the provided row or column of cells by columns after a specified number of elements to form a new array. |
| WRAPROWS | This function wraps the provided row or column of cells by rows after a specified number of elements to form a new array. |
| name | description |
|---|---|
| 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. |
| name | description |
|---|---|
| DATE | Converts a year, month, and day into a date. |
| DATEDIF | Calculates the number of days, months, or years between two dates. |
| 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 | The DAYS function 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. |
| EPOCHTODATE | Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in Universal Time Coordinated(UTC). |
| HOUR | Returns the hour component of a specific time, in numeric format. |
| ISOWEEKNUM | Returns the number of the ISO (International Organization for Standardization) 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 an 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. |
| 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. |
| name | description |
|---|---|
| BIN2DEC | The BIN2DEC function converts a signed binary number to decimal format. |
| BIN2HEX | The BIN2HEX function converts a signed binary number to signed hexadecimal format. |
| BIN2OCT | The BIN2OCT function converts a signed binary number to signed octal format. |
| BITAND | The BITAND function returns the bitwise boolean AND of two numbers. |
| BITLSHIFT | The BITLSHIFT function shifts the bits of the input a certain number of places to the left. |
| BITOR | The BITOR function returns the bitwise Boolean OR of 2 numbers. |
| BITRSHIFT | The BITRSHIFT function shifts the bits of the input a certain number of places to the right. |
| BITXOR | The BITXOR function is a bitwise XOR (exclusive or) of 2 numbers that returns a bit of “1” if 2 bits are different, and a bit of “0” otherwise. |
| COMPLEX | The COMPLEX function creates a complex number, given real and imaginary coefficients. |
| DEC2BIN | The DEC2BIN function converts a decimal number to signed binary format. |
| DEC2HEX | The DEC2HEX function converts a decimal number to signed hexadecimal format. |
| DEC2OCT | The DEC2OCT function converts a decimal number to signed octal format. |
| DELTA | Compare two numeric values, returning 1 if they're equal. |
| ERF | The ERF function returns the integral of the Gauss error function over an interval of values. |
| ERF.PRECISE | The ERF function returns the integral of the Gauss error function over an interval of values. |
| GESTEP | The GESTEP function returns 1 if the rate is strictly greater than or equal to the provided step value, or 0 otherwise. |
| HEX2BIN | The HEX2BIN function converts a signed hexadecimal number to signed binary format. |
| HEX2DEC | The HEX2DEC function converts a signed hexadecimal number to decimal format. |
| HEX2OCT | The HEX2OCT function converts a signed hexadecimal number to signed octal format. |
| IMABS | Returns the 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 | The IMCOSH function returns the hyperbolic cosine of the given complex number. |
| IMCOT | The IMCOT function returns the cotangent of the given complex number. |
| IMCOTH | The IMCOTH function returns the hyperbolic cotangent of the given complex number. |
| IMCSC | The IMCSC function returns the cosecant of the given complex number. |
| IMCSCH | The IMCSCH function returns the hyperbolic cosecant of the given complex number. |
| IMDIV | Returns one complex number divided by another. |
| IMEXP | The IMEXP function returns Euler's number, e (~2. |
| IMLOG | The IMLOG function returns the logarithm of a complex number for a specified base. |
| IMLOG10 | The IMLOG10 function returns the logarithm of a complex number with base 10. |
| IMLOG2 | The IMLOG2 function 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 | The IMSEC function returns the secant of the given complex number. |
| IMSECH | The IMSECH function returns the hyperbolic secant of the given complex number. |
| IMSIN | The IMSIN function returns the sine of the given complex number. |
| IMSINH | The IMSINH function returns the hyperbolic sine of the given complex number. |
| IMSUB | Returns the difference between two complex numbers. |
| IMSUM | Returns the sum of a series of complex numbers or cells or both. |
| IMTAN | The IMTAN function returns the tangent of the given complex number. |
| IMTANH | The IMTANH function returns the hyperbolic tangent of the given complex number. |
| OCT2BIN | The OCT2BIN function converts a signed octal number to signed binary format. |
| OCT2DEC | The OCT2DEC function converts a signed octal number to decimal format. |
| OCT2HEX | The OCT2HEX function converts a signed octal number to signed hexadecimal format. |
| name | description |
|---|---|
| FILTER | Returns a filtered version of the source range, returning only rows or columns that meet the specified conditions. |
| SORT | Sorts the rows of a given array or range by the values in one or more columns. |
| SORTN | Returns the first n items in a data set after performing a sort. |
| name | description |
|---|---|
| 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 | The AMORLINC function 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. |
| 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. |
| DB | The DB function calculates the depreciation of an asset for a specified period using the arithmetic declining balance method. |
| DDB | The DDB function 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 | The FV function calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate. |
| FVSCHEDULE | The FVSCHEDULE function 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 | The IPMT function 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 | The NPER function 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 | The PDURATION function returns the number of periods for an investment to reach a specific value at a given rate. |
| PMT | The PMT function calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. |
| PPMT | The PPMT function 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 | The RRI function returns the interest rate needed for an investment to reach a specific value within a given number of periods. |
| SLN | The SLN function calculates the depreciation of an asset for one period using the straight-line method. |
| SYD | The SYD function 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 | The VDB function 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 | The `YIELDMAT` function calculates the annual yield of a security paying interest at maturity, based on price. |
| name | description |
|---|---|
| AI | The AI function queries Gemini given a prompt and context from a Google Sheet. |
| ARRAYFORMULA | The primary array-enabling function. Enables the use of non-array functions with arrays. |
| DETECTLANGUAGE | Identifies the language used in text within the specified range. |
| GOOGLEFINANCE | Fetches current or historical securities information from Google Finance. |
| GOOGLETRANSLATE | Translates text from one language into another. |
| IMAGE | Inserts an image into a cell. |
| QUERY | The QUERY function allows the user to make SQL-like queries using the Google Visualization API Query Language on arrays. |
| SPARKLINE | Creates a miniature chart contained within a single cell. |
| name | description |
|---|---|
| CELL | Returns the requested information about the specified cell. |
| ERROR.TYPE | Returns a number corresponding to the error value in a different cell. |
| ISBLANK | Checks whether a value is null. |
| ISDATE | The ISDATE function returns whether a value is a date. |
| ISEMAIL | This function checks if a value is a valid email address against certain 2-letter country or region codes and top-level domains including:. |
| 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. |
| name | description |
|---|---|
| AND | The AND function 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`. |
| 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 | The IFNA function evaluates a value. |
| IFS | Evaluates multiple conditions and returns a value that corresponds to the first true condition. |
| LAMBDA | Creates an anonymous function with a set of names and a formula_expression that uses them. |
| LET | This function assigns a name with the value_expression results and returns the result of the formula_expression. |
| NOT | Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. |
| OR | The OR function 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 returns TRUE if an odd number of the provided arguments are logically true, and FALSE otherwise. |
| name | description |
|---|---|
| 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 | The FORMULATEXT function returns a formula as a string. |
| GETPIVOTDATA | Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings. |
| HLOOKUP | Horizontal lookup. |
| INDEX | Returns the content of a cell, specified by row and column offset. |
| INDIRECT | Returns a cell reference specified by a string. |
| LOOKUP | Looks through a sorted 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 | If you have known information on your spreadsheet, you can use `VLOOKUP` to search for related information by row. |
| XLOOKUP | The `XLOOKUP` function returns the values in the result range based on the position where a match was found in the lookup range. |
| name | description |
|---|---|
| ABS | Returns the absolute value of a number. |
| ACOS | The ACOS function returns the inverse cosine of a value in radians. |
| ACOSH | The ACOSH function returns the inverse hyperbolic cosine of a number. |
| ACOT | The ACOT function returns the inverse cotangent of a value in radians. |
| ACOTH | The ACOTH function returns the inverse hyperbolic cotangent of a value in radians. |
| ASIN | The ASIN function returns the inverse sine of a value in radians. |
| ASINH | The ASINH function returns the inverse hyperbolic sine of a number. |
| ATAN | The ATAN function returns the inverse tangent of a value in radians. |
| ATAN2 | The ATAN2 function returns the angle between the x-axis and a line segment from the origin (0,0) to the specified coordinate pair (`x`,`y`), in radians. |
| ATANH | The ATANH function returns the inverse hyperbolic tangent of a number. |
| BASE | The BASE function converts a decimal number into a text representation in another base. |
| CEILING | The CEILING function rounds a number up to the nearest integer multiple of specified significance. |
| CEILING.MATH | The CEILING. |
| CEILING.PRECISE | The CEILING. |
| COINFLIP | Returns `TRUE` or `FALSE` at random. `COINFLIP` is [[Volatile]]. |
| COMBIN | The COMBIN function returns the number of ways to choose some number of objects from a pool of a given size of objects. |
| COMBINA | The COMBINA function returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways to choose the same object multiple times (also known as choosing with replacement). |
| COS | The COS function returns the cosine of an angle provided in radians. |
| COSH | The COSH function returns the hyperbolic cosine of any real number. |
| COT | The COT function returns the cotangent of an angle provided in radians. |
| COTH | The COTH function 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. |
| COUNTUNIQUEIFS | Returns the unique count of a range depending on multiple criteria. |
| CSC | The CSC function 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 | The DEGREES function converts an angle value in radians to degrees. |
| ERFC | The ERFC function returns the complementary Gauss error function of a value. |
| ERFC.PRECISE | The ERFC function returns the complementary Gauss error function of a value. |
| EVEN | Rounds a number up to the nearest even integer. |
| EXP | Returns Euler's number, e (~2. |
| FACT | The FACT function returns the factorial of a number. |
| FACTDOUBLE | Returns the "double factorial" of a number. |
| FLOOR | The FLOOR function rounds a number down to the nearest integer multiple of specified significance. |
| FLOOR.MATH | The FLOOR. |
| FLOOR.PRECISE | The FLOOR. |
| GAMMALN | Returns the logarithm of a specified Gamma function, base e (Euler's number). |
| GAMMALN.PRECISE | Returns the logarithm of a specified Gamma function, base e (Euler's number). |
| GCD | Returns the greatest common divisor of one or more integers. |
| IMLN | The `IMLN` function returns the logarithm of a complex number, base e (Euler's number). |
| IMPOWER | The `IMPOWER` function returns a complex number raised to a power. |
| IMSQRT | The `IMSQRT` function 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 | The CEILING. |
| ISODD | Checks whether the provided value is odd. |
| LCM | Returns the least common multiple of one or more integers. |
| LN | Returns the logarithm of a number, base e (Euler's number). |
| LOG | Returns the logarithm of a number given a base. |
| LOG10 | Returns 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 | The MUNIT function returns a unit matrix of size dimension x dimension. |
| ODD | Rounds a number up to the nearest odd integer. |
| PERCENTIF | Returns the percentage of a range that meets a condition. |
| PI | The PI function returns the value of pi to 9 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, without the remainder. |
| RADIANS | The RADIANS function converts an angle value in degrees to radians. |
| RAND | Returns a random number between 0 inclusive and 1 exclusive. |
| RANDARRAY | The RANDARRAY function generates an array of random numbers between 0 and 1. |
| RANDBETWEEN | Returns a uniformly random integer between two values, inclusive. |
| ROUND | The ROUND function rounds a number to a certain number of decimal places according to standard rules. |
| ROUNDDOWN | The ROUNDDOWN function 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 | The SEQUENCE function 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) + . |
| SIGN | Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero. |
| SIN | The SIN function returns the sine of an angle provided in radians. |
| SINH | The SINH function 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 | The TAN function returns the tangent of an angle provided in radians. |
| TANH | The TANH function returns the hyperbolic tangent of any real number. |
| TRUNC | Truncates a number to a certain number of significant digits by omitting less significant digits. |
| WHATTHEFOXSAY | Returns one of eight lyrics from the song [The Fox](en.wikipedia.org/wiki/The_Fox_(What_Does_the_Fox_Say%3F)) at random. `WHATTHEFOXSAY` is [[Volatile]]. |
| name | description |
|---|---|
| ADD | Returns the sum of two numbers. |
| CONCAT | Returns the concatenation of two values. |
| DIVIDE | Returns one number divided by another. |
| EQ | Returns "TRUE" if two specified values are equal and "FALSE" otherwise. |
| GT | Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. |
| GTE | Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. |
| ISBETWEEN | Checks whether a provided number is between two other numbers either inclusively or exclusively. |
| LT | Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. |
| LTE | Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. |
| MINUS | Returns the difference of two numbers. |
| MULTIPLY | Returns the product of two numbers. |
| NE | Returns "TRUE" if two specified values are not equal and "FALSE" otherwise. |
| 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`. |
| UNIQUE | Returns unique rows in the provided source range, discarding duplicates. |
| UPLUS | Returns a specified number, unchanged. |
| name | description |
|---|---|
| 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. |
| name | description |
|---|---|
| AVEDEV | Calculates the average of the magnitudes of deviations of data from a dataset's mean. |
| AVERAGE | The AVERAGE function returns the numerical average value in a dataset, ignoring text. |
| AVERAGE.WEIGHTED | The AVERAGE. |
| 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 | The BETA. |
| BETA.INV | The BETA. |
| BETADIST | The BETA. |
| BETAINV | The BETA. |
| BINOM.DIST | 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. |
| BINOM.DIST.RANGE | Returns the probability of drawing a specific number of successes or range of successes given a probability and number of tries. |
| BINOM.INV | Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. |
| 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 | Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. |
| CHITEST | Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. |
| CONFIDENCE | Calculates the width of half the confidence interval for a normal distribution. |
| CONFIDENCE.NORM | Calculates the width of half the confidence interval for a normal distribution. |
| CONFIDENCE.T | The CONFIDENCE. |
| CORREL | Calculates r, the Pearson product-moment correlation coefficient of a dataset. |
| COUNT | Returns the number of numeric values in a dataset. |
| COUNTA | Returns the number of values in a dataset. |
| COVAR | Calculates the covariance of a dataset. |
| COVARIANCE.P | Calculates the covariance of a dataset. |
| COVARIANCE.S | The COVARIANCE. |
| 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 | Returns the value of the exponential distribution function with a specified lambda at a specified value. |
| F.DIST | Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. |
| F.DIST.RT | The F. |
| F.INV | Calculates the inverse of the left-tailed F probability distribution. |
| F.INV.RT | The F. |
| F.TEST | Returns the probability associated with an F-test for equality of variances. |
| FDIST | The F. |
| FINV | The F. |
| 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 | Calculates the expected y-value for a specified x based on a linear regression of a dataset. |
| FTEST | Returns the probability associated with an F-test for equality of variances. |
| GAMMA | The GAMMA function returns the Gamma function evaluated at the specified value. |
| GAMMA.DIST | The GAMMA. |
| GAMMA.INV | The GAMMA. |
| GAMMADIST | The GAMMA. |
| GAMMAINV | The GAMMA. |
| 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 | 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. |
| 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 | Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value. |
| LOGNORM.INV | Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value. |
| LOGNORMDIST | Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value. |
| MARGINOFERROR | This function calculates the margin of error from a range of values and a confidence level. |
| 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 | The MODE. |
| MODE.SNGL | Returns the most commonly occurring value in a dataset. |
| NEGBINOM.DIST | Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials. |
| 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 | The NORMDIST function returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation. |
| NORM.INV | Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation. |
| NORM.S.DIST | Returns the value of the standard normal cumulative distribution function for a specified value. |
| NORM.S.INV | Returns the value of the inverse standard normal distribution function for a specified value. |
| NORMDIST | The NORMDIST function 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 | The PERCENTILE. |
| PERCENTILE.INC | Returns the value at a given percentile of a dataset. |
| 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. |
| PERMUT | Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order. |
| PERMUTATIONA | The PERMUTATIONA function returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. |
| PHI | The PHI function returns the value of the density function for a normal distribution with mean 0 and standard deviation 1, calculated with the formula  for a specified value and mean. |
| 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 | The QUARTILE. |
| QUARTILE.INC | Returns a value nearest to a specified quartile of a dataset. |
| RANK | Returns the rank of a specified value in a dataset. |
| RANK.AVG | Returns the rank of a specified value in a dataset. |
| RANK.EQ | Returns the rank of a specified value in a dataset. |
| 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 | The SKEW. |
| 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 | The STDEV function calculates the standard deviation based on a sample. |
| STDEV.P | Calculates the standard deviation based on an entire population. |
| STDEV.S | The STDEV function calculates the standard deviation based on a sample. |
| 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 | The T. |
| T.DIST.2T | The T. |
| 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 | The T. |
| T.TEST | Returns the probability associated with t-test. |
| TDIST | Calculates the probability for Student's t-distribution with a given input (x). |
| TINV | The T. |
| TRIMMEAN | Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset. |
| TTEST | Returns the probability associated with t-test. |
| VAR | Calculates the variance based on a sample. |
| VAR.P | Calculates the variance based on an entire population. |
| VAR.S | Calculates the variance based on a sample. |
| VARA | Calculates the 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 | Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale. |
| Z.TEST | Returns the one-tailed P-value of a Z-test with standard distribution. |
| ZTEST | Returns the one-tailed P-value of a Z-test with standard distribution. |
| name | description |
|---|---|
| ARABIC | Computes the value of a Roman numeral. |
| ASC | The ASC function converts full-width ASCII and Katakana characters to their half-width counterparts. |
| BAHTTEXT | Converts a number to Thai text with the suffix [Baht](en.wikipedia.org/wiki/Thai_baht) for integer values and Satang for decimal values. |
| 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, case-sensitive. |
| FINDB | Returns the byte position at which a string is first found within text. |
| 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 | The LEFTB function returns the left portion of a string up to a certain number of bytes. |
| LEN | Returns the length of a string. |
| LENB | The LENB function returns the length of a string in bytes. |
| LOWER | Converts a specified string to lowercase. |
| MID | Returns a segment of a string. |
| MIDB | The MIDB function 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 the first matching substrings according to a regular expression. |
| REGEXMATCH | Whether a piece of text matches a regular expression. |
| 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 | The REPLACEB function 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 | The RIGHTB function 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, ignoring case. |
| SEARCHB | Returns the byte position at which a string is first found within text. Supports wildcard and case-insensitive searching. |
| 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, trailing, and repeated spaces in text. |
| UNICHAR | Returns the Unicode character for a number. |
| UNICODE | The `UNICODE` function 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. |
| name | description |
|---|---|
| ARRAY_LITERAL | Constructs a 2D [[Array|array]] by stacking rows vertically. `ARRAY_LITERAL` is the functional equivalent of the `{}` [[Array#array-literals|array literal]] syntax, where each argument corresponds to a row — typically produced by [[ARRAY_ROW]]. |
| ARRAY_ROW | Constructs a horizontal [[Array#vectors|vector]] (a single row). `ARRAY_ROW` is the functional equivalent of comma separation within an [[Array#array-literals|array literal]] `{}`. |
| CURSORPARK | Generates a [cursor park](knowyourmeme.com/memes/cursor-park), a $5 \times 8$ [[Array|array]] of [emojis](en.wikipedia.org/wiki/Emoji). |
| DUCKHUNT | Returns `🦆`, the duck emoji (`U+1F986`). |
| RITZCODERZ | Returns a $38 \times 3$ [[Array#jagged-arrays|jagged array]] containing the names of developers on the Google Sheets team. |
| TRIXTERNS | Returns a $43 \times 1$ [[Array|array]] containing the names and years of each cohort of interns with the Google Sheets team. |
| XMATCH | XMATCH returns the relative position of an item in an array or range that matches a specified value. |
| name | description |
|---|---|
| ENCODEURL | Encodes text so it can be used in the query string of a URL. |
| HYPERLINK | Creates a hyperlink inside a cell. |
| IMPORTDATA | Imports data at a given url in . |
| 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. |
| ISURL | Checks whether a value is a valid URL. |