Once installed any add-on in Sheets, it resides as a menu item under the ‘Add-ons’ menu. Goal Seek Official Sheets Add-on Settings and Usage Tips
In certain cases, we know the result that we want from a formula like the total invoice value (in case you set a target to invoice) but don’t know how to get that required value by changing the quantity or rate.įor example, let’s consider the below-unformatted invoice. Use Goal Seek to tune/get the result you need from a formula by finding the missing value or modifying the existing value. Before that let me introduce, for those who are unfamiliar with it, the purpose of Goal Seek in Google Sheets. I will give you the link to install the official (yes, it’s from Google) Goal Seek add-on in Google Sheets. Install the add-on to use it as a menu item in Docs Sheets. Because it’s only available as an official Google Sheets add-on. But you won’t find the Goal Seek in Google Sheets under any menu items. Goal Seek is part of the Data menu what-if analysis tools in Excel.