Add formulas faster and easier. Instead of searching for the formula you need and adding it manually, let Google Sheets add it for you with automatic suggestions.


Get an automatic formula

  1. In Sheets, open a spreadsheet with data.
  2. In the cell where you want to add the formula, enter the equal sign =.
    Formula suggestions might appear. Suggestions are based on contextual clues in your data.
  3. Click the formula you want.

To learn how to create custom formulas, see Create custom functions and macros in spreadsheets.