| |
Scenarios
If you
have a formula or function that has an unknown variable as
part of it, the <One-Input
Table> will be sufficient. If you have more than one
unknown variable in your spreadsheet, you can set up a Scenario
that controls those cells in the formulas or functions that
you want. The Scenario Manager is located under the Tools
menu.
 |
We
can now select the two variable cells (C4 & C6) and choose
Scenarios from the Tools menu. This is done by clicking
on C4 and holding the [CTRL] key down while clicking C6. |
 |
Each
scenario consists of a name, a description (if desired)
and data for the variable cells. We'll create 3 scenarios:
one for Expected, one for Higher than Expected, and one
for Lower than Expected. |
For the
Expected scenario, the increase for 2000 will be 3.5%, and
the increase for 2001 will be 5%. For Higher than Expected,
the numbers are 7% and 10%, and 1%-2% for Lower than Expected.
<Click here>
to see a video which demonstrates the ability to double-click
on any scenario and see the results in the spreadsheet. (518K)
|
