Goal Seek Tool in Excel

Goal Seek Tool can perform what-if analysis in excel. In Excel 2007, we have goal seek tool under Data -> What-If analysis.

First , write two variable variable1 and variable 2 and calculate their product in cell B10. Cell B10 has the required formula to perform the calculation.

Let us say we wanted the product of variable1 and variable2 to be 165 keeping variable1 constant.

Excel can automatically calculate the other value. We will show you how. This was just a simple calculation exmaple. One can perform complex calculations using goal seek tool.

Go to Goal Seek Tool.

Click Ok.

Click Ok again.



As you can see, variable2 is modified to give you the desired answer. To get a product of 165, cell B8 is modified to 11.