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.
By:
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
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
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
Drew Torres
January 30, 2026
Here are my main gripes with the current Goal Seek add-on in Google Sheets, especially as someone with an investing background who’s used to Excel and likes minimizing clicks: 1. It doesn’t have a keyboard shortcut. In Excel I can hit Alt + A, W, G and go. In Sheets I have to open the add-on menu every time. That kills flow and adds friction. 2. It doesn’t auto-populate. In Excel the Goal Seek dialog auto-populates information based on the cells you're on or click into. In Sheets I have to re-enter everything every time. 3. It needs to work reliably. The current version often fails or doesn’t converge - especially if-based logic like SUMIFS - which makes it hard to trust. Bonus gripe (minor): I also don't like that it pops up in the right hand side and isn't movable like in Excel. In case helpful, ended up doing more searching and found another Goal Seek Chrome extension that better mimics Excel. It's on the Chrome Extension store - not Google Workspace Marketplace. It's called SheetWhiz.
Is this review helpful?
Yes
No
Profile Picture
sahith s
February 2, 2026
doesnt work, this is a basic function i would argue for any spread sheet, given how aggressively google keeps pushing sheets and its office solution its sad to see the solve provided is so half baked. buying a licence from the enemy thanks to my experience with this add on.
Is this review helpful?
Yes
No
Profile Picture
Bob Newell
October 20, 2025
This works very well, as others have said, if you actually read the directions and actually follow them. I had it up and running and doing exactly what I needed in just a few minutes. It is a little slow in starting up, and it would be nicer if this was a formula rather than a fill-in form. Solving is not super speedy but for the scope of what's here (basically single slack variable unconstrained optimization) it is certainly fast enough. This is a decent add-on that could be improved but nevertheless does exactly what it is advertised to do. If you're having trouble, read the directions next time.
Is this review helpful?
Yes
No
Profile Picture
Sol Kaffel
September 19, 2025
Absolutely useless, embarrassing that this would even be made available to the public. Use Excel.
Is this review helpful?
Yes
No
Profile Picture
Nguyen Hoang Xuan Ha - HR2B
January 15, 2026
It calculates wrong result. Developer of Google need to fix your tool and combine into google sheet
Is this review helpful?
Yes
No
Profile Picture
Steve Urbanski
June 20, 2025
Doesn't work, even for the simple cases. Complete garbage and waste of time.
Is this review helpful?
Yes
No
Profile Picture
ALI ASLAM
January 30, 2026
Very good app
Is this review helpful?
Yes
No
Profile Picture
Steven Tanjaya
March 8, 2026
Error after one use, it's not helping, in the end, I need to approx by myself
Is this review helpful?
Yes
No
Profile Picture
Promise Shikobya
February 24, 2026
BAD AS AT NOW
Is this review helpful?
Yes
No
Profile Picture
Amr Desoky
August 7, 2025
IT didn't work although it worked perfectly on same sheet on microsoft office
Is this review helpful?
Yes
No
1-10 of 117
Search
Clear search
Close search
Google apps
Main menu