Search notes:
Excel: Data -> Forecast -> What-If Analysis
There are three types of
What-If Analysis:
- Scenario Manager…
- Goal Seek…
- Data Table…
Scenarios and data tables use sets of input values to calculates possible results.
Goal-seek comes from the opposite direction: it calculates possible input values that produce a given output value.