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:
3M+
Overview
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 support.google.com/docs/answer/9506732.
Additional information
PricingFree of charge
Developer
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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Victor Saidanis
July 6, 2024
The add on is far from perfect. Maybe it works well with simple spreadsheets. On a spreadsheet with complex functions (IF, IFS) with multiple arguments, protected cells and shared with others it performs poorly and unreliably. As if they made it for kids to play around. Really a disappointment!!!!
Is this review helpful?
Yes
No
Profile Picture
Conrad Dunkerson
February 12, 2024
Works fine. Very similar to Excel goal seek. Most people are either failing to give the extension permission to access Sheets, not specifying the three components correctly, or some other form(s) of human error. You need to specify a cell with a formula (e.g. "=E7*4"), a cell which is a component of that formula (e.g. "E7"), and a value you want the formula cell to be changed to by adjusting the component cell (e.g. "100"). In the example, E7 should iterate until reaching a value of 25... causing the formula cell to have a value of 100.
Is this review helpful?
Yes
No
Profile Picture
Juan David Guerrero
September 1, 2024
Too slow even for a simple calculation. Once started it just doesn't stop
Is this review helpful?
Yes
No
Profile Picture
Josh Davis
April 9, 2024
This extension doesn't work. When I open it from Extensions -> Goal Seek -> Open, the error is An unknown system error has occurred. If this issue persists please leave us feedback Error identifier: erroridentifier-2024-04-09T17:12:35.961Z Also I see this in the browser console: {message: "Error code = 10, Path = /wardeninit, Message = There was an error during the transport or processing of this request., undefined", name: "TransportError", stack:"D@https://docs.google.com/static/macros/client/js/3093671068-warden_bin_i18n_warden.js:34:512\nKq@https://docs.google.com/static/macros/client/js/3093671068-warden_bin_i18n_warden.js:226:496\nx.Wc@https://docs.google.com/static/macros/client/js/3093671068-warden_bin_i18n_warden.js:234:378\nUh@https://docs.google.com/static/macros/client/js/3093671068-warden_bin_i18n_warden.js:115:228\nSh@https://docs.google.com/static/macros/client/js/3093671068-warden_bin_i18n_warden.js:113:42\nOh.prototype.A@https://docs.google.com/static/macros/client/js/3093671068-warden_bin_i18n_warden.js:112:449\nUh@https://docs.google.com/static/macros/client/js/3093671068-warden_bin_i18n_warden.js:115:228\nSh@https://docs.google.com/static/macros/client/js/3093671068-warden_bin_i18n_warden.js:113:42\nPq/b.Va<@https://docs.google.com/static/macros/client/js/3093671068-warden_bin_i18n_warden.js:233:160\nbq@https://docs.google.com/static/macros/client/js/3093671068-warden_bin_i18n_warden.js:206:294 ... \nel.onload@https://docs.google.com/macros/d/MLdWSTxb1nkuommyF1mfIhQBcAPWLxkBf/iframedAppPanel?eei=ACZUs ... jbG0&mid=ACjPJ ... 9voo:17:2\n"}
Is this review helpful?
Yes
No
Profile Picture
Lance
June 13, 2024
Hopeless App - Doesn't work or even load. Keep getting an error "Message details We're sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED." It's back to Excel for me.
Is this review helpful?
Yes
No
Profile Picture
Rishika Jain
May 22, 2024
It does not work after installing. The extension shows up, but has only "help" shown, on click - nothing happens.
Is this review helpful?
Yes
No
Profile Picture
Tudor Patroi
April 30, 2024
does the job but it is very slow like 30s to solve something easy which Excel does instantly
Is this review helpful?
Yes
No
Profile Picture
Stephen Mullins
May 13, 2024
Doesn't work
Is this review helpful?
Yes
No
Profile Picture
Jeff Trowbridge
May 1, 2024
This worked perfectly, founding a solution to 4 decimal places in less than 8 seconds. The options tab allow you to change the maximum iterations used as well as the accuracy and time limit. There were no errors as other people are commenting on, and you can watch the values change in real time as it does its magic!
Is this review helpful?
Yes
No
Profile Picture
Jordan Hidajat
January 11, 2024
does not work, couldn't even press the 'solve' button
Is this review helpful?
Yes
No
1-10 of 116
Search
Clear search
Close search
Google apps
Main menu