Goal Seek - Google Workspace Marketplace

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

ReportFlag as inappropriate

Reviews

Language:

Sort by:

Google doesn't verify reviews or ratings. Learn more about reviews

Gilad Bonjack

January 9, 2025

Really bad. Just doesn't work even in simple testing scenarios

Is this review helpful?

Yes

Pierre-Marie de Haut de Sigy

November 5, 2024

3 seconds computation time, 10 seconds total for a simple 2*x=9 solve. Not acceptable

Is this review helpful?

Yes

Tom Rose

September 26, 2024

I have tried to use this 3 times. I have never been able to get it to work. I get critical errors every time. I'm not trying to do anything complicated. A simple solve, with ony 2 cells involved, normal, positive numbers. Regular numbers. Regular tolerances. This is a horrible app that should be deleted and/or built again from scratch.

Is this review helpful?

Yes

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

Xavier Chauderlot

October 12, 2024

Option greyed out not usable. Quicker to derive the analytic solution with paper and pen than to find an how to guide

Is this review helpful?

Yes

Zanno A

December 17, 2024

i'm losing my mind trying to install this thing. i'm following the instructions exactly to install it on android and it's just not there.

Is this review helpful?

Yes

Dave Treanor

October 12, 2024

Works great! Previous users that rate it poorly apparently didn't read directions. For quicker results, adjust calculation tolerance from default 0.00001 to something greater. Cheers!

Is this review helpful?

Yes

Sonny Leffin

February 4, 2025

Kept getting errors saying I was trying to rename the sheet when I was definitely not doing that

Is this review helpful?

Yes

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

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

1-10 of 111