Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create formulas that manipulate data and calculate strings and numbers. Here's a list …

TRUE SWITCH XOR function 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 …

Add formulas & functions 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’t generate content with the AI function if you access Sheets with other cloud storage providers like Box, Dropbox, or Egnyte with Google Drive. Learn how to use Google Docs, Sheets & Slides …

QUERY function Runs a Google Visualization API Query Language query across data. Sample Usage QUERY(A2:E6,"select avg(A) pivot B") QUERY(A2:E6,F2,FALSE) Syntax QUERY(data, query, …

Use the AI function in Google Sheets (Workspace Labs) Important: This article refers to Google Workspace Labs, which is a trusted tester program for users to try new AI features. To check if you …

Although MIN is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function. Each value argument must be a cell, a number, or a range …

See the sum & average IF function QUERY function COUNTIF VLOOKUP Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and …

YEAR YEARFRAC EPOCHTODATE function 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 …

Help Center Community Gemini in Docs Editors Google Docs Editors Functions and formulas Google Sheets function list LET function