Goal Seek - Google Workspace Marketplace

google.com

• 1,322,926

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:

Bernardo Simões

March 30, 2021

Doesn't seem to work it is always saying: "An unknown system error has occurred. If this issue persists please leave us feedback" Someone is saying you can only use it in your "main account". Is this your /u/0 user? you can't use it with other users?

Is this review helpful?

Yes

Rui Almeida

March 30, 2021

Getting this error everytime i want to use it... "An unknown system error has occurred. If this issue persists please leave us feedback"

Is this review helpful?

Yes

Marco Caron

March 17, 2021

Works perfectly from my experience

Is this review helpful?

Yes

ANGELICA BARBOSA

March 14, 2021

This tool is complicated, if you are one of those who appears the error: "An unknown system error has occurred. If this problem persists, leave us your comments", this is because you do not have the spreadsheet open in your main account (to use the tool you must be in your main account) you have to use the cell selector, if you try to write the cell names it will throw you another error. Finally, yes, it is slower than Microsoft Excel tool, but it works :)

Is this review helpful?

Yes

Joao Vassalo

March 7, 2021

Doesn't work :( just gives the following message: "An unknown system error has occurred. If this issue persists please leave us feedback"

Is this review helpful?

Yes

Rui Almeida

March 30, 2021

same here.

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

1-10 of 84

Additional information

google.com

Clear search

Close search

Google apps

Main menu