What-If Analysis


☞ What-If Analysis is the process of making a forecast on the basis of certain assumed values.

☞ It involves changing the values in cells in a particular manner to see how those changes will affect the outcome of formulas i.e. result in the worksheet

☞ OpenOffie Calc offers three types of What-If Analysis tools :

1. Scenarios
2. Goal Seek
3. Solver