Calculation Issues

Use Excel Goal Seek to Find the Required Value in Cell B2

Natalie TaylorNatalie Taylor Nov 13, 2026 869 views

Question details

Find the value for cell B2 that makes the result in cell B7 equal 1,000.

Use Excel Goal Seek to Find the Required Value in Cell B2
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet uses B2 as an input for a formula in B7, and the user wants to reach a target result.
Observed behavior
The desired result is for B7 to calculate to 1,000 after Goal Seek adjusts B2.
Before you start

Check that B7 contains a formula that depends on B2 and that B2 contains a numeric input. If the worksheet is protected, make sure B2 is unlocked and editable.

Solution 1Recommended

Set B7 to 1,000 by changing B2 with Excel Goal Seek

Use Goal Seek to calculate the B2 input needed for the target formula result in B7.

1
Open Goal Seek

In Excel, select Data > What-If Analysis > Goal Seek.

2
Enter the target cell

In the Goal Seek dialog, enter B7 in the Set cell box and 1000 in the To value box.

3
Choose the input cell

Enter B2 in the By changing cell box, then select OK.

4
Keep the result

Review the Goal Seek Status dialog and select OK to keep the calculated value in B2, or Cancel to restore the original value.

Set B7 to 1,000 by changing B2 with Excel Goal Seek
Protected worksheets: If protection prevents Goal Seek from running, select Review > Unprotect Sheet and provide the password if required. Run Goal Seek again, then protect the sheet as needed.
Calculate a target in WPS Spreadsheets

Find the B2 Input with WPS Spreadsheets Goal Seek

Open the worksheet in WPS Spreadsheets and use Goal Seek to adjust B2 until the formula in B7 reaches 1,000.

  1. 1. Open the workbook: Open WPS Spreadsheets and select Menu > Open to choose the Excel workbook.
  2. 2. Check the cells: Select B7 to confirm it contains a formula that depends on the numeric input in B2.
  3. 3. Open Goal Seek: Select Data > What-If Analysis > Goal Seek. Menu labels may vary by WPS Office version.
  4. 4. Set the target: Set the target cell to B7, the target value to 1000, and the changing cell to B2. Select OK and accept the result if it is suitable.
Calculate an input from a target formula result with Goal Seek.Open and edit Microsoft Excel XLSX and XLS files.Use a familiar spreadsheet interface for formulas and what-if analysis.
microsoft office alternative - wps office

Frequently Asked Questions

Why must B7 contain a formula?

Goal Seek changes B2 and recalculates B7 to approach the target. Select B7 and check the formula bar to confirm its formula depends on B2.

Can Goal Seek change B2 on a protected worksheet?

B2 must be unlocked and editable. If protection still prevents Goal Seek from running, use Review > Unprotect Sheet, providing the password if required, and try again.

What if Goal Seek cannot find a solution?

Check that B7 depends on B2 and that B2 contains a number. The target may be unreachable with the current formula; try a different starting value in B2 and run Data > What-If Analysis > Goal Seek again.

How do I undo the value Goal Seek finds?

Select Cancel in the Goal Seek Status dialog to restore the original B2 value. If you already accepted the result, use Undo if it is available.