Goal Seek - Google Workspace Marketplace

google.com

• 1,234,198

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.

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)

Reviews

Language:

Sort by:

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

Amber Alaniz

February 22, 2021

It won't compute the answer correctly.

Is this review helpful?

Yes

Myles Ewen

January 27, 2021

Doesn't even load, just gives this message: "An unknown system error has occurred. If this issue persists please leave us feedback"

Is this review helpful?

Yes

William Hunter

January 25, 2021

It's much slower than Excel's, but it works.

Is this review helpful?

Yes

Charles Uy

January 21, 2021

Doesn't work

Is this review helpful?

Yes

jamsed Sarder

January 21, 2021

super

Is this review helpful?

Yes

Tim Sloane

January 20, 2021

I don't know why so many reviews are saying it's broken. Maybe you should give more details. For instance, it works perfectly for me and I'm running in a Chrome browser on a PC. It's a lot slower than Excel which is why I give it 4 stars, but it works fine otherwise.

Is this review helpful?

Yes

Sharon Corkery

January 9, 2021

I am a teacher moving all of my lesson plans from MS Excel to Google Sheets to better facilitate remote learning for students using Chromebooks. I was concerned that I would not be able to teach exactly the same lessons. I have had to make some alterations but was pleased to find that the Goal Seek add on allows me to teach students to create budgets almost exactly the same way I do in Excel.

Is this review helpful?

Yes

Ruiwei Zhang

December 30, 2020

Sucks！

Is this review helpful?

Yes

Ramachandran Nagaraj

December 28, 2020

Did not even start. Threw some error messages and it did not work.

Is this review helpful?

Yes

1-10 of 79

Additional information

google.com

Clear search

Close search

Google apps

Main menu