Here's a list of all the functions available in each category. When using them, don't forget to add quotation marks around all function components made of alphabetic characters that aren't …

A function help box will be visible throughout the editing process to provide you with a definition of the function and its syntax, as well as an example for reference.

Historical data cannot be downloaded or accessed via the Sheets API or Apps Script. If you attempt to do so, you'll see a #N/A error in place of the values in the corresponding cells of …

Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, …

IF function Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Sample Usage IF(A2 = "foo","A2 is foo") IF(A2,"A2 was true","A2 was false") IF(TRUE,4,5) …

UNIQUE function Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Parts of a UNIQUE …

The LIST() expression constructs a list from any combination of raw values, column values, and expressions. The values in the resulting list will be in the order they were given to the LIST() …

Important: To reference a cell or range of cells in another spreadsheet, you must use the IMPORTRANGE function. To pull data from other spreadsheets, use the IMPORTRANGE …

A description of the function will show as you’re working on it to guide you through formula creation. To use the content of other cells in your formula equation, type the names of the cells …

Notes If only a single number for value1 is supplied, SUM returns value1. Although SUM is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number …