Goal Seek in Excel works backward from a result you want: give it a formula cell, a target value, and one input cell to change. Excel then adjusts that input until the formula reaches the target, which is useful for questions such as how many units must sell to reach a revenue goal.
What Goal Seek does
Goal Seek is a What-If Analysis tool in the desktop versions of Excel. It solves a one-variable question by repeatedly changing one value in your worksheet and recalculating a formula that depends on it. You specify the result you want, but Excel determines the input value that produces it.
For example, a formula might calculate monthly revenue from a unit price and a quantity. If you know the desired revenue and price, Goal Seek can estimate the quantity needed. It is not a forecasting feature: it does not decide whether your target is realistic or whether the assumptions behind your formula are sound. It only searches for an input that makes the specified formula return the requested value.
The tool changes an existing worksheet cell, so that cell should contain an input value rather than a formula. The result cell must contain a formula that depends, directly or indirectly, on the changing cell. Goal Seek is designed for one changing cell at a time and one target formula cell.
How to run Goal Seek in Excel
In Excel for Microsoft 365 on Windows, use the following steps. Set up the formula and input cells before opening the tool:
- Select Data > What-If Analysis > Goal Seek.
- In Set cell, enter or select the cell containing the formula whose result you want to control.
- In To value, enter the target number. This is a value, not a cell reference or a formula.
- In By changing cell, enter or select the single input cell Excel may adjust. It must be part of the calculation feeding the set cell.
- Select OK to let Excel search. Review the proposed value and resulting calculation, then choose OK to keep the result or Cancel to discard it.
In current desktop Excel for Mac, Goal Seek is also available from the Data tab under What-If Analysis; the ribbon layout can vary slightly by release. Excel for the web does not provide the desktop What-If Analysis tools for running Goal Seek. Open the workbook in the desktop app if you need to use the feature.
Worked example: find the sales quantity
Suppose a small business sells an item for $25 and currently expects to sell 320 units. Put the price in B2, the unit count in B3, and the revenue formula in B4. With the price in B2 and units in B3, enter this formula in B4:
=B2*B3
The current revenue is $8,000 because 25 multiplied by 320 equals 8,000. To find the quantity needed for $10,000 in revenue, open Goal Seek and enter B4 for Set cell, 10000 for To value, and B3 for By changing cell. Excel should return 400 units: 25 multiplied by 400 is 10,000.
Goal Seek changes B3, so the original 320 is replaced if you accept the result. Keep a note of the starting assumption or work on a copy if you want to preserve it. If unit counts must be whole numbers, check that the returned value makes sense for your situation. Goal Seek may return a decimal in problems where the exact mathematical solution is not an integer.
Another example: calculate a break-even quantity
Goal Seek can also answer a break-even question. Suppose the selling price is $40 per unit, variable cost is $22 per unit, fixed costs are $5,400, and the initial sales estimate is 250 units. Put those inputs in B2 through B5 in that order, and calculate profit in B6. With price in B2, variable cost in B3, quantity in B4, and fixed costs in B5, enter this formula in B6:
=(B2-B3)*B4-B5
At 250 units, the contribution after variable cost is $18 per unit. Total contribution is $4,500, so the formula returns a loss of $900 after fixed costs. To find the break-even quantity, set B6 to 0 and change B4. The solution is 300 units: 18 multiplied by 300 is $5,400, exactly covering the fixed costs.
This is a mathematical illustration, not financial advice. Real pricing, costs, taxes, and lending or business terms can differ; verify relevant figures with the appropriate source or a qualified professional.
How Excel finds the answer
Goal Seek uses numerical trial and adjustment rather than rearranging your formula symbolically. It changes the input cell, recalculates the workbook, compares the formula result with the target, and tries another input. This makes it convenient when a formula is complicated or includes several calculations that would be tedious to solve by hand.
Because this is a numerical search, the result is generally an approximate solution within Excel’s calculation tolerances. A displayed value may be rounded, so increase the number of displayed decimal places or inspect the underlying value when precision matters. A target may also have more than one possible input solution. The search can depend on its starting value and may find one solution without identifying every possible solution.
Goal Seek does not explain why the result is appropriate, attach assumptions to the answer, or test the answer against business rules. Treat the returned input as a calculation to review, not an automatic recommendation.
What Goal Seek can and cannot change
The central limitation is that Goal Seek changes only one cell. It is suitable when one unknown input drives a formula result, but not when you need Excel to choose several inputs together or obey conditions such as minimum production, whole-number quantities, or a budget ceiling. It also cannot set a formula cell as the changing cell: the adjustable cell must be an input value.
The target must be achievable through the formula and the permitted input values. If the formula is constant with respect to the changing cell, or the target falls outside the formula’s possible results, Goal Seek cannot produce a meaningful answer. A formula with discontinuities, thresholds, or many possible roots may also make the result less intuitive. Check the formula structure and verify the resulting value independently.
Goal Seek does not provide a table of outcomes. It finds a value for one target at a time, and accepting the result updates the worksheet. If you want to compare several targets, record each result separately or use another analysis method.
Common problems and useful checks
- The result does not change: Check that the changing cell actually feeds into the formula in the set cell. A misspelled reference or a formula that uses a different input breaks the link.
- The set cell is rejected: Confirm it contains a formula, not a typed number. Goal Seek needs a calculated result it can recalculate.
- The changing cell is rejected: Make sure it is a single input cell rather than a range, and that it is not the formula cell itself.
- The answer looks unreasonable: Check units, signs, and cell references. For example, entering 10 instead of 10,000 as a target changes the question entirely.
- The result is close but not exact: Show more decimal places and recalculate. A numerical search may stop within a tolerance even if the displayed result appears rounded.
- Excel cannot find a solution: Test whether any plausible input could achieve the target. Also check for fixed values, error results, or formulas that change abruptly.
Before running Goal Seek, it helps to label assumptions clearly and save a starting copy of important inputs. After it finishes, verify the formula result and decide whether the new input is allowed in the real context. For instance, a mathematical quantity of 300.4 units may need to be interpreted differently from a whole-unit production requirement.
Goal Seek compared with Solver and other tools
Choose Goal Seek when you know the desired value of one formula and want to find one input that reaches it. It is built into Excel’s What-If Analysis tools and does not require setting up a model with multiple decision variables.
Use Solver when a problem involves multiple changing cells, constraints, or an objective to maximize or minimize. Solver is an Excel add-in; in Windows desktop Excel, it can be enabled through File > Options > Add-ins, choosing Excel Add-ins in the Manage box, selecting Go, and checking Solver Add-in. Once enabled, Solver appears on the Data tab. Its setup is more involved, but it addresses optimization problems Goal Seek is not designed for.
For comparing outcomes across multiple inputs or targets, a one-variable or two-variable data table can show a grid of results. Scenario Manager can store and compare sets of input values. These tools answer different questions: Goal Seek works backward from a target, while tables and scenarios compare outcomes from selected assumptions.
Frequently Asked Questions
Where is Goal Seek in Excel?
In desktop Excel for Microsoft 365 on Windows, select Data > What-If Analysis > Goal Seek. Current Mac desktop versions also include it under Data and What-If Analysis, though ribbon details can differ. It is not available to run in Excel for the web.
Can Goal Seek change more than one cell?
No. Goal Seek adjusts one changing cell for one formula result. For multiple changing cells or constraints, consider Solver instead.
Can I use a cell reference in the To value box?
The To value field expects a target number, not a reference or formula. If your target is stored in another cell, read its value and enter that number in the field.
Does Goal Seek change my formula?
No. It changes the selected input cell and recalculates the formula cell. The formula should remain intact, but the input’s previous value is replaced if you accept the result.
Why does Goal Seek give a different answer from my estimate?
It may be solving the formula as written, including references or assumptions that differ from your mental calculation. Check the formula, units, and starting values, and remember that nonlinear formulas can have multiple solutions.
Related
- Excel Suddenly Not Responding? Causes and Fixes
- Excel Spreadsheet Grouping Rows: How to Create and Use It
- Excel Split Cell Into Multiple Cells: Methods That Work
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 Checkbox in Word Without the Developer TabTo insert a checkbox in Word without the Developer tab, add the checkbox symbol ☐ from Insert >…
- Excel Insert Row After Change in Data AutomaticallyTo insert a row after each change in a sorted Excel list, use a short VBA macro to…
- Excel Custom Number Format: Show Numbers in ThousandsTo show Excel values in thousands without changing the stored numbers, apply the custom format #,##0,. In Excel…
- How to Split Cells in Excel Into Two Columns Without ErrorsTo split a cell into two columns in Excel, select the cells, choose Data > Text to Columns,…
- Compress Pictures in PowerPoint: Steps and Best SettingsTo compress pictures in PowerPoint for Microsoft 365 on Windows, select a picture, go to Picture Format >…
- Google Sheets Excel Export Options: Formats and StepsTo export a Google Sheets spreadsheet for Excel, open it in a browser and choose File > Download…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.