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.

What-If Analysis tools

There are three What-If analysis tools that you can use. To access these, select the Data tab and locate the What-If Analysis command. If you click this command, a menu with three options appears.

Goal seek is useful if you know the needed result but need to find the input value that will give you the desired result. In this example, we know the desired result (a $400 monthly payment) and are seeking the input value (the interest rate).

Goal Seek

To use Goal Seek to determine an interest rate:

Select What-If Command
Goal Seek Example
Goal Seek Example
Goal Seek Example
Goal Seek End of Example