To practice Goal Seek in Excel, create a formula that depends on one input, then choose Data > What-If Analysis > Goal Seek. Set the formula cell, enter the result you want, and identify the single input cell Excel may change. A break-even example below shows the setup, result, and common pitfalls.
What Goal Seek does
Goal Seek is Excel’s built-in what-if analysis tool for finding an input value that makes a formula return a specified result. Instead of asking what the result will be for an input you already know, you start with a desired result and let Excel adjust one input to work backward. It is useful for questions such as how many units must be sold to break even, what exam score is needed to reach a course average, or what value makes a model meet a target.
It works with an existing worksheet formula. You tell Excel which formula cell to solve, what value that cell should reach, and which one input cell it is allowed to change. Excel tries values in that input cell until the formula gets close enough to the target. It changes the worksheet’s input value; it does not replace the formula in the result cell.
Build a break-even practice worksheet
Start with a small model where the arithmetic is easy to check. Put the labels in column A and the corresponding values in column B:
- A2: Units sold; B2: 500
- A3: Selling price per unit; B3: 25
- A4: Variable cost per unit; B4: 10
- A5: Fixed costs; B5: 12000
- A7: Profit; B7: formula
With units in B2, price per unit in B3, variable cost per unit in B4, and fixed costs in B5, enter this formula in B7:
=B2*(B3-B4)-B5
At the starting values, each unit contributes 15 toward fixed costs. Selling 500 units contributes 7500, so subtracting 12000 in fixed costs gives a profit of -4500. That negative result makes the target clear: find the number of units that makes profit equal zero. This is an illustrative arithmetic exercise, not financial advice; actual business decisions depend on real costs, terms, and other assumptions.
Run Goal Seek step by step
- Select any cell in the worksheet, then open Data > What-If Analysis > Goal Seek.
- In Set cell, enter B7, the cell containing the profit formula. Goal Seek needs a formula here, not a blank cell or a fixed value.
- In To value, enter 0, because zero profit is the break-even target. Enter a number rather than a formula in this field.
- In By changing cell, enter B2, the units-sold input. This must be a single cell that the formula in B7 depends on.
- Select OK and review the Goal Seek Status message. If Excel finds a solution, accept it with OK to keep the changed input, or choose Cancel to return to the prior worksheet values.
For this model, Excel changes B2 from 500 to 800. At 800 units, the contribution is 800 times 15, or 12000; after fixed costs of 12000, profit is zero. The result is an exact whole number in this example. Goal Seek may produce a decimal in other models, so decide whether the input is allowed to be fractional before treating the result as practical.
Check and interpret the result
After accepting a solution, inspect both the changed input and the formula result. In this example, B2 should show 800 and B7 should show zero or a value very close to zero. The latter distinction matters: Goal Seek uses numerical iteration, and more complicated formulas may stop when the result is sufficiently close rather than mathematically exact.
Also check whether the answer makes sense in the real situation represented by the spreadsheet. If the input is a count of people or products, a fractional answer may not be usable. If the answer is unexpectedly large or negative, verify the starting values, units, signs, and formula references. Goal Seek solves the worksheet model you give it; it cannot tell whether that model captures reality correctly.
Other useful practice questions
The same three-field process works for many everyday worksheet models. The target cell must be a formula, and the changing cell must be one input used by that formula. For example, a student can use a weighted-grade formula to find the final-exam score needed for a chosen course average, provided the formula calculates the average and the exam-score cell is the input to change.
Other practice ideas include finding the number of items needed to meet a sales target, the number of hours required to finish a task at a modeled pace, or the dimensions that make a calculated area equal a specified value. Start with a simple formula and choose an attainable target. Then confirm the answer by substituting it back into the model or checking the formula result in the worksheet.
For money-related models such as break-even calculations, keep units consistent: do not mix monthly costs with annual revenue, or dollars with cents. The example assumes constant price, constant variable cost per unit, and fixed costs that do not change with sales volume. Real-world costs or pricing can behave differently, so use verified inputs and consult a qualified professional for consequential financial decisions.
What Goal Seek cannot do
Goal Seek changes only one input cell per run. It does not search across several adjustable cells at once, impose rules such as an input needing to be an integer, or compare many possible solutions to find the best one. It is a target-finding tool, not a general-purpose optimizer.
It also cannot find a meaningful answer if the formula does not depend on the changing cell, if the target is outside the model’s possible results, or if the formula has discontinuities that make the search difficult. For example, a formula that rounds values into broad steps may jump over a target. A successful status message is not a guarantee that the result is sensible; examine the final calculation and the model assumptions.
Goal Seek compared with Solver and data tables
Choose Goal Seek when you know the desired result and need Excel to adjust one input. Choose Solver when a model needs multiple changing cells, constraints, or an objective to maximize or minimize. Solver is a separate Excel add-in, so its availability and setup differ from the built-in Goal Seek command; it is not necessary for the one-input break-even exercise here.
A one-variable or two-variable data table answers a different question: it shows how formula results change across a range of supplied input values. It does not work backward from one target to find an input the way Goal Seek does. These tools complement one another: a data table is useful for comparing scenarios, while Goal Seek is useful for solving for one target value.
Availability and keyboard access
These instructions are for Microsoft Excel for Microsoft 365 on Windows. On Windows, Goal Seek is on the Data tab under What-If Analysis. The ribbon KeyTip sequence is usually Alt+A, W, G; KeyTips can vary with localization or interface changes, so follow the letters displayed by Excel if that sequence differs. There is no equivalent default Mac KeyTip sequence; in Excel for Mac, use Data > What-If Analysis > Goal Seek where available.
Goal Seek is a desktop Excel feature and is not available in Excel for the web. If you are working in a browser and cannot find the command, open the workbook in the desktop app. Menu layout can vary by platform or update, but the core fields and one-changing-cell limitation are the same.
Common problems and fixes
- Set cell is rejected: Check that it contains a formula. A typed value alone cannot be solved toward a target.
- The result does not change: Make sure the changing cell is referenced, directly or through other formulas, by the set cell. Check that the reference points to the intended input.
- Excel cannot find a solution: Try a different reasonable starting value and check whether the target is possible under the formula. A target outside the model’s range has no solution.
- The answer is surprising: Verify signs, cell references, units, and assumptions. Goal Seek does not validate the underlying business or academic model.
- You need several inputs adjusted: Goal Seek is limited to one changing cell. Consider Solver if the task needs multiple variables or constraints.
Before experimenting with a complex workbook, save a copy. Goal Seek changes a worksheet value when you accept the result, and a saved copy makes it easier to compare the original model with the scenario you solved.
Frequently Asked Questions
Where is Goal Seek in Excel?
In Excel for Microsoft 365 on Windows, select Data > What-If Analysis > Goal Seek. Excel for the web does not include the desktop Goal Seek command.
Does Goal Seek change the formula?
No. It changes the value in the cell you specify under By changing cell. The formula in the Set cell remains in place, and its result updates based on the changed input.
Can Goal Seek change more than one cell?
No. Each Goal Seek run adjusts one changing cell. Use Solver for models that require multiple changing cells or constraints.
Why does Goal Seek return a decimal?
Excel solves the formula numerically and does not know that an input such as units sold may need to be a whole number. Review the decimal result, then test appropriate whole-number values in the model.
Can I use Goal Seek in Excel for the web?
No. Open the workbook in the desktop version of Excel to use Goal Seek, then save the workbook so the updated input is available to other users.
Related
- Excel Split Cell Into First and Last Name: A Clear Guide
- Excel Split Cell by Space Delimiter: Methods and Tips
- Excel Sheet Protection: How to Protect and Unlock Cells
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 Choose Which Rows and Columns to Freeze in ExcelTo freeze chosen rows and columns in Excel, select the cell immediately below the rows and immediately to…
- Common Excel Shortcut Keys and How to Use ThemThe most useful Excel shortcut keys on Windows include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to…
- Excel Conditional Formatting for Drop-Down ListsTo color an Excel drop-down selection automatically, create the list with Data Validation, then add a conditional-formatting rule…
- Unblock a Sender in Outlook 365: Step-by-StepTo unblock a sender in Outlook 365, remove their email address or domain from your blocked senders list.…
- Excel Solver: How to Save and Reuse Solver ScenariosYes. After Solver finds a solution in Excel for Microsoft 365 on Windows, choose Save Scenario in the…
- Excel Bucket List Template: Plan and Track Your GoalsAn Excel bucket list template is a worksheet for recording experiences you hope to have, then organizing and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.