Add Yet Another Scenario
Now there
are two Scenarios: Expected Price and Best Case. Here are the steps
to Add the Worst Case Scenario. When all 3 Scenarios are done,
you'll see how it works... and it really does work well.
5. Try
This: Add Yet Another Scenario
The
Scenario Manager is open.
Click on:
Add
You will
be prompted to fill in the blanks:
Scenario
Name: Worst Case
Changing
Cells: $B$1
You can
click on Cell B1, the Price, or type the reference. This is an
Absolute Reference.
Click
OK. When
you click on OK, the Scenario Manager will prompt you to enter a
new value for each reference cell.
Try
This, Too: Enter the Scenario Value
Scenario
Value for $B$1: 2.00
Keeeeeeep
going...