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. Note: Goal Seek works with only one variable input value.
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 set of possible outcomes.
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 find the result you want by adjusting an input value.
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 the usefulness of other functions that perform logical tests.
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 worksheet.
