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:September 30, 2021
Works with:
1,524,867
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
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:
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
A User of Goal Seek
October 9, 2019
NOICE
Is this review helpful?
Yes
No
Profile Picture
M J R Chowdary
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
A User of Goal Seek
May 8, 2020
I cannot get it to work in Google Sheets
Is this review helpful?
Yes
No
Profile Picture
Georgi Tsochev
August 15, 2020
its nothing
Is this review helpful?
Yes
No
Profile Picture
Matthew Hubbard
July 28, 2021
It does not work. Just errors out and tells you to leave feedback so I did.
Is this review helpful?
Yes
No
1-10 of 100
Search
Clear search
Close search
Google apps
Main menu