Google Sheets

The following functions are only available in Google Sheets.

ADDReturns the sum of two numbers. Equivalent to the `+` operator.
ARRAY_CONSTRAINConstrains an array result to a specified size.
ARRAYFORMULAEnables 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.WEIGHTEDFinds the weighted average of a set of values, given the values and the corresponding weights.
COUNTUNIQUECounts the number of unique values in a list of specified values and ranges.
DETECTLANGUAGEIdentifies the language used in text within the specified range.
DIVIDEReturns one number divided by another. Equivalent to the `/` operator.
EQReturns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator.
FLATTENFlattens all the values from one or more ranges into a single column.
GOOGLEFINANCEFetches current or historical securities information from Google Finance.
GOOGLETRANSLATETranslates text from one language into another.
GTReturns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator.
GTEReturns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator.
IMAGEInserts an image into a cell.
IMLOGReturns the logarithm of a complex number for a specified base.
IMPORTDATAImports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.
IMPORTFEEDImports a RSS or ATOM feed.
IMPORTHTMLImports data from a table or list within an HTML page.
IMPORTRANGEImports a range of cells from a specified spreadsheet.
IMPORTXMLImports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.
IMTANHReturns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)."
ISBETWEENChecks whether a provided number is between two other numbers either inclusively or exclusively.
ISDATEReturns whether a value is a date.
ISEMAILChecks whether a value is a valid email address.
ISURLChecks whether a value is a valid URL.
JOINConcatenates the elements of one or more one-dimensional arrays using a specified delimiter.
LTReturns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator.
LTEReturns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator.
MINUSReturns the difference of two numbers. Equivalent to the `-` operator.
MULTIPLYReturns the product of two numbers. Equivalent to the `*` operator.
NEReturns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator.
PERCENTIFReturns the percentage of a range that meets a condition.
POWReturns a number raised to a power.
QUERYRuns a Google Visualization API Query Language query across data.
REGEXEXTRACTExtracts matching substrings according to a regular expression.
REGEXMATCHWhether a piece of text matches a regular expression.
REGEXREPLACEReplaces part of a text string with a different text string using a regular expression.
SORTNReturns the first n items in a data set after performing a sort.
SPARKLINECreates a miniature chart contained within a single cell.
SPLITDivides text around a specified character or string, and puts each fragment into a separate cell in the row.
TO_DATEConverts a provided number to a date.
TO_DOLLARSConverts a provided number to a dollar value.
TO_PERCENTConverts a provided number to a percentage.
TO_PURE_NUMBERConverts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.
TO_TEXTConverts a provided numeric value to a text value.
UMINUSReturns a number with the sign reversed.
UNARY_PERCENTReturns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.
UPLUSReturns 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.
IMAGE
Inserts an image into a cell.
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.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext