Microsoft Office Tutorials and References
In Depth Information
Browsing your scenarios
In each text box in the Scenario Values dialog box, you can type either a constant
or a formula. For example, to increase the value of the first variable in Figure
18-11, click in front of the value in the first variable’s box, and type =1.1 * to
create a formula that multiplies the current value by 1.1. (Note that although
you can type formulas in the Scenario Values dialog box, Excel alerts you that the
formulas are converted to their resulting values after you click OK.)
To create another scenario, click Add to return to the Add Scenario dialog box.
Browsing your scenarios
Select a scenario name in the Scenario Manager dialog box, and click Show. The Scenario
Manager replaces the variable values currently on the worksheet with the values you
specified when you created the scenario. In Figure 18-12, the example worksheet has a scenario
showing average customer visits increased by 5 percent and revenues per customer visit
decreased by 5 percent.
The Scenario Manager dialog box remains on the screen after you click the Show button
so that you can look at the results of other scenarios without returning to the worksheet. If
you click Close or press Esc to close the Scenario Manager dialog box, the values from the
last scenario you browsed remain on the worksheet. (This is a good reason to create a
starting values scenario, as mentioned earlier.)
Figure 18-12 Clicking Show replaces your current worksheet values with the values of a specified
Search JabSto ::

Custom Search