Goal Seek in Excel: Step-by-Step Guide to Finding a Value

How-to basics · Updated November 18, 2026

To use Goal Seek in Excel, create a formula for the result you want, then choose Data > What-If Analysis > Goal Seek. Enter the target result and the single input cell Excel may change. Goal Seek adjusts that input until the formula reaches your target, which is useful when you know the answer you want but not the value needed to produce it.

For example, you can use it to find the score needed on a final quiz to reach a desired average. The instructions below are for Microsoft Excel for Microsoft 365 on Windows. Goal Seek changes a cell in your workbook, so make a copy or note the original input if you may want to restore it.

What You’ll Need

  • An Excel workbook with a formula cell that calculates the result you want to reach.
  • A numeric target for that formula, such as an average of 85.
  • One input cell that the formula depends on and that Excel is allowed to change.
  • Excel desktop for Windows or Mac. In Excel for the web, if Goal Seek is not available in the Data tab, open the workbook in the desktop app.

Step-by-Step

  1. Set up the formula and input cell. First identify the result cell, the target value, and the input cell you want Excel to adjust. The result cell must contain a formula, not a typed number. The changing cell can contain a starting guess; Goal Seek will replace that value as it works. Save the workbook before you begin if the current input matters.
  2. Build a small example to follow. Suppose four quiz scores are in B2:B5: 80, 75, 90, and 85. Put 0 in B6 as a starting value for a fifth score. With the scores in B2:B6, enter =AVERAGE(B2:B6) in B7. The current average is 66 because the first four scores add to 330 and the fifth score is currently zero. The aim is to find a fifth score that makes B7 equal 85. This is an illustrative example; use a target and inputs that make sense for your own workbook.
  3. Open Goal Seek. Select the Data tab on the ribbon, then choose What-If Analysis > Goal Seek. The Goal Seek dialog has three fields: Set cell, To value, and By changing cell. If you do not see What-If Analysis, confirm that you are using the desktop version of Excel and that the Data tab is visible.
  4. Choose the formula cell in Set cell. Enter B7 or select the cell containing the formula from the worksheet. In this example, B7 is the average formula. Do not select B6 here: it is the input to be changed, not the calculated result. Goal Seek needs to work backward from a formula result.
  5. Enter the target in To value. Type 85, without an equals sign, because the desired average is 85. This field takes a numeric target. For a target such as 12.5%, enter the corresponding percentage or numeric value in the way your worksheet represents it; make sure the underlying value and cell formatting are not being confused.
  6. Choose the input in By changing cell. Enter B6 or select that cell. It must be a single cell, and the formula in B7 must depend on it. In this case, changing B6 changes the average in B7. You cannot ask Goal Seek to change a range of scores or several assumptions at once.
  7. Run the calculation and review it. Click OK. Excel tries different values in B6 and recalculates B7 until it finds a result close enough to the target. For this example it should set B6 to 95, because 80 + 75 + 90 + 85 + 95 equals 425, and 425 divided by 5 is 85. Check the Goal Seek Status message and verify that the displayed result is sensible.
  8. Keep or undo the result. If the status dialog reports a solution, choose OK to keep the value in B6. Choose Cancel to restore the value that was there before the run. If you accept the solution, consider adding a note beside the input to record that it was calculated to meet a particular target. Recalculate or rerun Goal Seek if you later change other inputs in the model.

On Excel for Mac, the Goal Seek command is also found through the Data tab and What-If Analysis in supported desktop versions, though the ribbon layout can vary slightly. The dialog works the same way: specify a formula cell, a target value, and one changing cell. Excel does not provide a dedicated universal keyboard shortcut for opening Goal Seek. In Excel for the web, use the desktop app if the command is not available in your ribbon.

Common Mistakes

  • Selecting a value instead of a formula cell. The Set cell field must point to a cell that calculates a result. If it contains a fixed number, Excel has no calculation to adjust toward the target.
  • Choosing an input the formula does not use. If the changing cell is not referenced directly or indirectly by the formula in Set cell, changing it cannot affect the result. Check the formula references before opening Goal Seek.
  • Trying to change multiple inputs. Goal Seek adjusts one cell only. If your target depends on two or more assumptions, test one at a time or consider Solver, which can handle more complex optimization problems when available.
  • Entering the target in the wrong scale. A percentage may be stored as a decimal, and a displayed value may be rounded. Confirm the actual target and the cell’s number format. For example, 85% is stored as 0.85, not 85, when the cell is formatted as a percentage.
  • Expecting an impossible result. A score capped at 100 cannot make the example average reach 101. Goal Seek may stop without finding the requested target if the input is constrained by what is mathematically possible.

Tips

  • Use a reasonable starting guess. Goal Seek can often find a solution from different starting values, but an input near the expected range can make the search more reliable, especially with formulas that behave irregularly.
  • Keep the model easy to inspect. Label the target, result, and changing input in nearby cells. Clear labels make it less likely that you will choose the wrong field and make the calculated value easier to explain later.
  • Check the unrounded value. A cell formatted to show zero decimal places can display a rounded result even when its underlying value has more decimals. Increase decimal places or inspect the formula bar if the target appears slightly off.
  • Keep a record of assumptions. Goal Seek changes the input cell itself. Record the original value or save a copy if you need to compare the original scenario with the calculated one. You can also use a separate copy of the worksheet for a what-if calculation.
  • Use Solver for a different kind of problem. Goal Seek is designed for one changing cell and one target formula. If you need to change several inputs, impose constraints, or maximize or minimize a result, Solver may be a better fit.

Troubleshooting

Goal Seek is unavailable or greyed out: Check that you have a workbook open and are using Excel desktop. The command may not appear in Excel for the web or in a simplified ribbon layout. On Windows, look on the Data tab for What-If Analysis. On Mac, check the Data tab in the desktop app. If you are using the web app and cannot find it, open the file in the desktop version.

Excel says it cannot find a solution: Confirm that Set cell contains a formula and that the selected changing cell affects that formula. Then check whether the target is possible. In the quiz example, a target average above 86 cannot be reached if the last score cannot exceed 100: the four existing scores total 330, and adding 100 gives 430, or an average of 86. Goal Seek itself does not enforce a score limit, so it could return a value above 100 for an impossible real-world target. Check the returned input against your actual limits.

The result is close but not exact: Excel uses an iterative search and may stop when the result is sufficiently close according to its calculation settings. Check the displayed precision, confirm that the target was entered correctly, and try again from a reasonable starting value. You can also check File > Options > Formulas on Windows for the maximum change setting used for iterative calculations; changing calculation settings affects the workbook, so note the original setting before editing it.

The answer looks unreasonable or changes sharply: Review the formula for discontinuities, rounding, lookup thresholds, or other steps where a small input change produces a large output change. Goal Seek may find a value that satisfies the formula but is not useful for your real situation. Confirm that the result fits the input’s allowed range, and test nearby values manually to understand how the model behaves.

Frequently Asked Questions

What does Goal Seek do in Excel?

Goal Seek works backward from a formula result. You specify the result you want and one input cell Excel may change; Excel then searches for an input that makes the formula reach the target.

Does Goal Seek need a formula?

Yes. The Set cell must contain a formula whose result depends on the changing cell. If the result is a manually typed value, Excel cannot calculate how changing another cell would affect it.

Can Goal Seek change more than one cell?

No. Goal Seek changes one input cell per run. For a model with multiple changing cells or constraints, use Solver if it is available and appropriate, or run separate Goal Seek calculations while keeping track of each result.

Can Goal Seek solve a formula with percentages or dates?

It can work with formulas that use percentages or dates when the changing cell is numeric and the result cell contains a formula. Be careful to enter the target in the same underlying scale the formula uses, and check the cell format so a displayed percentage or date is not misleading.

Can I undo a Goal Seek result?

After accepting the result, you can usually use Undo to reverse the worksheet change, or type the original input back into the changing cell. If you choose Cancel in the Goal Seek Status dialog instead of accepting the solution, Excel restores the original input from that run.

Why does Goal Seek return a value outside my allowed range?

Goal Seek searches for a value that satisfies the formula; it does not automatically know business rules such as a maximum score or minimum quantity. Check the result against your limits. If you need Excel to enforce constraints while changing inputs, consider Solver.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.