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.

Tip: If you’re already familiar with functions and formulas and just need to know which ones are available, go to Google Sheets function reference.

To get an example spreadsheet and follow along with the video, click “Make a Copy” below.

Make a copy

Use a formula

  1. Open a spreadsheet.
  2. Type an equal sign (=) in a cell and type in the function you want to use. 

Note: You may see suggested formulas and ranges based on your data.

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. If you need more information, click the “Learn more” link at the bottom of the help box to open a full article.

Tip: You might get suggestions to help you complete formulas with the relevant functions. You can accept or reject these suggestions.

To turn formula suggestions on or off, at the top, click Tools Next Suggestion controls and then Enable formula suggestions.

You might find correction suggestions in previously compiled data and analyses, to improve confidence in insights. You can accept or reject these suggestions.

To turn formula corrections on or off, at the top, click Tools and then Suggestion controls and then Enable formula corrections.

 

Additional features for creating formulas

true
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, create dynamic project plans and team calendars, auto-organize your inbox, and more.

9630226137638202059
true
Search Help Center
true
true
true
true
true
35
false
false
false
Search
Clear search
Close search
Main menu