The Goal Seek add-on for Google Sheetsᵀᴹ enables users to calculate the required value of a cell to achieve a desired formula value in another cell.
Listing updated:May 11, 2023
Works with:
If you know the result you need from a formula, you can use the Goal Seek add-on to find the missing value needed to achieve it.
You can use the add-on to conduct break-even analysis, or determine subcomponent targets when modeling future outcomes. You can also modify parameters, like max iterations, tolerance and max execution time that Goal Seek uses to determine a solution or load previous calculations.

There are three components to configure:
- the target value 
- the changing cell (where the formula is)
- the output value to achieve

Learn more about the add-on on
Additional information
PricingFree of charge
Privacy policy
Terms of service
Goal Seek will ask for the permissions shown below. Learn more
Goal Seek will need access to your Google account
This will allow Goal Seek to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Clear search
Close search
Google apps
Main menu