On the Data tab, in the Forecast group, click What-If Analysis, and then click Goal Seek. In the Set cell box, enter the reference for the cell that contains the formula that you want to resolve.

You can use Goal Seek to determine what interest rate you must secure in order to meet your loan goal. Cells B1, B2, and B3 are the values for the loan amount, term length, and interest rate.

The Solver add-in is similar to Goal Seek, but it can accommodate more variables. You can also create forecasts by using the fill handle and various commands that are built into Excel.

You can use Goal Seek when you know the desired result of a single formula but not the input value the formula needs to determine the result.

The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. To use the Solver Add-in, however, you first need to load it in Excel.

You can use a few other Excel tools to perform what-if analysis if you have specific goals or larger sets of variable data. If you know the result to expect from a formula, but don't know precisely …

The physicists involved in this work were big fans of gambling, so they gave the simulations the code name Monte Carlo. In the next five chapters you will see examples of how you can use …

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell—called the objective …