Microsoft Office Tutorials and References
In Depth Information
Varying your data to get a specific result by using Goal Seek
In this exercise, you’ll use Goal Seek to determine how much you need to decrease
transportation costs so that those costs make up no more than 40 percent of Consolidated
Messenger’s operating costs.
SET UP You need the TargetValues workbook located in the Chapter08 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
On the Data tab, in the Data Tools group, click the What-If Analysis button, and
then, in the list, click Goal Seek to open the Goal Seek dialog box.
In the Set cell field, enter D4 .
In the To value field, enter 40% .
In the By changing cell field, enter D3 .
Click OK to display the solution in both the worksheet and the Goal Seek Status
dialog box. The target value of 0.4 is equivalent to the 40 percent value you entered
Click Cancel to close the Goal Seek Status dialog box without saving the new
CLEAN UP Close the TargetValues workbook, saving your changes if you want to.