User Guide

or variable values plugged into a model and the values that result. For example, a worst-case
scenario shows what you can expect from the least desirable set of variable values; a best-case
scenario uses the most desirable values as input. Scenarios are often used to find the optimum
solution to a problem.
Before using scenarios, you have to create a data model that includes formulas and supporting
data.
To create a scenario
1 Click Tools } Scenario } New.
2 Click the Range picker in the Changing cells box, and select the changing cells.
3 Click Next.
4 Type a name in the Scenario name box.
5 Type a value for each changing cell in the Changing cells and their values boxes.
6 Click Add scenario.
7 Click Next.
8 Click Show scenario.
To create a scenario group
1 Click Tools } Scenario } Edit.
2 Click Settings.
3 In the Scenario group settings dialog box, click New.
4 In the New group dialog box, type a name in the New group name box.
To display a scenario
1 Click Tools } Scenario } Edit.
2 Choose a scenario group from the Scenario groups list box.
3 Choose a scenario from the Scenarios list.
From here
For more information about... In the online Help Index, type...
Managing scenarios scenarios, managing
Creating one-variable What-If tables What-If tables, one-variable
Creating two-variable What-If tables What-If tables, two-variable
Using goal seeking goal seeking
Finding optimum solutions for linear and
non-linear problems
Optimizer
Analyzing data 217