To use Goal Seek in Excel, create a formula that returns the result you want, then select Data > What-If Analysis > Goal Seek. Enter the formula cell, the target result, and the one input cell Excel may change. Goal Seek adjusts that input to find a value that makes the formula reach your target.
What You’ll Need
- Excel for Microsoft 365 on Windows. Goal Seek is also available in supported desktop versions of Excel for Mac; the commands may be arranged slightly differently. Excel for the web does not provide the desktop Goal Seek command, so open the workbook in the desktop app to use it.
- A worksheet with a formula cell that depends on an input cell. Goal Seek works with one changing cell at a time.
- A specific target result, such as a total, percentage, or quantity. The target and input should be numeric values.
Step-by-Step
- Set up the calculation. Put the input value in one cell and make the result formula in another cell refer to that input. For example, enter 60 in B1 as units produced per hour and 10 in B2 as hours worked. With the rate in B1 and hours in B2, enter
=B1*B2in B3 to calculate total units. At these starting values, B3 returns 600. - Check the formula and its references. Select the result cell, B3 in the example, and confirm the formula bar shows the intended formula. The formula must calculate from the cell you intend to change. If B3 contains a typed number rather than a formula, Goal Seek has nothing to recalculate. If the formula refers to a different cell, changing B2 will not affect the result.
- Choose the target result. Decide what value the formula cell should return. In the example, the target is 900 total units. Goal Seek treats this as a numeric value; enter 900, not text such as “900 units.” If the result is displayed as a percentage or currency, enter its underlying numeric value in the dialog. For example, a target of 25% is entered as 0.25.
- Open Goal Seek. On the Windows ribbon, select Data > What-If Analysis > Goal Seek. In some Excel window sizes, What-If Analysis may appear as a compact button or menu within the Forecast group on the Data tab. Choose Goal Seek from that menu. In Excel for Mac, look on the Data tab for What-If Analysis and choose Goal Seek; the exact ribbon layout can vary with the Excel release.
- Fill in Set cell. In the Goal Seek dialog box, click the Set cell field and select B3, or type
B3. This must be the cell containing the formula whose result should meet the target. Do not choose B2, which is the input in this example, or a label cell. - Enter the target in To value. Click To value and type
900. This tells Excel what result to aim for in B3. The field accepts a value, not a second formula or a cell reference. If your target is a decimal, enter the number in the same scale used by the calculation. - Choose the input in By changing cell. Select the field and click B2, or type
B2. This is the cell Excel is allowed to adjust. It should be a direct input, not the formula cell itself, and it should affect the result in B3. Goal Seek cannot change several inputs at once. - Run the calculation. Select OK. Excel changes B2 and recalculates B3. For the example, it should set B2 to 15 hours, because 60 units per hour multiplied by 15 hours equals the target of 900 units. Excel displays a Goal Seek Status message showing whether it found a solution.
- Keep or undo the result. If the result is suitable, choose OK in the status message to keep the changed input. Choose Cancel to restore the original value. Check both the new input and the formula result in the worksheet; formatting or rounding may make the displayed value look different from its stored value.
- Save a copy of the original assumptions. Goal Seek writes its answer into the changing cell; it does not create a separate scenario or preserve the original input automatically. Record the initial value, copy the worksheet, or use a clearly labeled assumptions area before running it if you need to compare alternatives.
The example is deliberately simple, but the same pattern applies to more involved worksheets. For instance, you could find the quantity needed for a target total, the hours needed for a production goal, or a required score for a weighted average. In each case, identify one formula result and one numeric input that can drive it.
Common Mistakes
- Using a cell without a formula. The Set cell must calculate a result. A manually typed value will not respond when another cell changes.
- Choosing the wrong Set cell. The result cell should contain the calculation you want to hit, not the input, a heading, or a cell that merely displays a copied value.
- Picking an input the formula does not use. If the changing cell has no effect on the Set cell, Goal Seek cannot make progress. Trace the formula references before running it.
- Trying to change multiple assumptions. Goal Seek adjusts one cell only. If both price and quantity must change, decide which one to vary, or use Solver for a model that needs multiple changing cells and constraints.
- Entering a target in the wrong scale. Percentages, dates, and currency formats can obscure the underlying value. A percentage displayed as 25% is generally stored as 0.25, so use the numeric scale expected by the formula.
- Assuming the result must be a whole number. Unless the worksheet constrains the input, Goal Seek may return a decimal. If the real-world input must be an integer, test a suitable whole-number value and confirm the formula still meets the goal.
Tips
- Start with a sensible input. Goal Seek uses the current value as its starting point. For complicated or nonlinear formulas, a realistic starting value can make it easier to find a useful solution.
- Keep the model easy to inspect. Label the target, formula result, and changing input clearly. This helps you choose the right cells in the dialog and makes the answer easier to explain later.
- Check full precision when needed. A cell may display a rounded number while storing more decimal places. Increase the displayed decimal places or inspect the formula bar if the apparent result is slightly off.
- Test whether the answer makes sense. Recalculate the formula using the returned input and consider whether that input is possible in the real situation. A mathematical solution is not automatically a practical one.
- Keep a record of scenarios. Duplicate the worksheet or write down the starting input and Goal Seek result before trying a different target. Running Goal Seek again replaces the changing cell’s previous value.
- Use Solver for a larger problem. Solver is more appropriate when you need to change multiple cells, enforce limits, or optimize a value rather than simply make one formula equal a target. Its availability and setup differ from Goal Seek.
Troubleshooting
Goal Seek is missing or unavailable: Confirm that you are using the Excel desktop application, not Excel for the web. In Excel for Windows, look under Data > What-If Analysis. On a Mac, check the Data tab for the equivalent What-If Analysis menu. If the workbook is in a restricted or protected state, check whether the cells can be edited and whether the sheet needs to be unprotected.
Excel says it cannot find a solution: Verify that the formula cell really depends on the selected changing cell. Then check whether the target is reachable. For example, a formula limited to positive values cannot produce a negative result. Try a sensible starting value and confirm that changing the input manually changes the result in the expected direction. A formula with errors, text values, or circular references may also prevent a useful calculation.
The result is close but not exact: Goal Seek works by approximation and may stop within Excel’s calculation tolerance. Check the unrounded value, the formula, and whether the target is realistically attainable. If small differences matter, use a more precise model and review Excel’s calculation settings rather than relying only on the rounded display.
The answer is mathematically correct but unrealistic: Goal Seek does not know business rules or physical limits. It may return a negative, fractional, or impractically large input if the formula permits it. Add sensible limits to your interpretation, adjust the model, or use Solver when constraints need to be part of the search.
Your original input disappeared: If you kept the Goal Seek result, Excel replaced the changing cell’s previous value. Use Undo immediately if appropriate, or restore the value from your notes or a saved copy. For future runs, duplicate the sheet or record the assumptions first.
Frequently Asked Questions
Is Goal Seek built into Excel?
Yes. It is a built-in What-If Analysis tool in the Excel desktop application; you do not need to install an add-in for the standard feature.
Can Goal Seek change more than one cell?
No. It changes one input cell to make one formula cell reach a target. Use Solver if your problem needs several changing cells or additional constraints.
Can I use Goal Seek in Excel for the web?
The desktop Goal Seek command is not available for running in Excel for the web. Open the workbook in the desktop app, use Goal Seek there, and then save the workbook.
Does Goal Seek change my formula?
No. It changes the value in the By changing cell field and recalculates the formula in the Set cell. The formula remains in place unless you edit it separately.
Why did Goal Seek return a decimal?
It solves for a numeric input and does not automatically require whole numbers. If the input must be an integer, round or test a valid whole-number choice, then confirm that the resulting formula value is acceptable.
Can Goal Seek find every possible answer?
No. It searches for a solution based on the current model and starting input; it does not list all possible solutions. A formula can have multiple solutions or none, so test the result and use Solver or another method when the problem needs a broader search.
Related
- Importing CSV Into Excel: Steps, Settings, and Fixes
- Import CSV Into Excel Without Losing Leading Zeros
- Import CSV Into an Existing Excel Table: Steps & Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Validation Examples for Better Data EntryIn Excel for Microsoft 365 on Windows, useful data validation examples include a drop-down list for categories, a…
- Outlook Excel Sheet: Create a Data Entry Form in ExcelYes. In Excel for Microsoft 365 on Windows, prepare a worksheet as a list, add Excel’s built-in Form…
- How to Split a Cell in Google Sheets Into Two CellsTo split text in Google Sheets, select the cell or range, choose Data > Split text to columns,…
- How to Create Binder Labels in Word: A Step-by-Step GuideCreate binder labels in Word by choosing a label template that matches your label stock, entering the spine…
- Excel Data Validation List Based on a LookupYes. In Microsoft Excel for Microsoft 365, make a lookup-driven dropdown by using FILTER in a helper cell,…
- Media Excel Shortcuts for Images, Links, and ObjectsExcel has no single keyboard shortcut for all media. In Microsoft 365 for Windows, use Ctrl+V to paste…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.