Using Goal Seek Target Tools

An Excel file that teaches how to perform Using Goal Seek Target Tools operation.

Excel Using Goal Seek Target Tools

The cell containing the desired result and the input cell affecting this result are identified. The Goal Seek tool, located under "What-If Analysis" in the Data tab, is run. The tool automatically calculates the input value required for the specified formula to reach the desired result. This feature is frequently used in areas such as budgeting, credit calculation, and reverse engineering. The calculation result is placed in the target cell.

Hope it is useful.