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.
COUNTUNIQUEIFS	Counts the number of unique values in a list of specified values and ranges depending on multiple criteria.
DIVIDE	Returns one number divided by another. Equivalent to the `/` operator.
EPOCHTODATE	Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.
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.
MARGINOFERROR	Calculates the amount of random sampling error given a range of values and a confidence level.
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.
REGEXTEST	Returns return True or False depending if the pattern matches any part of a text string.
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.
COUNTUNIQUEIFS Counts the number of unique values in a list of specified values and ranges depending on multiple criteria.
DIVIDE Returns one number divided by another. Equivalent to the `/` operator.
EPOCHTODATE Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.
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.
MARGINOFERROR Calculates the amount of random sampling error given a range of values and a confidence level.
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.
REGEXTEST Returns return True or False depending if the pattern matches any part of a text string.
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.