Question: I am working on an excel problem - with if statements involved - The formulas all appear to be corrrect but my scernario is not
I am working on an excel problem - with if statements involved - The formulas all appear to be \corrrect but my scernario is not coming out coorectly
I have three value input in three different cells - W, 1% and M - - The equation uses a 12% growth and 6% at the low endIf y
Scenario Manager
Once you have completed the template, you will need to run your DSS model through the Scenario Manager to generate all the possible combination of inputs and produce a tabular summary of the results
You will follow the same steps you learned in the DSS tutorial to set up the Scenario Manager, so you can refer back to the DSS tutorial walkthrough for guidance. For the case study, there are 12 possible combinations of inputs and you are interested in the same four outputs as the tutorial. Once you have constructed the scenario summary you will need to edit it in the same way you did in the tutorial. The figure below shows you what the first 11 columns of the scenario summary should look like. The summary should extend to column N
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
