Scenarios

Hello Samantha

Thank you for your question and welcome to the forum.

When working with scenarios, it is a good idea to save the original spreadsheet that you start with as a scenario first.

To do this:

1. Go to Tools - Scenarios.

2. Then click the Add button.

3. Enter a name for your scenario.

4. In the changing cells box, select the cell or cells you will be altering in other scenarios that you will be creating to compare with the original version of the spreadsheet you are saving now.

5. Click OK.

6. At the next screen, you don't need to change the values in any of the cells you have selected to change, just click OK.

This then brings you back to the first Scenarios window.

To create additional scenarios, follow steps 2 through to 6, entering the values that you want to change in your changing cells at step 6.

To view various scenarios, go to Tools - Scenarios, select the scenario you want to view and click Show.

I hope this helps.
Amanda