Excel Formula Not Working? Fix Common Causes

Errors & fixes · Updated November 19, 2026

If an Excel formula is not working, first check whether Excel is showing the formula as text, using manual calculation, or returning an error. Select the cell, confirm the formula starts with an equals sign, then check Formulas > Calculation Options > Automatic; these quick checks resolve many common cases.

Start With the Symptom

“Not working” can describe several different problems: a cell displays the formula instead of its answer, the answer is wrong or outdated, Excel shows an error, or nothing changes when you edit an input. Identify which one you see before changing the formula. A visible formula usually points to display or cell-format settings; an error value usually offers a clue about the calculation; and a stale answer may mean calculation is set to manual.

Also check whether the formula is in the cell you expect. Click the cell and look at the formula bar above the worksheet. If the formula is there but the cell looks blank, the result may be hidden by formatting, a narrow column, a white font, or a custom number format. Widen the column and temporarily try Home > Number Format > General to distinguish a display issue from a calculation issue.

How Excel Calculates a Formula

Excel interprets an entry beginning with an equals sign as a formula, evaluates its references and operators, and displays the result in the cell. For example, a sum can refer to a range rather than adding each value by hand. With 12, 8, and 5 in cells B2, B3, and B4, respectively, enter this in B5:

With 12 in B2, 8 in B3, and 5 in B4, =SUM(B2:B4) returns 25 because 12 + 8 + 5 = 25.

A formula normally updates when a referenced value changes. Excel may delay or skip that recalculation if the workbook uses manual calculation, if the formula refers to unexpected cells, or if the entry is stored as text. Understanding which part has failed makes troubleshooting much faster than repeatedly retyping the same expression.

When Excel Shows the Formula Instead of the Result

If a cell displays something like =SUM(B2:B4) rather than 25, check these possibilities:

  • Show Formulas is on. Select Formulas > Show Formulas to toggle the worksheet back to displaying results. On Windows, Ctrl+` (the grave-accent key, often beside 1) also toggles this view. Keyboard layouts vary, so the ribbon command is a dependable alternative.
  • The cell is formatted as Text. Select the cell, choose Home > Number Format > General, then edit and re-enter the formula. Changing the format alone may not convert an existing text entry; click into the formula bar and press Enter after changing the format.
  • The entry has a leading apostrophe or space. Excel treats entries such as an apostrophe followed by an equals sign as text. Remove the extra character, then confirm the formula again.
  • The formula is incomplete. Check that it begins with an equals sign and that parentheses, quotation marks, and separators are paired correctly.

Show Formulas affects how formulas appear across a worksheet; it does not change their underlying results. That is why it can look as if many cells stopped calculating at once.

Check Calculation Mode and Stale Results

Excel can calculate automatically or wait for a manual calculation. In Microsoft 365 for Windows, open Formulas > Calculation Options and select Automatic. Calculation mode can be relevant across open workbooks, so a workbook that previously updated normally may appear to stop after another workbook or setting changes.

To request a recalculation, press F9 on Windows. If a particular formula depends on other cells, Excel ordinarily updates its dependencies too. For a full recalculation of all open workbooks, Ctrl+Alt+F9 is available on Windows. On a Mac, use Formulas > Calculate Now or the calculation commands available in the Formulas tab; keyboard shortcuts differ by keyboard and Excel version.

Manual calculation can be useful in a large workbook because recalculating complex formulas after every edit may take time. It is also easy to forget that it is enabled. If results look old, check the calculation setting before assuming that the formula itself is wrong. Saving and reopening is not a substitute for checking the calculation mode.

Review Formula Syntax and Cell References

A formula can calculate successfully and still return an unintended answer if it refers to the wrong cells. In a copied formula, relative references move as the formula is filled down or across. Dollar signs make a reference absolute or partly fixed. For example, to multiply a row’s quantity by its unit price, put quantity in A2 and price in B2, then enter the formula in C2:

With quantity 3 in A2 and price 12 in B2, =A2*B2 returns 36. If copied down, the relative references adjust to the next row.

To keep a tax rate in B1 fixed while copying a calculation, use an absolute reference. With a pre-tax amount of 100 in A2 and a rate of 10% in B1, enter this in C2:

With 100 in A2 and 10% in B1, =A2*$B$1 returns 10. The dollar signs keep the reference to B1 fixed when the formula is copied.

Excel’s argument separator depends on regional settings. Many installations use commas, while some expect semicolons. If a formula is rejected despite apparently correct syntax, check the separator used by another working formula on that computer. Do not replace separators blindly: use the one Excel expects in that installation. Also check for typographic “smart” quotation marks pasted from a document; formulas require ordinary straight quotation marks around text values.

Understand Common Excel Error Messages

Error values are diagnostic clues, not all the same failure. Read the full error in the cell and inspect its formula and referenced values.

  • #DIV/0! means a calculation divides by zero or by a blank cell. Check the denominator and decide what the result should be when it is zero.
  • #VALUE! often indicates an unexpected type of input, such as text where a calculation expects a number. Imported values that look numeric may actually be stored as text.
  • #REF! means a reference is invalid, often because a referenced row, column, or cell was deleted or moved.
  • #NAME? can indicate a misspelled function name, an unrecognized name, or text that was not enclosed in quotation marks.
  • #N/A often means a lookup did not find a matching value. Check spelling, extra spaces, data types, and whether the lookup range includes the expected item.
  • #SPILL! means a dynamic-array result cannot occupy the cells it needs, commonly because something is already in the spill area.

For a lookup problem, confirm that values which look identical really match: a number stored as text may not behave like a numeric value, and a trailing space can make text different. Error handling can make a worksheet easier to read, but it should not hide a broken calculation before its cause is understood.

Check Imported Data, Formatting, and Compatibility

Data copied from a website, CSV file, or another system may contain leading or trailing spaces, nonbreaking spaces, dates stored as text, or numbers stored as text. These issues can make comparisons and lookups fail even when the cells look alike. Click a suspicious cell and inspect the formula bar; test a small sample by re-entering the value directly rather than assuming the whole column is clean.

Number formatting changes how a value is displayed, not necessarily the value Excel stores. A date may appear as a serial number under General formatting, while a number formatted as a date may look like a date. Similarly, rounding in the displayed format does not always mean the stored value is rounded. If a total seems off by a tiny amount, inspect the underlying values and decide whether the calculation should use rounded inputs.

Formula availability can also depend on the Excel version. XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE, and LET require Excel 2021 or Microsoft 365. A workbook using a newer function may not work as expected in an older Excel release. If the file is opened in Excel for the web or another spreadsheet program, some features or behaviors may differ; check the displayed compatibility message and the function’s availability in that environment.

A Practical Troubleshooting Order

Use this sequence to narrow down the cause without changing unrelated cells:

  1. Click the affected cell and read both the cell display and the formula bar. Note whether you see a result, formula text, or an error value.
  2. Confirm that the entry begins with an equals sign, uses the intended cell references, and has balanced parentheses and valid separators.
  3. If the formula itself is displayed, turn off Formulas > Show Formulas and check that the cell is not formatted as Text.
  4. If the result is stale, set Formulas > Calculation Options to Automatic and recalculate.
  5. If there is an error, follow the specific clue: check the denominator for #DIV/0!, source values for #VALUE!, references for #REF!, and lookup matches for #N/A.
  6. Test the same logic in a blank cell using a small, known example. If that works, compare the original formula’s references and source data rather than replacing the whole workbook.

When investigating a workbook received from someone else, preserve a copy before making broad changes. Avoid replacing formulas with values until you know why they fail; doing so removes the calculation logic and can make future updates impossible.

Frequently Asked Questions

Why is Excel showing the formula instead of the answer?
Show Formulas may be enabled, or the cell may be formatted as Text or contain a leading apostrophe. Check Formulas > Show Formulas, set the cell to General, and re-enter the formula.

Why does my Excel formula not update when I change a cell?
Check Formulas > Calculation Options and select Automatic. If the workbook is set to manual calculation, press F9 on Windows or use Formulas > Calculate Now on Mac to recalculate.

Why does Excel say there is a problem with my formula?
Look for a missing equals sign, unmatched parentheses, misspelled function, incorrect argument separator, or smart quotation marks. Regional settings may require semicolons instead of commas.

Why does my formula return #NAME?
Check the spelling of the function or named range, confirm the function exists in your Excel version, and put ordinary quotation marks around text values where required.

Why does a lookup return #N/A when the value is there?
The lookup value and source value may differ because of a trailing space, different data types, or a mismatch in the lookup range. Inspect the underlying values and confirm the intended match is included.

Will changing a cell from Text to General fix a formula?
It can help, but changing the format does not always re-evaluate an entry already stored as text. After choosing General, edit the cell and press Enter to make Excel interpret the entry again.

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.