|
Topic 39: Demostration of using scenario Manager in Excel 2003 |
Views: 4413
|
Thread Tools | Rate Thread |
#1
|
|||
|
|||
Topic 39: Demostration of using scenario Manager in Excel 2003
However it allows you to change multiple cells in order to see changes (not just one as is the case with Goal Seek). One of the advantages of scenarios is that they are kept for later reference and can be printed in summary form.
Scenario Manager - An Example Look at the illustration below. We will use it to illustrate the Scenario Manager. The cell E3 contain the formula =C3*D3% The cell E4 contain the formula =C4*D4% The cell E5 contain the formula =C5*D5% The cell E6 contain the formula =C6*D6% The cell E7 contain the formula =SUM(E3:E6) The cell C7 contain the formula =SUM(C3:C6) |
#2
|
|||
|
|||
We are going to create scenarios for the following situations:
|
#3
|
|||
|
|||
|
#4
|
|||
|
|||
|
#5
|
|||
|
|||
|