You can install the Goal Seek plugin two ways in Google Sheets. I have already made it clear that to get the Goal Seek, you need to install an official Google add-on for Sheets.
USE GOAL SEEK IN EXCEL FOR MAC HOW TO
How to Get Excel Similar Goal Seek in Google Sheets It’s similar to the Goal Seek under the What-If Analysis in Excel but maybe a little slow if you go for performance comparison. You can easily do that using the Goal Seek in Google Sheets. In this invoice, I want to reduce the Gross Amount to the tune of $430,000.00 (in cell D5) by changing the quantity (in cell B2) of the item ‘Dolomite in Bulk, Size 40-80 mm’. 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.