To use Goal Seek in Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Goal Seek, set the formula cell and the result you want, then select the input cell Excel should change. Goal Seek adjusts one input value to make one formula reach a specified target.
What Goal Seek does
Goal Seek is an Excel what-if analysis tool for answering questions such as, “What value would make this result equal my target?” Instead of trying input values one by one, you tell Excel the desired result and identify the input that affects it. Excel then calculates an input value that brings the formula close to that result.
The tool works backward from a formula result, but it does not rewrite the formula or create a forecast. It changes a worksheet cell containing an input value. For example, it can find the unit price needed to reach a revenue target when the number of units sold is fixed.
Goal Seek is useful when the relationship between the input and result is already represented by a formula. It is not a general-purpose optimizer: it can change only one cell for one target at a time, and it does not manage multiple constraints.
Set up the worksheet first
Before opening Goal Seek, make sure your worksheet has three distinct parts: an input cell, a formula cell that depends on that input, and a target value. The formula should calculate the result you want to control. The input cell should contain a number that the formula uses, either directly or through other formulas.
- Keep the input and result in separate cells so Excel can change the input without replacing the formula.
- Check that the result formula refers to the intended input cell. A formula that does not depend on the changing cell cannot respond to Goal Seek.
- Use a meaningful starting value. Goal Seek begins from the current value in the input cell, and the starting value can affect which solution it finds when more than one is possible.
- Save or note the original input if you may want to restore it later. Goal Seek changes the worksheet value when you accept its result.
For example, suppose B2 contains a unit price, B3 contains units sold, and B4 is the revenue formula. With that layout, put =B2*B3 in B4. If B2 is 30 and B3 is 300, the formula returns 9,000. Those cell references are only an example; your own worksheet may use different cells.
Run Goal Seek step by step
In Excel for Microsoft 365 on Windows, use the following steps:
- Select Data on the ribbon.
- Select What-If Analysis in the Forecast group, then choose Goal Seek.
- In Set cell, enter or select the cell containing the formula you want to reach a target.
- In To value, type the desired result as a number. Do not type a formula in this box.
- In By changing cell, enter or select the input cell Excel is allowed to adjust.
- Select OK to start the calculation. Review the Goal Seek Status message and the updated worksheet value.
- Select OK in the status dialog to keep the result, or Cancel if you do not want to retain it.
The Set cell must contain a formula, and the By changing cell must be a different cell that the formula depends on. The changing cell is generally a value, not another formula that you want Excel to overwrite. If you want to test a different scenario, change the input or target and run Goal Seek again.
In Excel for Mac, Goal Seek is available in the desktop application; look under Data > What-If Analysis > Goal Seek. Ribbon placement can vary slightly between releases. Excel for the web does not provide the desktop Goal Seek command, so open the workbook in the Excel desktop app to use it.
Worked example: find the price for a revenue target
Suppose a shop expects to sell 300 units and wants revenue of 12,000. With unit price in B2, units in B3, and revenue in B4, the formula is =B2*B3. If B2 currently contains 30 and B3 contains 300, revenue is 9,000. In Goal Seek, set cell B4 to value 12000 by changing cell B2.
Excel returns 40 for B2 because 40 multiplied by 300 equals 12,000. The arithmetic is exact in this example, so the resulting revenue is exactly 12,000. If you format the price as currency with no decimal places, check the underlying value as well as the displayed value; number formatting can hide decimals.
This example also shows what Goal Seek does not decide: it does not judge whether a price of 40 is realistic, account for demand changing with price, or verify that the target is commercially sensible. It solves the worksheet relationship you supplied. If changing the price would also change the number of units sold, that relationship needs to be modeled in the workbook before Goal Seek can account for it.
Another example: calculate a break-even quantity
Goal Seek can also answer a break-even question if the worksheet formula includes the relevant costs. Assume B2 contains selling price per unit, B3 variable cost per unit, B4 units sold, and B5 fixed costs. With those cell meanings, enter =(B2-B3)*B4-B5 in B6 to calculate profit. If the price is 50, variable cost is 30, units are 100, and fixed costs are 2,500, the formula gives -500: a loss of 500.
To find the break-even number of units, set cell B6 to 0 by changing B4. The result is 125 units, because each unit contributes 20 toward fixed costs and 125 × 20 equals 2,500. This gives a useful mathematical answer, but the result may not be a whole number in other examples. If a business can sell only whole units, check the output and choose an appropriate whole-number assumption rather than treating a fractional quantity as a real sales count.
For money calculations such as loan payments or interest targets, Goal Seek can solve a formula based on illustrative assumptions, but it does not confirm the terms of an actual loan. Use the lender’s figures and check real terms with the lender or a qualified professional.
Understand the result and its limits
Goal Seek uses an iterative calculation: it tries an input, checks the formula result, and adjusts the input until it finds a sufficiently close match or stops. It is a numerical method, not an algebra explanation. The status window reports whether Excel found a solution or whether it could not find one; review both the changing cell and the resulting formula value before accepting.
A displayed result that looks equal to the target may differ slightly in the underlying value. Conversely, a formula may display a rounded number even though its actual result is not the target. Increase the displayed decimal places or inspect the formula result when precision matters. Goal Seek may also struggle with formulas that jump abruptly, return errors for some inputs, or barely change when the input changes.
Some formulas have more than one solution. For instance, a squared input can produce the same target at a positive and a negative value. Since Goal Seek starts from the current input, its result can depend on that starting point. Try a sensible starting value and, if needed, test other starting values to see whether another solution is possible.
Common problems and practical fixes
- Goal Seek says the cell is not a formula. Set cell must contain a formula, not a typed result. Check that you selected the output cell rather than the input.
- The output does not change. Confirm that the formula depends on the changing cell, directly or through another formula. Also check for a fixed reference to a different input.
- No solution is found. Check that the target is attainable and that intermediate calculations do not produce errors. A formula with a limited range or a discontinuous result may not reach every target.
- The answer is surprising. Check the starting input, units, signs, and formula logic. A wrong target such as 1200 instead of 12000 can still produce a mathematically valid but unintended answer.
- The answer has too many decimals. Formatting only changes what is displayed. If the real-world input must be a whole number or a fixed currency increment, verify a rounded candidate by recalculating the formula.
- You cannot find Goal Seek. In the Windows desktop app, look on the Data tab under What-If Analysis. In Excel for the web, open the workbook in the desktop app instead.
For important work, make a copy of the workbook or record the original input before accepting a result. That makes it easier to compare the original scenario with the new one and avoids relying on a displayed value alone.
Goal Seek compared with Solver and data tables
Choose the tool based on how many values and conditions your question involves:
- Goal Seek: one formula target and one changing input. Use it for questions such as the price required for a specified revenue, or the units needed for break-even.
- Solver: an objective to maximize, minimize, or set to a value, with multiple changing cells and optional constraints. Solver is an Excel add-in and may need to be enabled. It is a better fit when the problem includes limits such as capacity, budget, or whole-number decisions.
- Data tables: compare how one or two input assumptions affect formula results across a range of values. They show scenarios rather than searching for one input that hits one target.
These tools are related but not interchangeable. For example, if you need to find a price and a marketing budget simultaneously while keeping spending under a limit, Goal Seek cannot adjust both inputs or enforce the limit. Solver is more appropriate for that type of model.
Frequently Asked Questions
Can Goal Seek change more than one cell?
No. Goal Seek adjusts one changing cell to make one formula cell reach one target. Use Solver when your model requires multiple changing cells or constraints.
Does Goal Seek work in Excel for the web?
The Goal Seek command is available in the desktop versions of Excel, not Excel for the web. Open the workbook in Excel for Windows or Mac to run it.
Why must the Set cell contain a formula?
Goal Seek needs a calculated result to evaluate as it adjusts the input. A typed value cannot respond to changes in another cell, so select a formula cell that depends on the input.
Can I use Goal Seek to find a loan interest rate or payment?
You can use it to solve a spreadsheet formula for one input, such as a rate or payment, if the formula is built correctly. The answer depends on the assumptions and timing in the worksheet; verify actual loan terms with the lender or a qualified professional.
Why does Goal Seek return a different answer from what I expected?
Check the formula, target, units, and current starting value. Multiple solutions, rounding, or an input that does not affect the selected formula can also explain unexpected results.
Can Goal Seek find an exact answer?
Sometimes, as in the simple revenue example, but not always. It uses iterative numerical calculation and can return a close approximation, so check the actual formula result and required precision before relying on it.
Related
- Checkbox in Excel With Text: Two Practical Methods
- How to Add a Checkbox in Excel Ribbon
- How to Add Checkboxes to an Excel Table in Microsoft 365
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Delete an Unwanted Page in Word: Simple FixesTo delete an unwanted page in Word, remove the text or objects on it, or delete the page…
- Excel Payment Calendar: Build One That UpdatesAn Excel payment calendar is a dated list or monthly grid for tracking bills, amounts, due dates, and…
- MS Outlook: How to Create a Distribution ListYes. In Microsoft 365 Outlook for Windows, create a personal list from People: in new Outlook, choose People…
- Excel MAC Address Format: Display, Clean, and ValidateIn Excel, store a MAC address as text, then display it in a consistent form such as 00:1A:2B:3C:4D:5E.…
- Excel Column Selection: Select One or More ColumnsIn Excel for Microsoft 365 on Windows, click a column letter to select that entire column, or click…
- How to Add a Drop-Down List to an Excel TableTo add a drop-down list to an Excel table, select the cells in the table column, open Data…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.