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 …

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.

Goal Seek works differently from scenarios and data tables in that it takes a result and determines possible input values that produce that result. Like scenarios, data tables help you explore a …

If you know the result to expect from a formula, but don't know precisely what input value the formula needs to get that result, use the Goal-Seek feature. See the article Use Goal Seek to …

Oct 14, 2025 · Use Solver, a Microsoft Excel add-in program you can use for what-if analysis, to determine an optimal product mix.

Use Solver to find an optimal (maximum or minimum) value for a formula in one cell—called the objective cell—subject to constraints, or limits, on the values of other formula cells on a …

The AND function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE. One common use for the AND function is to expand …

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.

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.