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:

2M+

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

Bernardo Rojas Velarde

May 21, 2023

I tried all the solvers with google sheets.... this one its the only one that works PERFECTLY in my spreadsheets.... despite has several interconnected sheets tabs...obviously had to be from Google. You do, like always, an amazing job. thanks guys

Is this review helpful?

Yes

Carson Leung

April 20, 2023

This thing works, but scaling to a whole table is not supported. Another thing, the target value should be able to be dynamic. We're spreadsheeting here, come on!

Is this review helpful?

Yes

I E

February 23, 2023

Chris Kim's solution of clicking the green cell picker made this solver work again for me. It's not exactly fast, but it gets the job done for simple goals. It's OK.

Is this review helpful?

Yes

Thomas Ramée

October 19, 2022

Still not working... I made it work a year ago. It was pretty slow but got the job done. I think it would be nice to implement a free simple version by default, or offer it as a macro by default. There are plenty of work-arounds though, just google "Dynamic Goal Seek Sheet" and you will find how to do it yourself... one day Google will be able to do it too :D :D

Is this review helpful?

Yes

Chris Kim

November 15, 2022

It works. People just don't know how to use it correctly. For "Set Cell," and "By Changing Cell," you need to click on the cell with the number you want to add then CLICK on the 'capture target cell' button that's in the shape of 4 green squares. It'll then add the cell you had selected. Do the same for "By Changing Cell." For "To Value," you just need to type it in. Do not type in the values for "Set Cell," and "By Changing Cell." It won't work.

Is this review helpful?

Yes

Samuel Olvera

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

Tom Rose

September 12, 2022

Can't get it to work at all, no matter what I try. I'm not trying to do anything super complicated. Update: I tried incognito window as others suggested. I got it to go a little farther. Intead of failing at startup, I was able to make inputs and press solve, but I got the critical error: "Could not read or write data for the selected Set or Target cell. Please check your inputs and try again." There's no particular reason I can think of why these cells should be unreadable or unwritable. When I make my own scripts, they work just find with reading and writing in this setting.

Is this review helpful?

Yes

Benjamin Howard

October 25, 2022

Doesn't work at all in Chrome – throws an error (got it to work in Safari). Comically slow. Total incompetence.

Is this review helpful?

Yes

Gregory Holmberg

June 3, 2022

Doesn't meet my needs. 1. I need two "By Changing" cells. 2. My goal is to find a minimum value, not a pre-known value. Maybe I could set the "To Value" field to 0. Haven't tried it, since I can't do #1.

Is this review helpful?

Yes

Angus Thompson

April 2, 2023

Doesnt work - getting Error Identifier

Is this review helpful?

Yes

1-10 of 125

Clear search

Close search

Google apps

Main menu