Use Excel Goal Seek to Find the Required Value in Cell B2
Question details
Find the value for cell B2 that makes the result in cell B7 equal 1,000.

- 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.
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.
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.
In Excel, select Data > What-If Analysis > Goal Seek.
In the Goal Seek dialog, enter B7 in the Set cell box and 1000 in the To value box.
Enter B2 in the By changing cell box, then select OK.
Review the Goal Seek Status dialog and select OK to keep the calculated value in B2, or Cancel to restore the original value.

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. Open the workbook: Open WPS Spreadsheets and select Menu > Open to choose the Excel workbook.
- 2. Check the cells: Select B7 to confirm it contains a formula that depends on the numeric input in B2.
- 3. Open Goal Seek: Select Data > What-If Analysis > Goal Seek. Menu labels may vary by WPS Office version.
- 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.

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.




