Microsoft Office Tutorials and References
In Depth Information
Plug Multiple Input Values into a Formula
Chapter 5: Analyzing Excel Data
The Scenario Manager
dialog box appears.
5 Click Add.
The Add Scenario dialog
6 Type a name for the
7 Click inside the Changing
Cells text box.
8 Select the cells you want
to change in the scenario.
9 Type a description for the
0 Click OK.
When you are building a worksheet model
for use with scenarios, there are a couple
of techniques you can use to make the
model more suited to scenarios. First, it is
useful to group all your changing cells in
one place and label them. Second, make
sure that each changing cell is a constant
value. If you use a formula for a changing
cell, another cell could change the formula
result and throw off your scenarios.
Once you have one or more scenarios
defined, they appear in the Scenario
Manager, and for each scenario, you
see its changing cells and its description.
The description is often very useful,
particularly if you have several scenarios
defined, so be sure to write a detailed
description in step 9 to help you
differentiate your scenarios later on.