Excel Not Calculating a Formula Just Written? Fix It

Errors & fixes · Updated November 18, 2026

If Excel is not calculating a formula you just wrote, first check that calculation is set to Automatic: go to Formulas > Calculation Options > Automatic. If the cell still shows the formula instead of a result, change its format from Text to General and re-enter the formula; also check for a leading apostrophe or the Show Formulas view.

Start with the symptom

“Not calculating” can describe several different things, and the visible result points toward the cause. A value that stays unchanged after you edit an input often suggests Manual calculation. A cell displaying characters such as =A1+B1 usually indicates that Excel is treating the entry as text or showing formulas. An error such as #VALUE! means Excel did calculate something, but the formula or its inputs produced an error. A blank result can be intentional, for example if a formula is designed to return an empty string under certain conditions.

Before changing settings, click the cell and look at the formula bar. If it contains a formula beginning with an equals sign, Excel has at least stored the entry as a formula. If the formula bar shows a leading apostrophe, or the entry has no equals sign, Excel may be treating it as text or as a plain value. This quick check helps avoid changing calculation settings when the real issue is the cell’s contents.

Check calculation mode

In Excel for Microsoft 365 on Windows, select Formulas > Calculation Options and choose Automatic. In Automatic mode, Excel normally recalculates dependent formulas when their inputs change. The other main choice, Manual, leaves results unchanged until you request a calculation. Manual mode can be useful in unusually large workbooks, but it is a common reason a newly entered formula appears not to update.

After switching to Automatic, press F9 to calculate formulas in open workbooks. Press Shift+F9 to calculate the active worksheet. If results still seem stale, Ctrl+Alt+F9 forces a full calculation of formulas in open workbooks. Ctrl+Alt+Shift+F9 rebuilds the calculation dependencies and then recalculates. These stronger shortcuts can take time in a large workbook, so start with the ordinary setting and F9.

Calculation mode can affect more than the sheet you are looking at: Excel’s calculation setting applies across open workbooks in the application. If you open a workbook created or saved while Manual mode was in use, check the setting rather than assuming a new workbook or sheet is responsible. Save your work after correcting the mode, especially if you have made other changes.

Make sure the cell is not formatted as Text

A cell formatted as Text tells Excel to preserve what you type rather than interpret it as a formula. This often happens when a column was formatted before data was entered, or when formula text was pasted from another source. Select the affected cell, choose Home > Number Format and select General. Then edit the cell and confirm the entry again; changing the format alone may not convert a formula Excel already stored as text.

One reliable way to re-enter it is to select the cell, press F2, and then press Enter. You can also delete the entry and type it again after changing the format. On a Mac, the function keys may require holding Fn, depending on the keyboard and system settings. A leading apostrophe can produce a similar effect: Excel uses it to store an entry as text, and it may not appear in the cell itself. Check the formula bar if the format change does not help.

Check the formula’s beginning and syntax

A formula normally begins with an equals sign. If you enter A1+B1 without the equals sign, Excel treats it as text. Also look for an accidental space or apostrophe before the equals sign, unmatched parentheses, misspelled function names, or references to the wrong cells. A formula that Excel cannot parse commonly produces an error message when you confirm it, rather than silently calculating to the expected answer.

For a simple example, assume cell A2 contains 12 and cell B2 contains 8. Enter =A2+B2 in C2; the result should be 20. If C2 displays the formula itself, investigate the cell format or Show Formulas. If it displays 0 or another number, verify the values in A2 and B2 and check that the formula refers to those cells.

Function argument separators can depend on regional settings. Some Excel installations expect commas between function arguments, while others use a different separator. If a function formula is rejected even though its logic looks right, use the separator Excel expects in that installation. This is separate from calculation mode: a syntax problem prevents a correct formula from being entered, while Manual mode typically leaves a valid formula’s displayed result out of date.

Turn off Show Formulas if formulas appear everywhere

If many cells display expressions instead of results, the worksheet may be in Show Formulas view. Select Formulas > Show Formulas to turn it off. In Windows Excel, Ctrl+` (the grave accent key, usually near the top-left of the keyboard) toggles this view. On a Mac, the shortcut can depend on the keyboard layout; use the Show Formulas control on the Formulas tab if the shortcut is inconvenient.

Show Formulas is a display choice, not a change to the formulas themselves. It can make columns look too narrow because formulas are longer than their results, so the worksheet may appear full of hash marks or truncated text as well. Once the view is turned off, widen a column if needed to see the calculated values. If only one cell shows its formula while the rest show results, the cell’s format or contents are more likely to be the cause.

Distinguish a stale result from an error

A formula can be calculating correctly but still return an unexpected result because its inputs are not what you think they are. Numbers imported or pasted as text, a reference to the wrong row, a blank input, or a condition in the formula can all affect the output. Inspect the referenced cells and, for a complex formula, select part of the expression in the formula bar and use Formulas > Evaluate Formula to step through how Excel evaluates it.

For example, assume B2:B4 contains 5, 7, and 8. In B5, the formula =SUM(B2:B4) should return 20. If it does not, check whether the cells contain those numeric values and whether the formula’s range includes the intended rows. An error such as #NAME? may indicate an unrecognized function name or text that is not enclosed correctly; #REF! points to a broken reference. These are different problems from a formula that has not recalculated.

Also check whether the formula depends on another workbook, imported data, or a value that has not been refreshed. A formula may recalculate using the values currently available even when an external source is out of date. For a workbook connected to data sources, use Data > Refresh All when appropriate, and confirm that the connection or linked workbook is available. Refreshing data and recalculating formulas are related but distinct operations.

Look for circular references and intentional calculation settings

A circular reference occurs when a formula depends on its own result, either directly or through a chain of other formulas. For instance, a formula in C1 that refers to C1 creates a direct circular reference. Excel may warn about the problem or show a result that does not behave as expected. Check the status bar for a circular-reference notice and inspect the referenced cells before enabling any special calculation behavior.

Excel supports iterative calculation for workbooks that intentionally use circular formulas, but turning it on is not a general fix for a formula that will not calculate. On Windows, its controls are under File > Options > Formulas. Use them only when the workbook is designed for iteration and you understand the stopping settings. Otherwise, remove or correct the circular reference. On Mac, calculation preferences are available through Excel’s settings or preferences, though the exact labels can differ by release.

A practical troubleshooting order

Try these checks in sequence, changing one thing at a time. This makes it easier to identify the cause and avoids unnecessary edits to a workbook that may contain important formulas.

  1. Click the formula cell and inspect the formula bar. Confirm that the entry begins with an equals sign and refers to the intended cells.
  2. Check Formulas > Calculation Options and select Automatic. Press F9 if you need to recalculate immediately.
  3. If the cell displays formula characters, turn off Formulas > Show Formulas and check for Text formatting or a leading apostrophe.
  4. Set the cell to General, then re-enter the formula with F2 and Enter, or type it again.
  5. If Excel displays an error, investigate that error and the referenced inputs instead of repeatedly changing calculation mode.
  6. If the formula relies on external or imported data, confirm the source is available and refresh it when appropriate.

For a formula entered in a table, also distinguish calculation from fill behavior. Excel may calculate the formula in the cell you edited while not automatically copying it into other rows. That is a separate issue from a formula returning no result; check the rows where you expect the formula to appear and verify that the table or range includes them.

Frequently Asked Questions

Why does Excel show the formula instead of the answer?
The cell may be formatted as Text, the entry may start with an apostrophe, or Show Formulas may be enabled. If it is just one cell, set it to General and re-enter the formula. If many cells show formulas, turn off Show Formulas.

How do I force Excel to recalculate?
Press F9 to calculate formulas in open workbooks, or Shift+F9 to calculate the active worksheet. If results remain stale, Ctrl+Alt+F9 forces a full calculation. On some Mac keyboards, you may need to hold Fn with a function key.

Why does my formula update only after I press F9?
The workbook is likely using Manual calculation. Choose Formulas > Calculation Options > Automatic. If Automatic is already selected, check for a circular reference, an external dependency, or another reason the input value has not changed.

Does changing a cell from Text to General fix the formula automatically?
Not always. Excel may keep the existing entry as text even after you change the format. Re-enter it by selecting the cell, pressing F2, and pressing Enter, or by typing the formula again.

Why does my formula show an error instead of calculating?
An error means Excel tried to evaluate the formula but encountered a problem, such as an invalid reference, unrecognized name, or incompatible input. Read the specific error, verify the referenced cells and formula syntax, and use Evaluate Formula for a complex expression.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.