|
|
|
Exhibit 16
|
|
|
You can choose to see the report in a side-by-side Scenario Summary format or a PivotTable format.
|
|
|
|
Exhibit 17
|
|
|
Excel generates the Scenario Summary report automatically.
|
|
|
|
Exhibit 18
|
|
|
Goal Seek calculates the variables that will achieve your goal.
|
|
|
|
Exhibit 19
|
|
|
Enter the data so Excel can calculate how to reach the goal.
|
|
|
|
Exhibit 20
|
|
|
Goal Seek automatically reports the goal-seek answer.
|
|