Goal Seek in Excel Online: What Works in the Cloud

How-to basics · Updated November 21, 2026

Excel for the web does not currently include the Goal Seek command, so you cannot run Goal Seek directly in a browser. To use it with a workbook stored in OneDrive or SharePoint, open that workbook in the Excel desktop app, run Goal Seek there, then save; the file can remain in the cloud.

Is Goal Seek available in Excel for the web?

Goal Seek is a desktop Excel feature, not a feature of the browser version. In Excel for Microsoft 365 on Windows, it is on the Data tab under What-If Analysis. If you open the same workbook in Excel for the web, you can view and edit its cells and formulas, but you should not expect to find a Goal Seek command in the web ribbon.

This distinction is easy to miss because a workbook can be stored online and still be opened in desktop Excel. The storage location does not determine which tools are available; the application you use does. A file saved in OneDrive or SharePoint can be opened in the desktop app, analyzed with Goal Seek, and saved back to its cloud location.

If you are working on a computer without desktop Excel, you can still change an input cell in the browser and watch dependent formulas recalculate. That is a manual workaround, not a browser version of Goal Seek: Excel will not automatically search for the input that produces a target result.

What Goal Seek does

Goal Seek works backward from a desired result. You provide three things: a formula cell whose result you want to control, the target value for that result, and one input cell that Excel may change. Excel then tries different values in the input cell until the formula reaches the target, or gets sufficiently close.

For example, a formula might calculate revenue from a unit price and a quantity. If you know the price and want to find the quantity needed for a revenue target, Goal Seek can adjust the quantity. It does not write a new formula or change the target cell’s formula; it changes the input cell you identify.

Goal Seek is useful when the relationship between an input and an output is already expressed in a worksheet formula, but it is inconvenient to solve for the input by hand. It handles one changing cell at a time. It is not a general optimizer for multiple decisions, and it does not automatically enforce business rules such as whole-number quantities or minimum and maximum values.

Run Goal Seek on a cloud-stored workbook

In Excel for Microsoft 365 on Windows, open the workbook in the desktop app. If it is already open in a browser, use the Open in Desktop App option when available. Make sure you have permission to edit the file, and wait for any current changes to finish syncing before starting.

  1. Select the worksheet containing the formula and input cell. Confirm that the formula cell updates when you manually change the input.
  2. On the ribbon, choose Data > What-If Analysis > Goal Seek.
  3. In Set cell, enter or select the cell containing the formula you want to reach. It must be a formula cell.
  4. In To value, enter the target result. Enter a number, not a formula.
  5. In By changing cell, select the input cell Excel is allowed to change. This should be a cell that the formula depends on, and it cannot be the formula cell itself.
  6. Choose OK and review the proposed result. Choose OK again to keep the result in the worksheet, or choose Cancel to return to the previous value.

Afterward, save the workbook. With OneDrive or SharePoint storage, Excel normally syncs saved changes, but check the save or sync status before closing if the result matters to other people. A colleague opening the workbook in a browser may see the updated input and formula result, but still will not have the Goal Seek command there.

Worked example: find the quantity for a revenue target

Suppose a worksheet has a unit price of $25 in B2 and a sales quantity of 400 in B3. With the price in B2 and quantity in B3, enter this formula in B4 to calculate revenue: =B2*B3. The result is $10,000 because 25 multiplied by 400 equals 10,000.

To find the quantity that produces $15,000 in revenue, open Goal Seek and set the cell to B4, the target value to 15000, and the changing cell to B3. Excel returns 600: at a price of $25, 600 units produce $15,000. The price remains unchanged, and the formula remains in B4. Goal Seek has changed the quantity input from 400 to 600.

This example assumes a simple formula and a quantity that can be represented as a number. If the quantity must be a whole number, the result happens to be one already. In other cases, Goal Seek may return a decimal. You need to decide whether rounding is appropriate and check the resulting formula value against the actual target and any real-world constraints.

What you can do in the browser instead

Excel for the web can still help you investigate a target. You can edit the changing cell, observe the formula result, and try different values. This is practical when the calculation is simple and you only need to compare a few possibilities. It is less convenient when there are many possible inputs or when you need to find a precise result.

For a steadily increasing or decreasing relationship, a manual search can be more systematic than guessing. Try a low and high input value to see whether the target is between their results. Then test a value midway between them, keep the half of the range that still contains the target, and repeat. This is a form of binary search. It can narrow down a result efficiently when the output changes consistently in one direction, but it is a manual process and does not handle every formula shape.

Another option is to build a table of trial inputs and their calculated outputs, then compare the results. A table is useful when you want to show several scenarios to a colleague rather than present only one answer. The appropriate setup depends on the workbook and available features; it is not the same as asking Excel for a single Goal Seek result. For a complicated model, opening the workbook in desktop Excel is usually the most direct route.

Goal Seek’s limits and when to use Solver

Goal Seek adjusts just one input cell. It is appropriate for questions such as what price gives a chosen total, or what quantity reaches a stated revenue, provided the answer depends on one adjustable input. It does not search across several changing cells at once, and it does not let you specify a set of constraints like a minimum quantity or a maximum cost.

For a model that needs several decision variables or explicit constraints, Solver may be a better fit. Solver is a separate Excel add-in with its own setup and availability; it is not simply another name for Goal Seek. In particular, do not assume that being able to open a workbook in Excel for the web means you can run the desktop Solver add-in in the browser. If you need that kind of optimization, check the capabilities of the Excel app and add-ins available to your account.

Goal Seek is also not proof that a target is attainable under your real-world rules. It may find a mathematical input that reaches the target but that is impractical, outside an acceptable range, or based on assumptions that do not hold. Inspect the returned value and validate the model before relying on it.

Common problems and checks

  • The command is missing: Check whether the workbook is open in a browser. Goal Seek is available in desktop Excel, so use the desktop app rather than searching the web ribbon.
  • The Set cell box rejects your choice: Select a cell containing a formula. Goal Seek needs a calculated result to adjust toward the target.
  • The result does not make sense: Confirm that the changing cell feeds into the formula, directly or through other formulas. If changing it manually does not affect the result, Goal Seek cannot use it to reach the target.
  • Excel cannot find a useful answer: Check that the target is reachable and that the formula behaves sensibly over the range of possible inputs. Some formulas have limits, discontinuities, or multiple possible solutions.
  • The returned value is close but not exact: Goal Seek uses numerical iteration and may return an approximate result. Review the displayed formula result and the input precision needed for your task.
  • A saved result is not visible to a collaborator: Save the workbook and allow cloud syncing to finish. Also confirm that the other person opened the same file, not a downloaded copy or an older version.

When debugging, test the worksheet itself before blaming the tool: change the proposed input manually, check whether the output moves in the expected direction, and verify that no formula refers to an unintended cell. A mistaken cell reference can make a perfectly valid Goal Seek setup produce a confusing answer.

Frequently Asked Questions

Can I use Goal Seek in Excel Online?
No. Excel for the web does not provide the Goal Seek command. Open the workbook in desktop Excel to run it, or change the input manually in the browser and monitor the result.

Can I use Goal Seek on a file saved in OneDrive?
Yes. Open the OneDrive workbook in the Excel desktop app, run Goal Seek, and save it. Cloud storage and the desktop feature can be used together; the browser app is the limitation, not the file’s storage location.

Where is Goal Seek in Excel for Windows?
In Excel for Microsoft 365 on Windows, choose Data > What-If Analysis > Goal Seek. Enter the formula cell, target value, and one changing cell.

Does Goal Seek change my formula?
No. It changes the input cell you specify and leaves the formula in the Set cell in place. Review the proposed input before accepting it, especially if that cell contains an important assumption.

Can Goal Seek change more than one cell?
No. Goal Seek adjusts one changing cell. If your model needs multiple variables or constraints, consider Solver in a compatible desktop Excel setup rather than treating Goal Seek as a multi-variable optimizer.

Bottom line

For a cloud workbook, use Excel for the web to view, edit, and share, but switch to desktop Excel when you need Goal Seek. It finds an input for a formula-based target by changing one cell; after running it, check the result, save the workbook, and confirm that it has synced.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.