Microsoft Office Tutorials and References
In Depth Information
Varying your data to get a specific result by using Goal Seek
IMPORTANT If you save a workbook with the results of a Goal Seek calculation in place, you
will overwrite the values in your workbook.
In the dialog box, you identify the cell that has the target value; in this example, it is cell C4,
which has the percentage of costs accounted for by the Labor category. The To Value field
has the target value (.2, which is equivalent to 20 percent), and the By Changing Cell field
identifies the cell that has the value Excel should change to generate the target value of 20
percent in cell C4. In this example, the cell to be changed is C3.
Clicking OK tells Excel to find a solution for the goal you set. When Excel finishes its work,
the new values appear in the designated cells, and the Goal Seek Status dialog box opens.
TIP Goal Seek finds the closest solution it can without exceeding the target value. In this
case, the closest percentage it could find was 19.97 percent.