In Excel for Microsoft 365 on Windows, find Goal Seek on the Data tab: choose What-If Analysis in the Forecast group, then select Goal Seek. In the dialog, specify the formula cell, the result you want, and the single input cell Excel may change.
Where Goal Seek is on the Excel ribbon
Open the workbook and select the Data tab. In the Forecast group, click What-If Analysis, then click Goal Seek. The Goal Seek dialog opens with three fields: Set cell, To value, and By changing cell. If the ribbon is compressed because the Excel window is narrow, group names or buttons may be collapsed; maximize the window or expand the What-If Analysis menu.
Goal Seek is a built-in Excel command, not an add-in you need to install. If you do not see it, check that you are using the desktop version of Excel and have selected the Data tab. The command is not available in Excel for the web in the same way as in the desktop app, so open the workbook in desktop Excel to run it. On Excel for Mac, look on the Data tab for What-If Analysis and then Goal Seek; the ribbon layout can differ slightly from Windows.
What Goal Seek does
Goal Seek works backward from a desired result. You already have a formula, but you do not know what value one of its inputs must have to produce a particular result. You tell Excel the target result and the input cell it is allowed to adjust. Excel then changes that cell repeatedly until the formula returns a value close to the target.
For example, a sales forecast may calculate profit from units sold, unit price, unit cost, and fixed costs. If you know the profit you want but not the sales volume needed to reach it, Goal Seek can estimate the required number of units. It does not write a new formula or change several assumptions at once. It changes the value in one specified cell and leaves the formula in place.
Run Goal Seek with a worked example
Set up a small worksheet with the input labels and values below. The example assumes cell B2 contains units sold, B3 is the selling price per unit, B4 is the variable cost per unit, and B5 is fixed costs. Enter the profit formula in B6. With the sample inputs, the current profit is $5,000.
With units sold in B2, selling price in B3, variable cost in B4, fixed costs in B5, and profit in B6, enter this formula in B6:
=B2*(B3-B4)-B5
For the illustrative values B2 = 1000, B3 = 25, B4 = 15, and B5 = 5000, the formula returns 1000 × (25 − 15) − 5000 = 5000. Suppose the target is $10,000, while the price, cost, and fixed-cost assumptions remain unchanged. Use Goal Seek as follows:
- Select Data > What-If Analysis > Goal Seek.
- In Set cell, enter or select B6, the cell containing the profit formula.
- In To value, enter 10000. Enter a number, not a formula or a currency symbol.
- In By changing cell, enter or select B2, the input cell for units sold.
- Click OK and review Excel’s result. Click OK again to keep it, or click Cancel to restore the original value.
The answer is 1,500 units: each unit contributes $10 before fixed costs, and $15,000 of contribution less $5,000 in fixed costs leaves $10,000 profit. Goal Seek will generally find a numeric value, which may include decimals; if the business requires whole units, you may need to round the result and check the resulting profit yourself. The result is an estimate based on the worksheet’s assumptions, not a guarantee that those assumptions will hold.
What to enter in each Goal Seek field
The three fields describe different roles, so choosing the right cell matters:
- Set cell: The formula cell whose result you want to target. It must contain a formula that depends, directly or indirectly, on the changing cell.
- To value: The numeric result you want the formula to return. For example, enter 10000 to target ten thousand.
- By changing cell: The input cell Excel is permitted to adjust. It should be a value cell, not the formula cell itself.
In the example, B6 is the result, 10000 is the target, and B2 is the adjustable assumption. If you accidentally put B2 in Set cell, Excel would not be evaluating the profit formula. If you choose a changing cell that the formula does not use, changing it cannot affect the target, so Goal Seek cannot solve the problem.
When Goal Seek is useful
Goal Seek is handy for a one-variable question where the relationship is already represented by a formula. Common uses include finding the sales volume needed for a profit target, the exam score needed for a course average, the production quantity needed to meet a cost target, or the interest rate that would produce a particular result in an existing financial model. For money-related calculations, the answer depends on the formulas and assumptions entered; check actual terms with the lender or a qualified professional rather than treating a worksheet result as financial advice.
It can also help explain a model. Instead of trying several input values by hand, you can ask what one assumption would have to be for a particular outcome. Keep a note of the original input if you want to compare the before-and-after scenario. Goal Seek replaces the value in the changing cell when you accept the result; it does not automatically create a separate record of the original scenario.
Limits and how it differs from Solver
Goal Seek adjusts one changing cell to reach one target in one formula cell. It is not designed to optimize a value, such as maximizing profit, or to change multiple inputs subject to restrictions. It also does not let you specify conditions such as the input must be an integer or remain between two bounds. If the answer needs a constraint, verify the result separately or use an appropriate modeling tool.
Excel’s Solver add-in is a better fit for optimization problems with multiple changing cells or constraints, such as maximizing profit while limiting labor hours and materials. Solver may need to be added or enabled, depending on the installation. For comparing several fixed combinations of assumptions, a one-variable or two-variable data table, or Scenario Manager, may be more suitable. Those tools answer different questions: Goal Seek finds one input for one desired result; a data table compares formula outputs across chosen input values; Solver searches for an optimum under conditions.
Common problems and practical fixes
- The command is missing: Confirm you are in the desktop Excel app rather than Excel for the web, and look under Data > What-If Analysis. Widen the window if ribbon groups are collapsed.
- Goal Seek cannot find a solution: Check that the Set cell contains a working formula and that the formula depends on the changing cell. Confirm that the target is possible for the model. For example, a formula with a fixed maximum may never reach a target above that maximum.
- The answer looks unreasonable: Inspect units, signs, and cell references. A value entered as 10 instead of 10,000, or a cost entered with the wrong sign, can produce a technically consistent but misleading result.
- The result is close but not exact: Goal Seek uses numerical iteration, so small differences can remain, particularly with complex formulas or rounding. Check the displayed formula result and consider whether the target is realistic at the precision your model uses.
- The changing cell has a formula: Use an input cell instead. Goal Seek needs to overwrite the changing cell’s value, so a formula there would be replaced when the result is accepted.
- The result changes unexpectedly: Remember that accepting the result changes the input cell. Use Undo immediately if appropriate, or cancel the dialog before accepting; save a separate copy when preserving the original assumptions is important.
Tips for getting a dependable result
Start with a clean model: label the inputs, keep formulas separate from assumptions, and verify the formula’s current output before opening Goal Seek. A clear layout makes it easier to select the right cells and to explain later why Excel returned a particular value. Avoid using a cell containing a label or text as the changing cell; it should be a numeric input relevant to the formula.
After Goal Seek finishes, check the changed input and recalculate the result in context. If the input must be a whole number, a date, or another restricted value, test a valid nearby value rather than assuming Excel enforces that requirement. If the result is important, save or record both the target and the assumptions used. Goal Seek answers the mathematical question posed by the worksheet; it does not validate the model, its source data, or the real-world meaning of the target.
Frequently Asked Questions
Where is Goal Seek in Excel 365?
On Windows, select Data > What-If Analysis > Goal Seek. On Mac, find Goal Seek under What-If Analysis on the Data tab. If you are using Excel for the web, open the workbook in the desktop app to use this command.
Why is Goal Seek greyed out or unavailable?
Make sure you are using the desktop application and that the workbook is open in Excel rather than a browser preview. Also check that the active workbook is editable. The ribbon can look different when the window is narrow, so expand the What-If Analysis menu or maximize Excel.
Can Goal Seek change more than one cell?
No. Goal Seek changes one input cell to make one formula cell reach a target. Use Solver when a problem requires changing multiple cells or applying constraints.
Does Goal Seek create a formula?
No. It changes the value in the selected changing cell and leaves the Set cell formula in place. The changed value remains in the worksheet if you accept the result.
Can Goal Seek find an exact answer?
Sometimes, but it is a numerical search and may return a result that is close rather than perfectly equal to the target. Check the formula output after the calculation, especially when the formula is complex or the input has to meet a practical restriction.
Related
- Excel Text to Columns: How to Split Data Into Fields
- Excel Text to Columns: Split Cell Text at Line Breaks
- Excel Text to Columns: Find It and Split Data Correctly
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Set an Out of Office Invite in Outlook CalendarTo set an out of office invite in Outlook, create a calendar event, choose Show as > Out…
- Google Sheets Filter Unique Values: Formula and StepsYes. To list each nonblank value once in Google Sheets, enter =UNIQUE(FILTER(A2:A, A2:A<>"")) in an empty cell, assuming…
- How to Keep the Top Row Visible on Every Excel Print PageTo keep the top row on every printed page in Excel for Microsoft 365 on Windows, open the…
- Best Way to Make a Timeline in PowerPoint: 5 OptionsFor most presentations, the best way to make a timeline in PowerPoint is to use SmartArt’s Basic Timeline:…
- How to Import CSV to Excel: Steps and Common FixesTo import a CSV into Excel for Microsoft 365 on Windows, open a workbook, select Data > From…
- How to Insert an Image as a Watermark in Excel for PrintingTo add an image watermark to an Excel printout, place the image in the worksheet’s header: in Excel…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.