Google Sheets

The following functions are only available in Google Sheets.

ADD

Returns the sum of two numbers. Equivalent to the `+` operator.

link - support.google.com/docs/answer/3093590 

ARRAY_CONSTRAIN

Constrains an array result to a specified size.

link - support.google.com/docs/answer/3267036 

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.

link - support.google.com/docs/answer/3093275 

AVERAGE.WEIGHTED

Finds the weighted average of a set of values, given the values and the corresponding weights.

link - support.google.com/docs/answer/9084098 

COUNTUNIQUE

Counts the number of unique values in a list of specified values and ranges.

link - support.google.com/docs/answer/3093405 

COUNTUNIQUEIFS

Counts the number of unique values in a list of specified values and ranges depending on multiple criteria..

link - support.google.com/docs/answer/9584429 

DIVIDE

Returns one number divided by another. Equivalent to the `/` operator.

link - support.google.com/docs/answer/3093973 

EPOCHTODATE

Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.

link - support.google.com/docs/answer/13193461 

EQ

Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator.

link - support.google.com/docs/answer/3093593 

FLATTEN

Flattens all the values from one or more ranges into a single column.

link - support.google.com/docs/answer/10307761 

GOOGLEFINANCE

Fetches current or historical securities information from Google Finance.

link - support.google.com/docs/answer/3093281 

GOOGLETRANSLATE

Translates text from one language into another.

link - support.google.com/docs/answer/3093331 

GT

Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator.

link - support.google.com/docs/answer/3098240 

GTE

Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator.

link - support.google.com/docs/answer/3093975 

IMAGE

Inserts an image into a cell.

link - support.google.com/docs/answer/3093333 

Add a URL address for the image you want to display in the cell.
Also provide the height and width in pixels.
You also can tell it to resize the image to fit inside the cell.

IMLOG

Returns the logarithm of a complex number for a specified base.

link - support.google.com/docs/answer/9366486 

IMPORTDATA

Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

link - support.google.com/docs/answer/3093335 

IMPORTFEED

Imports a RSS or ATOM feed.

link - support.google.com/docs/answer/3093337 

IMPORTHTML

Imports data from a table or list within an HTML page.

link - support.google.com/docs/answer/3093339 

IMPORTRANGE

Imports a range of cells from a specified spreadsheet.

link - support.google.com/docs/answer/3093340 

IMPORTXML

Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

link - support.google.com/docs/answer/3093342 

IMTANH

Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)."

link - support.google.com/docs/answer/9366655 

ISBETWEEN

Checks whether a provided number is between two other numbers either inclusively or exclusively.

link - support.google.com/docs/answer/10538337 

ISDATE

Returns whether a value is a date.

link - support.google.com/docs/answer/9061381 

ISEMAIL

Checks whether a value is a valid email address.

link - support.google.com/docs/answer/3256503 

ISURL

Checks whether a value is a valid URL.

link - support.google.com/docs/answer/3256501 

JOIN

Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.

link - support.google.com/docs/answer/3094077 

LT

Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator.

link - support.google.com/docs/answer/3093596 

LTE

Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator.

link - support.google.com/docs/answer/3093976 

MARGINOFERROR

Calculates the amount of random sampling error given a range of values and a confidence level.

link - support.google.com/docs/answer/12487850 

MINUS

Returns the difference of two numbers. Equivalent to the `-` operator.

link - support.google.com/docs/answer/3093977 

MULTIPLY

Returns the product of two numbers. Equivalent to the `*` operator.

link - support.google.com/docs/answer/3093978 

NE

Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator.

link - support.google.com/docs/answer/3093981 

PERCENTIF

Returns the percentage of a range that meets a condition.

link - support.google.com/docs/answer/9983035 

POW

Returns a number raised to a power.

link - support.google.com/docs/answer/3093603 

QUERY

Runs a Google Visualization API Query Language query across data.

link - support.google.com/docs/answer/3093343 

REGEXEXTRACT

Extracts matching substrings according to a regular expression.

link - support.google.com/docs/answer/3098244 

REGEXMATCH

Whether a piece of text matches a regular expression.

link - support.google.com/docs/answer/3098292 

REGEXREPLACE

Replaces part of a text string with a different text string using a regular expression.

link - support.google.com/docs/answer/3098245 

SORTN

Returns the first n items in a data set after performing a sort.

link - support.google.com/docs/answer/7354624 

SPARKLINE

Creates a miniature chart contained within a single cell.

link - support.google.com/docs/answer/3093289 

Add a simple chart that reflects the data in a series of cells
Enter the range of cells inside parentheses.
The default chart is a line chart.
Other type of chart can be created by adding the CHARTTYPE subfunction, using brackets inside the parentheses, followed by the type of chart you want to use, including: Bar, Column, Win/loss

SPLIT

Divides text around a specified character or string, and puts each fragment into a separate cell in the row.

link - support.google.com/docs/answer/3094136 

SPLIT(Text, Delimiter)
Takes a text string consisting of two or more words and enters each word into its own cell. This simplifies sorting the data in alphabetical order.
You need to enter the character that designates where the text string should split (which is usually a blank space).
The first split-up word will appear in the cell where you enter the SPLIT function.
Additional split-up words will continue in cells along the same row to the right until all of the words appear.

TO_DATE

Converts a provided number to a date.

link - support.google.com/docs/answer/3094239 

TO_DOLLARS

Converts a provided number to a dollar value.

link - support.google.com/docs/answer/3094241 

TO_PERCENT

Converts a provided number to a percentage.

link - support.google.com/docs/answer/3094284 

TO_PURE_NUMBER

Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.

link - support.google.com/docs/answer/3094243 

TO_TEXT

Converts a provided numeric value to a text value.

link - support.google.com/docs/answer/3094285 

UMINUS

Returns a number with the sign reversed.

link - support.google.com/docs/answer/3093606 

UNARY_PERCENT

Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.

link - support.google.com/docs/answer/3093982 

UPLUS

Returns a specified number, unchanged.

link - support.google.com/docs/answer/3093608