Goal Seek

Contact Us or call 1-877-932-8228
Goal Seek

Goal Seek

If you know the result of a formula but not the value of a specific variable on which the formula depends, you can use Goal Seek to adjust the variable to display the desired value. Goal Seek can only adjust one variable in a formula, so if a formula depends on more than one variable, you will need to decide which variable to adjust.

To use Goal Seek:

  1. On the DATA tab, in the Data Tools group, click the What-If-Analysis command:What-If-Analysis Command
  2. Click Goal Seek:Goal Seek
  3. In the Goal Seek dialog box:
    1. In the Set cell box, enter the cell for which you know the result (if you selected this cell before clicking Goal Seek, then it is already filled in).
    2. In the To value box, enter the value for the cell above.
    3. In the By changing cell box, enter the cell to adjust in order to obtain the value. (Remember, this cell must be related via a formula to the cell above or else changing one won't impact the other.)
    4. Click OK:OK
  4. In the Goal Seek Status dialog box, after the calculation has completed, click OK to accept the change or Cancel to reject it:Calculation Completed
Next