Excel Formula Not Calculating? Fix It Without Errors

Errors & fixes · Updated November 19, 2026

If an Excel formula is not calculating and shows no error, first check whether Excel is set to Automatic calculation, whether the formula cell is formatted as Text, and whether Show Formulas is turned on. In Microsoft 365 for Windows, start with Formulas > Calculation Options > Automatic, then re-enter any formula stored as text.

What “not calculating” can mean

A formula can appear broken in several different ways even when Excel displays no error code. The cell may show the formula itself, show an old result, or show a result that looks unchanged after you edit an input. Those symptoms have different causes, so note what is visible before changing settings.

  • The formula text is visible: Excel may be treating the entry as text, or Show Formulas may be displaying formulas across the worksheet.
  • A number is visible but is out of date: the workbook may use Manual calculation, so Excel has not recalculated dependent cells.
  • The result is zero or unexpectedly small: a referenced value could be stored as text, omitted from a function, or not included in the reference.
  • The cell looks blank: the formula may return an empty string, or its output may be hidden by formatting.

Start with the least disruptive checks: inspect calculation mode, inspect the formula bar, and verify the cell format. Avoid deleting and rebuilding formulas until you know which symptom you have.

Check calculation mode and recalculate

Excel can use Automatic or Manual calculation. In Manual mode, a formula result may remain unchanged after its inputs change until a recalculation is requested. This is useful in some large workbooks, but it can make ordinary edits look as if formulas have stopped working.

  1. Open the Formulas tab and choose Calculation Options.
  2. Select Automatic.
  3. To request a calculation immediately, choose Calculate Now on the Formulas tab, or press F9 on Windows.

If a normal recalculation does not refresh the workbook, press Ctrl+Alt+F9 on Windows to force a full calculation of all formulas. This can help when Excel’s calculation chain is out of date. On Mac, use Formulas > Calculation Options and the calculation commands on the Formulas tab; keyboard shortcuts can differ by keyboard and Excel version.

Calculation mode can affect other open workbooks, not just the sheet you are looking at. If you work with several files, check the setting after opening them. Automatic calculation may take longer in a large workbook with many formulas, but switching to Manual without a clear reason can leave displayed results stale.

Make sure the cell contains a formula, not text

A formula must begin with an equals sign. If a cell displays something like =A2*B2 instead of a result, Excel may have stored the entry as text. This often happens when the cell was formatted as Text before the formula was entered, or when an apostrophe was used to preserve the characters literally.

First select the cell and look at the formula bar. If the entry is there as text, change the cell’s number format to General using Home > Number Format, then make Excel interpret the entry again. Press F2, then Enter on Windows. Merely changing Text to General after the fact does not always convert an existing text entry into a working formula; re-entering it is the important step.

For a group of affected cells, select them and use Data > Text to Columns, then choose Finish if the import preview is appropriate. This can convert text entries, but inspect the selection first because the command can change how values are interpreted. Keep a copy of important data before applying a bulk conversion.

Also check for a leading apostrophe or a space before the equals sign. A leading apostrophe tells Excel to keep the entry as text, and a space can prevent the entry from being recognized as a formula. Remove the extra character and re-enter the formula. If you are entering a formula from another source, check that the first character is an ordinary equals sign rather than a similar-looking character.

Turn off Show Formulas if formulas appear everywhere

If many cells show expressions instead of results, the worksheet may be in Show Formulas view. This is a display setting, not evidence that every formula has been converted to text. On Windows, press Ctrl+grave accent (the key often shares a position with the tilde), or use Formulas > Show Formulas to toggle the view. On Mac, use the Show Formulas command on the Formulas tab if the keyboard shortcut differs.

When Show Formulas is active, columns may appear wider because Excel displays the formula strings. Turn the view off and check whether the calculated values return. If only one cell still displays a formula, investigate that cell’s format and entry separately; a worksheet-wide display toggle would normally affect the formula display across the sheet.

Check references, inputs, and formula logic

A formula can calculate correctly and still return an unexpected result because its references or inputs are not what you assume. Confirm that the formula points to the intended cells, that copied formulas have adjusted references as expected, and that the inputs contain the values you see. Text values can look like numbers. For instance, SUM generally ignores text in a referenced range rather than adding it as a number, which can produce a plausible but incomplete total without an error.

With quantities in A2:A4 and prices in B2:B4, enter this formula in C2 and fill it down through C4:

=A2*B2

If A2 is 3 and B2 is 4.50, C2 should return 13.5. If it returns zero or a result based on a different row, inspect the actual cell references and the stored input values. If a value is left-aligned or carries a warning indicator, it may be stored as text; use the cell’s value and format to confirm rather than relying on alignment alone.

With sales amounts in B2:B4, this formula returns their total:

=SUM(B2:B4)

If B2:B4 contain 10, 20, and 30 as numeric values, the result is 60. If one entry is the text string “20,” the displayed total may be 40 because SUM does not treat ordinary text in a referenced range as a number. Convert the affected input to a number if that is the intended data, then recalculate.

Other logic issues include omitted rows, a range that stops before the newest data, and absolute references that stay fixed when a formula is copied. A dollar sign in a reference is intentional when you want to lock a row or column. Compare the formula bar in a working row with the one in a row that appears wrong before editing a large range.

Look for hidden display and workbook complications

Sometimes the calculation is happening but the result is difficult to see. A custom number format can hide values, and a formula may deliberately return an empty string. Select the cell and inspect the formula bar and Home > Number Format. Temporarily changing the format to General can help reveal the underlying result, though it may alter how dates, percentages, or currency values appear.

If a cell displays ####, Excel usually cannot fit the formatted value in the column width; widen the column or adjust the number format. That display is different from a formula that has not calculated. Likewise, a result that looks unchanged may actually be a valid result: for example, a formula that rounds values can return the same displayed number after a small input change.

External workbook links can also complicate results. A formula that refers to another file may depend on whether that source workbook is available and whether links are updated. Review Data > Workbook Links when that command is available for the workbook, and confirm the source path and update choices. Do not replace links blindly; first determine whether the formula is meant to use current data from another file.

A circular reference occurs when a formula depends on its own result, either directly or through other cells. Excel may warn about it, or a workbook configured for iterative calculation may calculate repeatedly according to its settings. If a result is unexpectedly zero or unstable, check Formulas > Error Checking > Circular References. Iterative calculation is appropriate only when the workbook is designed to use it; enabling it merely to suppress a warning can conceal a formula design problem.

A reliable troubleshooting order

Use this sequence to narrow down the cause without making several unrelated changes at once:

  1. Record the symptom: formula text, stale value, blank output, or a result that seems wrong.
  2. Check Formulas > Calculation Options and select Automatic if the workbook should recalculate as you edit.
  3. Run Calculate Now or press F9 on Windows, then see whether dependent results update.
  4. Inspect the formula bar and cell format. If the formula is text, set General and re-enter it.
  5. If formulas appear across the sheet, turn off Show Formulas.
  6. Check referenced cells, range boundaries, text-stored numbers, and copied references.
  7. Investigate external links or circular references only if the formula depends on them.

After each step, check the result before proceeding. This makes it easier to identify the actual cause and reduces the chance of introducing a second problem while repairing the first.

Frequently Asked Questions

Why does my Excel formula show as text instead of a result?
Most often, the cell was formatted as Text, the entry has a leading apostrophe or space, or Show Formulas is active. Check the formula bar and format, then re-enter the formula after setting the cell to General.

Why does Excel not update a formula when I change a value?
Check Formulas > Calculation Options. If calculation is Manual, switch to Automatic or run Calculate Now. Also confirm that the changed cell is actually included in the formula’s references.

Will changing a cell from Text to General fix the formula automatically?
Not always. Changing the format may leave the existing entry stored as text. Set General, then press F2 and Enter on Windows to make Excel parse the entry again.

Why does SUM return a total that is too low without an error?
A value that looks numeric may be stored as text, and SUM generally ignores text in a referenced range. Check the source cells and convert text numbers to real numeric values when appropriate.

Does pressing F9 fix every formula problem?
No. F9 requests recalculation, so it can refresh stale results caused by Manual calculation. It cannot correct a text-formatted formula, a wrong reference, an omitted range, or a formula that is logically incorrect.

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.