Adjust the value of a cell to get a specific result for another cell

Microsoft Office Excel 2003

previous page next page

Show All Show All

Adjust the value of a cell to get a specific result for another cell

  1. On the Tools menu, click Goal Seek.
  2. In the Set cell box, enter the reference for the cell that contains the formula you want to resolve.
  3. In the To value box, type the result you want.
  4. In the By changing cell box, enter the reference for the cell that contains the value you want to adjust. This cell must be referenced by the formula in the cell you specified in the Set cell box.
  5. Click OK.
previous page start next page