What - If Analysis... Scenarios...
Ilgar Zarbaliyev
Senior Manager @ SumProduct Pty Ltd. | Microsoft ?MVP | MCT Community Lead
By using What-If Analysis tools in Excel, you can use several different sets of values in one or more formulas to explore all the various results.
For example, you can do What-If Analysis to build two budgets that each assumes a certain level of revenue. Or, you can specify a result that you want a formula to produce, and then determine what sets of values will produce that result. Excel provides several different tools to help you perform the type of analysis that fits your needs.
A Scenario is a set of values that Excel saves and can substitute automatically in cells on a worksheet. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results.
For example, suppose you have two budget scenarios: a worst case and a best case. You can use the Scenario Manager to create both scenarios on the same worksheet, and then switch between them. For each scenario, you specify the cells that change and the values to use for that scenario. When you switch between scenarios, the result cell changes to reflect the different changing cell values.
Good Luck...