Google Sheets function list Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create formulas that manipulate data and …

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.

A function used in the same cell with another function is called a nested function. When functions are combined, Google Sheets will calculate the innermost function first.

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) …

Named functions let you create custom functions that can use built-in Sheets formulas. We've added the ability to import named functions so you can use them in more than one sheet.

All three functions automatically check for updates every hour while the document is open, even if the formula and sheet don’t change. If you delete and re-add cells or overwrite the cells with …

The AI function doesn’t have access to your entire spreadsheet or other files in your Google Drive. To provide data or context to your prompt, add the data to your current spreadsheet and use …

OR: The OR function returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. NOT: Returns the opposite of a logical value - …

Want advanced Google Workspace features for your business? Try Google Workspace today! You can use functions and formulas to automate calculations in Google Sheets. You can …

Bring your best ideas to life with Google Workspace with Gemini. Get tips & real-life use cases for using gen AI at work.