Use the Excel Goal Seek tool to calculate existing formulas and data to achieve a specific goal for future performance. For example, say you have sales data for the first three quarters of a startup business, and you need to know how much sales you need to reach $ 50,000 a year in the fourth quarter.
It is actually quite simple, but this is the goal behind the mechanism. Goal Seek can be used for project projects such as totals, calculations and rates.
1. Select the Data tab, click What-if analysis, and select Goal Search.
2. Enter the cell reference that contains the estimated value in the Form and Value Value field for the target count in the Set Cell field.
For example, you are trying to figure out what goal to achieve in the fourth quarter in the amount of $ 50,000 per year. So, the reference cell is F7 (or $ F $ 7, for example in this case), which is the whole cell of the year.
The set cell field should compute the formula for the projection cell (ie the cell specified in the transformed cell field).
3. Enter the destination tag in the Transfer Cell field and click OK. The goal is to achieve a certain goal and achieve it.
In this example, you need to calculate the total fourth-quarter value of $ 50,000, so cell E7 needs to change the cell.
Note that this cell must be empty or have a value. Although that formula is valid, it does not contain the formula. So in this example, the entire 4th quarter calculation would have turned to zero (or even eliminating the formula). The cell must be represented somehow by the formula for counting the cell, i.e. the cell represented by the cell cell field.
4. Click OK to accept the new values in the specified cell by replacing the set cells and cell cells. Alternatively, if you are already satisfied with the project, click Cancel to save the specified data to the original data.
Before you click OK or Cancel, you can see that your goal is $ 7,060 per year to reach $ 50,000 in the 4th quarter. If you need it, click Cancel to return to their original values. Otherwise, clicking OK will place the values you see above.