Using 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. Rather than start from the desired result and working backward like with Goal Seek, you can use these options 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.