Show All

Hide All

If you know the result you want from a formula, but not the input value the formula needs to get that result, you can use the Goal Seek feature. For example, use Goal Seek to change the interest rate in cell B3 until the payment value in B4 equals ($900.00).

1. On the Tools menu, click Goal Seek.
2. In the Set cell box, enter the reference for the cell that contains the formula (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).) you want to resolve. (In the example, this is cell B4.)
3. In the To value box, type the result you want. (In the example, this is -900.)
4. In the By changing cell box, enter the reference for the cell that contains the value you want to adjust. (In the example, this is cell B3.)

   Note  This cell must be referenced by the formula in the cell you specified in the Set cell box.