Goal Seek in Excel is a What-If Analysis tool that finds the input value needed to make a formula return a result you specify. In Microsoft Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Goal Seek, then choose the formula cell, the target value, and the one input cell Excel may change.
What Goal Seek means in Excel
Goal Seek works backward from a desired result. Instead of entering an input and seeing what a formula calculates, you tell Excel the result you want and ask it to find an input that produces it. It is useful when a formula is known but rearranging the formula by hand would be inconvenient.
For example, a sales planner might know the selling price and want to know how many items must be sold to reach a revenue target. A student might know a grading formula and want to find the score needed on a final exam to reach a course average. In both cases, the result is calculated by a worksheet formula, while Goal Seek adjusts one input to move that result toward a specified number.
Goal Seek is a feature, not an Excel worksheet function. You do not enter a formula such as a Goal Seek function in a cell. Instead, you run the command from the ribbon, and Excel writes its suggested input into the changing cell. The worksheet formula remains in place and recalculates using that new input.
How Goal Seek works
Goal Seek needs three pieces of information: a formula cell, a target result, and a changing cell. The formula cell must contain a formula, and its calculation must depend, directly or indirectly, on the changing cell. The target is the numeric result you want Excel to reach.
Excel then adjusts the changing cell and recalculates the formula, repeating the process until it finds a value close enough to the target or cannot find a suitable result. This is a numerical search, not a guarantee that a mathematically exact or unique answer exists. When a formula has several possible solutions, the result can depend on the starting value in the changing cell.
The changing cell is normally an input, such as units sold, hours worked, a rate, or a budget amount. It should not be a formula cell that is itself calculated from other cells. Goal Seek changes only one cell per run, so you need to decide which assumption is allowed to move and keep the other inputs fixed.
How to run Goal Seek step by step
Before starting, arrange the worksheet so the assumption you want to adjust is clearly separated from the formula that reports the result. Label the cells and check that the formula points to the intended inputs. This makes it easier to choose the correct cells in the dialog and to interpret the answer afterward.
- Select any cell in the worksheet, then choose Data > What-If Analysis > Goal Seek.
- In Set cell, enter or select the cell containing the formula whose result you want to target.
- In To value, type the desired numeric result. Enter a number, not a formula or a cell reference.
- In By changing cell, select the one input cell Excel is allowed to adjust. It must affect the formula in Set cell.
- Choose OK and review the Goal Seek Status dialog. Choose OK again to keep the proposed value, or Cancel to return without accepting it.
For example, to make a revenue formula equal 10,000, Set cell should be the revenue formula, To value should be 10000, and By changing cell should be the units input or another relevant assumption. After accepting, check the worksheet: confirm the input is plausible, the formula is still intact, and the displayed result is sufficiently close to the target for your purpose.
On Excel for Mac, Goal Seek is also available from the Data tab under What-If Analysis in current desktop versions, though the ribbon layout can vary by release. Goal Seek is not available as a standard feature in Excel for the web; open the workbook in the desktop app to run it.
A worked revenue example
Suppose a worksheet has units sold in B2, price per unit in B3, and revenue in B4. B2 currently contains 350 and B3 contains 25. With those cell assignments, the formula in B4 is =B2*B3, which calculates revenue of 8,750. To find the unit count that reaches revenue of 10,000, set B4 as the Goal Seek formula cell, enter 10000 as the target, and use B2 as the changing cell.
Excel returns 400 units: 400 multiplied by 25 is 10,000. The answer is straightforward in this case, but the same approach is useful when the formula includes several linked calculations and solving it manually would take longer. If the unit count must be a whole number, check that requirement yourself; Goal Seek does not provide a general constraint that forces the changing value to be an integer.
As another illustration, assume units are in B2, selling price is in B3, variable cost per item is in B4, and fixed costs are in B5. With those cells, a profit calculation in B6 can use =B2*(B3-B4)-B5. If B3 is 40, B4 is 22, and B5 is 1800, asking Goal Seek to make B6 equal 2000 while changing B2 gives about 211.11 units. That fractional result is mathematically consistent with the formula, but it may not be a usable real-world quantity. The example shows why a calculated answer still needs a practical sense check.
When Goal Seek is useful
Goal Seek is a good fit for a one-variable question: what single input would produce this particular formula result? Common spreadsheet uses include finding a required sales volume, a needed test score, a production quantity, a billable-hours target, or a value that balances a simple model. It can also help with financial scenarios, but a spreadsheet result is only as reliable as the assumptions and terms entered.
It is especially convenient when the formula is nonlinear or contains nested calculations that would be tedious to rearrange algebraically. For instance, if a result depends on a sequence of percentage calculations, you can target the final formula cell directly rather than derive an inverse formula. Still, the output answers only the question you set up; it does not validate the assumptions or tell you whether the target is sensible.
For money calculations such as loan payments or interest scenarios, treat any numbers as illustrative and verify actual rates, fees, timing, and contract terms with the lender or a qualified professional. Goal Seek performs worksheet arithmetic; it is not financial, tax, investment, or legal advice.
What Goal Seek cannot do
The main limitation is that Goal Seek changes only one input cell at a time. If you need to vary several assumptions together, or require the answer to obey limits such as minimum staffing, a maximum budget, or whole-number quantities, Goal Seek may not be the right tool. A result can also be mathematically close to the target but operationally impossible.
It needs a formula that responds to the changing cell. It cannot work backward from a hard-coded result with no formula dependency, nor can it create a formula or identify which of many worksheet assumptions should change. It also does not provide a table of every possible answer. If several inputs could reasonably change, run separate scenarios or use a tool designed for multiple variables.
Some targets have no solution. Others have more than one solution, or a solution that lies outside a sensible range. In those cases, Goal Seek may stop without reaching the target, or return an answer that is unexpected because of the initial value and shape of the formula. It is wise to try a reasonable starting value, inspect the result, and test whether nearby input values produce the behavior you expect.
Common problems and how to fix them
- The Set cell is not a formula. Choose the cell containing the calculated result, not a label or a typed number. Confirm that it is a formula cell before reopening Goal Seek.
- The changing cell does not affect the result. Check the references in the formula and ensure the selected input is part of its calculation chain. If changing the input manually does not alter the result, Goal Seek cannot use it to reach the target.
- The wrong cell is being changed. Recheck the By changing cell field. Selecting a price instead of units, for instance, can produce a valid mathematical answer that is not the scenario you intended to test.
- The result is close but not exact. Numerical procedures can return a value that is sufficiently close rather than an exact match, particularly with complex calculations. Review the displayed result and the precision your task requires.
- The returned value seems unreasonable. Check units, signs, percentages, and formula references. Also consider whether a different solution exists or whether the target is possible within realistic bounds.
- The result disappears after editing. Goal Seek changes the input value; it does not save a permanent relationship between the target and the input. Later edits to other assumptions can change the formula result, so run Goal Seek again if you need to retarget it.
Keep a record of the original input when it matters. Accepting a Goal Seek result replaces the value in the changing cell, which may remove the starting assumption from that cell. You can undo an immediate change with the usual Undo command, but a note or a separate copy of the original scenario is safer when the starting value is important.
Goal Seek compared with Solver and other tools
Goal Seek is the simplest choice when there is one output formula, one target, and one input to adjust. Solver is more suitable when an objective depends on multiple changing cells or when the answer must satisfy constraints. Solver is an Excel add-in and may need to be enabled; it offers a broader optimization setup than Goal Seek. Use it only when the extra flexibility is needed.
Data tables serve a different purpose: they show how a formula changes across a range of one or two input values. They are useful for comparing many scenarios, but they do not search for a single input that reaches a target. Scenario Manager stores sets of assumptions for comparison; it likewise does not solve for a target value.
For a simple linear relationship, algebra or a direct worksheet formula may be clearer than Goal Seek. If a monthly total is simply a fixed rate multiplied by a quantity, dividing the target by the rate gives the required quantity directly. Goal Seek becomes more helpful when a model is more involved or the reverse calculation is inconvenient, while the other tools are better when the question calls for multiple scenarios or constraints.
Frequently Asked Questions
Is Goal Seek a formula in Excel?
No. It is a command under Data > What-If Analysis. It changes an input cell so that a formula cell approaches a target; it does not add a Goal Seek function to the worksheet.
Can Goal Seek change more than one cell?
No. A Goal Seek run can adjust one changing cell. For multiple changing cells or constraints, consider Solver, or build separate scenarios if you only need to compare a few combinations.
Why does Goal Seek say it cannot find a solution?
The target may be unreachable, the chosen changing cell may not affect the formula, or the formula may behave in a way that prevents the search from converging. Verify the cell references and try a sensible starting value before concluding that no usable answer exists.
Does Goal Seek work in Excel for the web?
Goal Seek is not provided as a standard command in Excel for the web. Open the workbook in the desktop version of Excel for Windows or Mac to use it.
Does Goal Seek guarantee an exact or realistic answer?
No. It searches for a numerical value that brings a formula close to the target. The answer can be fractional, impractical, or one of several possible solutions, so check the result against the needs and limits of your model.
Related
- Excel Text to Columns: How to Undo and Restore Data
- Excel Pasting: Stop Tab-Delimited Text Splitting on Paste
- Excel Unable to Merge Cells? Causes, Fixes, and Alternatives
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Insert a Blank Checkbox in Word: Printable or ClickableTo insert a blank checkbox in Word, use Insert > Symbol > More Symbols and choose the ballot-box…
- Excel Insert X Rows: Fast Methods for Any WorksheetTo insert X rows in Excel, select X row headers where you want the new rows, then choose…
- Password-Protect an Excel File So It Can’t Be OpenedTo stop someone opening an Excel workbook without your permission, use Excel’s file-encryption password: in Microsoft 365 for…
- How to Apply Styles in a Word Document for Clear FormattingTo apply a style in Microsoft Word, click in a paragraph or select text, then choose a style…
- Excel To-Do List: How to Make OneTo make an Excel to-do list, create columns for the task, due date, priority, and completion status, then…
- Best Way to Embed Video in PowerPoint: 5 Good OptionsFor most presentations, the best way to embed video in PowerPoint is to insert a local MP4 encoded…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.