App Icon
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:July 5, 2022
Works with:
2,376,875
Overview
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. You can use it to conduct break-even analysis, or determine subcomponent targets when modeling future outcomes. You can also modify parameters that Goal Seek uses to determine a solution or load previous calculations.

** This add-on is made by Google Cloud.  Add-ons are covered by the Google Terms of Service (https://policies.google.com/terms) and Privacy Policy (https://policies.google.com/privacy),  as well as the End Users Using Scripts or Add-ons. (https://developers.google.com/apps-script/terms#end_users_using_scripts_or_add-ons)
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
Zakiah Abd Basri
December 25, 2020
It doesn't work :(
Is this review helpful?
Yes
No
Profile Picture
A User of Goal Seek
June 19, 2020
Doesn't work for me
Is this review helpful?
Yes
No
Profile Picture
Alistair Hughes
February 26, 2021
Works as well as Goal Seek in Microsoft's Excel. It's a little counterintuitive in that you have to click the cell you want to use first, then the option to use that cell; whereas in MS Excel you'd click the button to select a cell and then choose the cell. Basically, just make sure you have the correct cells selected for the value to check and the value to alter, and set your options correctly to allow it to complete.
Is this review helpful?
Yes
No
Profile Picture
Georgia Owusu
November 17, 2020
not working.
Is this review helpful?
Yes
No
Profile Picture
matt jones
August 30, 2020
it does work, it works well, and yes it is a bit slow. But it can be quite fun to watch it's progress. It is certainly faster than me doing it myself by trial and error. thumbs up.
Is this review helpful?
Yes
No
Profile Picture
Samuel G. Olvera Gómez
October 12, 2022
For everyone that are receiving some errors, here you have some notes: - As someone said before, it only works when you have 1 Google session in Chrome - After that, you need to be sure that in the "Set Cell" you have a formula that will be used by the Goal Seek to make the changes. Example:"The sum of some cells". As soon as you have it, select the cell that will be changed and it will work It took me some tests to come to this conclusion. I hope it can help you.
Is this review helpful?
Yes
No
Profile Picture
A User of Goal Seek
October 9, 2019
NOICE
Is this review helpful?
Yes
No
Profile Picture
A User of Goal Seek
May 13, 2020
Though there are some complications in using Google sheet. This goal seek is an useful tool for playing with numbers and analysis
Is this review helpful?
Yes
No
Profile Picture
Ryan
July 6, 2022
They added permissions to have full access to all your sheets. I'm uninstalling because of this. It worked well, but now I'm forced to update or remove.
Is this review helpful?
Yes
No
Profile Picture
John Reed
March 17, 2022
Only works in incognito mode, for me.
Is this review helpful?
Yes
No
1-10 of 120
Search
Clear search
Close search
Google apps
Main menu