Google Sheets

The following functions are only available in Google Sheets.

ADD	Returns the sum of two numbers. Equivalent to the `+` operator.
ARRAY_CONSTRAIN	Constrains an array result to a specified size.
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.
AVERAGE.WEIGHTED	Finds the weighted average of a set of values, given the values and the corresponding weights.
COUNTUNIQUE	Counts the number of unique values in a list of specified values and ranges.
DETECTLANGUAGE	Identifies the language used in text within the specified range.
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.
FLATTEN	Flattens all the values from one or more ranges into a single column.
GOOGLEFINANCE	Fetches current or historical securities information from Google Finance.
GOOGLETRANSLATE	Translates text from one language into another.
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.
IMLOG	Returns the logarithm of a complex number for a specified base.
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.
IMTANH	Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)."
ISBETWEEN	Checks whether a provided number is between two other numbers either inclusively or exclusively.
ISDATE	Returns whether a value is a date.
ISEMAIL	Checks whether a value is a valid email address.
ISURL	Checks whether a value is a valid URL.
JOIN	Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
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.
NE	Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator.
PERCENTIF	Returns the percentage of a range that meets a condition.
POW	Returns a number raised to a power.
QUERY	Runs a Google Visualization API Query Language query across data.
REGEXEXTRACT	Extracts 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 a regular expression.
SORTN	Returns the first n items in a data set after performing a sort.
SPARKLINE	Creates a miniature chart contained within a single cell.
SPLIT	Divides text around a specified character or string, and puts each fragment into a separate cell in the row.
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.
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.

ADD Returns the sum of two numbers. Equivalent to the `+` operator.
ARRAY_CONSTRAIN Constrains an array result to a specified size.
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.
AVERAGE.WEIGHTED Finds the weighted average of a set of values, given the values and the corresponding weights.
COUNTUNIQUE Counts the number of unique values in a list of specified values and ranges.
DETECTLANGUAGE Identifies the language used in text within the specified range.
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.
FLATTEN Flattens all the values from one or more ranges into a single column.
GOOGLEFINANCE Fetches current or historical securities information from Google Finance.
GOOGLETRANSLATE Translates text from one language into another.
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.
IMLOG Returns the logarithm of a complex number for a specified base.
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.
IMTANH Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)."
ISBETWEEN Checks whether a provided number is between two other numbers either inclusively or exclusively.
ISDATE Returns whether a value is a date.
ISEMAIL Checks whether a value is a valid email address.
ISURL Checks whether a value is a valid URL.
JOIN Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
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.
NE Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator.
PERCENTIF Returns the percentage of a range that meets a condition.
POW Returns a number raised to a power.
QUERY Runs a Google Visualization API Query Language query across data.
REGEXEXTRACT Extracts 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 a regular expression.
SORTN Returns the first n items in a data set after performing a sort.
SPARKLINE Creates a miniature chart contained within a single cell.
SPLIT Divides text around a specified character or string, and puts each fragment into a separate cell in the row.
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.
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.