No. Excel for the web does not currently include the Goal Seek command, so you cannot run a Goal Seek calculation directly in a browser. To use it, open the workbook in the desktop version of Excel; if that is not an option, you can change the input cell manually or use another suitable calculation method.
What Goal Seek does
Goal Seek is an Excel what-if analysis tool. You give it a formula cell, the result you want that formula to return, and one input cell Excel is allowed to change. Excel then adjusts that input until the formula reaches the target, or gets as close as it can within its calculation limits.
For example, a small business might know it wants a particular sales total and need to work out how many items must sell at a fixed price. Or someone calculating a loan payment might want to find the interest rate that produces a chosen payment. These are “reverse calculation” questions: instead of entering an input and seeing the result, you enter a desired result and solve for an input.
Goal Seek changes one variable at a time. It is not a general-purpose optimizer, and it does not handle several adjustable inputs or constraints such as “units must be a whole number” on its own. Those problems may call for Solver or a different model.
Why Excel for the web does not run it
Excel for the web can open, edit, and recalculate many workbooks containing formulas, but its feature set is not identical to the desktop application. Goal Seek is one of the desktop what-if analysis tools that is not available as a command in the web app. Seeing the workbook’s formula results in a browser does not mean the browser can perform a Goal Seek run.
This distinction matters when someone shares a workbook with you. The workbook can still contain the model, and you may be able to edit its input cells in the browser, but there is no built-in Goal Seek dialog to specify a target and let Excel adjust a variable. If the workbook was already solved, the saved input and result values may be visible; they are values in the workbook, not proof that Goal Seek is available online.
Microsoft changes and expands Excel features over time, and online capabilities can differ by account or release. If you do not see Goal Seek in the web app, do not assume it is hidden under another menu: use desktop Excel for this operation.
How to run Goal Seek in desktop Excel
On Excel for Microsoft 365 for Windows, open the workbook in the desktop app and use the Goal Seek command on the Data tab. The formula cell must already calculate from the input cell you plan to change.
- Select Data > What-If Analysis > Goal Seek.
- In Set cell, enter or select the cell containing the formula you want to reach.
- In To value, type the target result. Enter a number, not a formula.
- In By changing cell, enter or select the input cell Excel may adjust.
- Choose OK to let Excel calculate. Review the proposed result, then choose OK to keep it or Cancel to return to the previous value.
The changing cell must be a value cell, not the formula cell itself, and the formula in the set cell must depend on it. If the relationship is not connected, Excel has nothing to adjust that can affect the requested result. On current Excel for Mac versions, look on the Data tab for What-If Analysis and Goal Seek; the menu placement can vary by build, and older versions may place Goal Seek under Tools. Excel for the web does not gain the feature by using a different menu path.
A simple example: finding the units needed for a sales target
Suppose a worksheet has the number of items sold in B2, the price per item in B3, and the sales total in B4. Set B2 to 80 and B3 to 12. The layout assumes the total in B4 is calculated from those two input cells, using this formula:
=B2*B3
The current result is 960 because 80 items multiplied by 12 each equals 960. If the target is 1,200 and the price stays fixed, run Goal Seek with B4 as Set cell, 1200 as To value, and B2 as By changing cell. Excel should change B2 to 100, since 100 × 12 = 1,200.
This example also shows why the formula needs to be in place before using the tool. Goal Seek does not create a sales model or infer what “sales” means; it only changes the chosen input so the existing formula reaches the specified value. If you instead selected B3 as the changing cell, Excel would try to find a price that makes 80 items produce 1,200 in sales: 15 per item.
What you can do when you only have the browser
If you need a Goal Seek result and have access to desktop Excel, the most reliable option is to open the workbook there, run Goal Seek, save it, and return to the browser if you want to continue collaborating online. In Excel for the web, use the option to open the workbook in the desktop app when available. If you cannot launch the desktop app, ask the workbook owner or a colleague with desktop Excel to run the calculation and share the updated file or the resulting input value.
For a simple model, manual adjustment can be a reasonable workaround. Change the input cell, observe the formula result, and repeat until it is close to the target. This can work when the relationship is straightforward and the answer does not need high precision. It is less dependable when small input changes cause large result changes, the formula is nonlinear, or the desired answer must meet a strict tolerance.
You can also calculate the answer directly if the formula can be rearranged safely. In the sales example, target sales divided by price gives required units: 1,200 divided by 12 equals 100. But many formulas—especially those involving compound interest, nested functions, or multiple dependencies—are not as easy to rearrange. A direct calculation should be checked against the original model rather than treated as an automatic equivalent to Goal Seek.
Goal Seek’s limits and common problems
Goal Seek is useful for a single target and one changing cell, but a successful-looking run still deserves a check. Excel may find an approximate numerical solution, and some equations can have more than one possible solution or no solution at all. A target that is impossible under the model’s assumptions cannot be made possible by repeatedly running the tool.
- The result does not change: Confirm that the set-cell formula actually refers, directly or indirectly, to the changing cell. Check that calculation is enabled and that the selected cells are the intended ones.
- The answer looks unreasonable: Inspect the starting value, units, signs, and formula references. Goal Seek changes the input; it does not know that a quantity should be positive, a rate should be within a certain range, or a count should be an integer.
- The target is not reached exactly: A nonlinear formula or limited numerical precision may produce a near result. Check the difference between the formula result and target, and decide whether the remaining gap matters for the task.
- You need several inputs or rules: Goal Seek cannot enforce multiple changing variables and constraints. Use Solver in desktop Excel if the problem fits its optimization model, or restructure the calculation.
- You are working in a shared file: Goal Seek changes a worksheet input cell. Coordinate before saving if that input is meaningful to collaborators, because the new value affects the workbook just like any other edit.
For important calculations, keep a copy of the original input or record it before solving. That makes it easier to compare the before-and-after model and restore the original assumptions if needed.
Goal Seek versus Solver and manual calculation
Choose Goal Seek when one formula has a desired result and there is one input you want Excel to adjust. It is intentionally simple: one set cell, one target, one changing cell. It is a good fit for “What sales volume produces this revenue?” or “What rate produces this payment?” when the rest of the model is fixed.
Solver is for a broader class of optimization problems, such as maximizing profit by changing multiple decision cells while respecting limits. It is a separate desktop Excel add-in, not another name for Goal Seek, and it is not a way to add Goal Seek to Excel for the web. Whether Solver is appropriate depends on the structure of the model and the constraints.
Manual calculation is often quickest if the relationship is simple and can be inverted with ordinary arithmetic. For more complicated models, desktop Goal Seek is usually less error-prone than repeatedly guessing inputs. No method can compensate for an incorrect formula or unrealistic assumptions, so verify the model first.
Frequently Asked Questions
Can I use Goal Seek in Excel for free online?
Excel for the web does not include the Goal Seek command. You can edit inputs and see formula results in the browser, but to run Goal Seek use a desktop version of Excel that includes the feature.
Where is Goal Seek in Excel for Microsoft 365?
In Excel for Microsoft 365 on Windows, use Data > What-If Analysis > Goal Seek. On Mac, check the Data tab for What-If Analysis; the location can differ in older builds.
Can I open an Excel Online workbook in desktop Excel?
When the option is available, choose the command to open the workbook in the desktop app. Run Goal Seek there and save the workbook so the changed input and calculated result are available to other people with access.
Does Goal Seek change the formula?
No. It adjusts the changing input cell to make the formula in the set cell reach the target. The formula remains in place, but the input value is updated if you accept the result.
Can Goal Seek change more than one cell?
No. Goal Seek adjusts one changing cell for one target formula cell. For multiple decision variables or constraints, consider Solver in desktop Excel or another appropriate modeling approach.
Why can’t Goal Seek reach my target?
The formula may not depend on the selected input, the target may be unattainable, or the model may have multiple or unstable solutions. Check the cell references and assumptions, then assess whether an approximate result is acceptable.
Related
- Circular Reference Settings in Excel: How They Work
- Change the Print Area in Excel: Steps and Fixes
- Excel Text to Columns: How to Split Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Date Shortcut: Insert Today’s Date with Ctrl+;In Excel for Microsoft 365 on Windows, press Ctrl+; (Ctrl plus the semicolon key) to insert today’s date…
- Excel Turn Off Page Break Lines on ScreenTo turn off page break lines in Excel for Microsoft 365 on Windows, choose File > Options >…
- Remove Duplicates in Excel: Steps, Checks, and Safe OptionsYes. In Excel for Microsoft 365 on Windows, select your data, choose Data > Remove Duplicates, select the…
- Excel Quick Print Shortcut Key: What Actually WorksExcel for Microsoft 365 on Windows has no built-in keyboard shortcut that sends a worksheet straight to the…
- How to Set Up Out of Office in OutlookTo set up an out-of-office reply in Outlook, open Automatic Replies, switch them on, write your message, and—if…
- Can You Add Audio to a PowerPoint Slideshow? Here’s HowYes. In PowerPoint for Microsoft 365 on Windows, add a sound file with Insert > Audio > Audio…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.