What-if Analysis

In Excel what if analysis lets you answer questions with data. With what if analysis Excel also lets you experiment with data.

Other types of what-if analysis

For more advanced projects, you may want to consider the other types of what-if analysis: scenarios and data tables. Instead of starting from the desired result and working backward, like with Goal Seek, these options allow you to test multiple values and see how the results change.

For more information on scenarios, check out this article from Microsoft.

For more information on data tables, check out this article from Microsoft.