Excel Formula Not Working? Causes and Fixes

Errors & fixes · Updated November 19, 2026

If an Excel formula will not work, first check that the cell contains a formula rather than text, that the formula begins with an equals sign, and that calculation is set to Automatic. Then use the displayed result or error code to narrow down the cause: common issues include a typo, an incorrect cell reference, incompatible data, or a function your Excel version does not support.

How Excel formulas work

Excel calculates a formula entered in a cell and displays its result there. A formula normally starts with an equals sign, followed by a value, cell reference, operator, or function. For example, a formula can add a range of cells, multiply two values, or test a condition. When a referenced value changes, Excel recalculates the result, unless calculation is set to Manual or another calculation issue is present.

Functions such as SUM use parentheses to contain their inputs. A range such as A2:A4 means cells A2 through A4. In the example below, the layout is three numbers in A2:A4: 12, 8, and 5. The formula returns 25.

With 12, 8, and 5 in A2, A3, and A4, enter =SUM(A2:A4) in another cell. The result is 25.

A formula can be syntactically valid but still produce an unexpected result. It may refer to the wrong row, interpret a number as text, or calculate correctly from source data that is itself incorrect. It helps to distinguish “Excel shows an error” from “Excel shows a result I did not expect.”

Identify the symptom before changing anything

Look at the formula bar and the cell’s display. Does the cell show the formula characters instead of the result? Is the cell blank, showing an error code, or showing an old value? These clues point to different fixes. Avoid replacing the formula immediately: first check its contents and the values it references so you do not hide the underlying cause.

  • The formula appears as text: the cell may be formatted as Text, or the entry may start with an apostrophe or a space.
  • The cell shows an error: read the error code and inspect the formula for the specific problem it describes.
  • The result does not update: check calculation settings and whether the inputs have changed.
  • The result is wrong but there is no error: verify the referenced cells, operators, and data types.
  • You see hash marks: a display issue may be involved. Widen the column; some date or time values that Excel cannot display can also appear as hash marks.

To inspect a formula, select its cell and look at the formula bar above the worksheet. On Windows, F2 edits the selected cell; press Enter to commit the edit. If a formula is displayed across many cells, the Show Formulas setting may be on; use the Formulas tab’s Show Formulas command to toggle it. A narrow column can also make a displayed formula or result look cut off.

Fix formulas stored as text

A cell formatted as Text can cause an entry beginning with an equals sign to remain visible as text instead of being calculated. A leading apostrophe has a similar effect: it tells Excel to treat the following entry as text. In either case, changing the cell’s number format alone may not convert an existing entry into a working formula.

Try this sequence on Windows: select the affected cell, choose Home > Number Format > General, then press F2 and Enter. The edit-and-confirm step makes Excel parse the contents again. On Mac, use the Home tab’s number-format control to select General, then edit and confirm the cell; keyboard shortcuts can differ depending on the keyboard and system settings.

If you are entering a new formula, select a cell formatted as General, type the formula starting with =, and press Enter. Also check that there is no space or apostrophe before the equals sign. If you see the formula instead of its result in a whole worksheet, check whether Show Formulas is enabled before changing individual cell formats.

Check syntax, operators, and error messages

Excel needs the formula’s function name, parentheses, quotation marks, and cell references to be valid. A missing closing parenthesis or a misspelled function can stop a formula from working. Text values used inside a formula need straight double quotation marks. In many Excel installations, commas separate function arguments, as in the example below; regional settings can use a different list separator, so a formula copied from another computer may need adjustment if Excel rejects it.

With a quantity of 3 in A2 and a unit price of 4.5 in B2, enter =A2*B2 in C2. The result is 13.5.

Common errors give useful clues:

  • #NAME? often means a function name is misspelled or text in the formula is not enclosed in quotation marks.
  • #VALUE! can mean a formula received an unsuitable type of value, such as text where a number is needed.
  • #REF! indicates an invalid cell reference, which can happen after referenced cells are deleted.
  • #DIV/0! means a calculation is dividing by zero or by a blank cell.
  • #N/A commonly means a lookup did not find a matching value, though the exact cause depends on the formula.
  • #SPILL! can occur when a dynamic-array formula needs to fill neighboring cells but something is blocking its output.

Do not treat every error as a syntax error. For example, #N/A may be the expected signal that a lookup value is absent. Follow the formula’s references and check the relevant input cells before replacing the formula with a different one.

Verify cell references and input data

Relative references change when a formula is copied. If a formula in row 2 refers to A2 and is copied down one row, Excel normally changes that reference to A3. This is useful for repeated calculations, but it can produce a wrong result if the formula was meant to keep pointing to one fixed cell. Dollar signs make a reference absolute: $A$1 stays fixed when copied. Mixed references, such as A$1 or $A1, lock only the row or column.

For example, suppose each row has a quantity in column B and a price in column C. With quantity 3 in B2 and price 4.5 in C2, enter =B2*C2 in D2. The result is 13.5. When copied to D3, the formula adjusts to use B3 and C3, which is usually what a row-by-row calculation needs.

Check the data itself, too. A cell that looks like the number 100 may be stored as text, especially if it was imported or preceded by an apostrophe. Leading or trailing spaces can also prevent text matches in lookups. Compare the source values and formats, and use a small test calculation on a copy of the data if a conversion could change the workbook. Do not assume that a visually identical value is stored identically.

Check calculation settings and recalculation

If formulas continue to show old results after their inputs change, calculation may be set to Manual. In Excel for Microsoft 365 on Windows, choose Formulas > Calculation Options > Automatic. In Manual mode, Excel waits for a recalculation command instead of updating every dependent formula immediately. This can be intentional in large workbooks, but it can confuse anyone who expects results to update as they type.

After switching to Automatic, check whether the result updates. On Windows, F9 recalculates formulas in open workbooks, while Shift+F9 recalculates the active worksheet. These commands trigger calculation; they do not repair a bad formula or an incorrect reference. Mac keyboards and shortcut settings vary, so use the Calculation Options menu if the keyboard command is unavailable.

Also check for circular references: these occur when a formula depends on its own result, either directly or through a chain of other cells. Excel may warn about a circular reference or handle it according to iterative calculation settings. Unless the workbook is deliberately designed to use iterative calculation, trace the references and remove the unintended loop.

Consider function and file compatibility

A formula can work in one version of Excel and fail in another if it uses a newer function. XLOOKUP, XMATCH, FILTER, SORT, UNIQUE, SEQUENCE, and LET are available in Excel 2021 and Microsoft 365, but may not be recognized by older releases. LAMBDA, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, and HSTACK require Microsoft 365 or Excel 2024. If a workbook is opened in an older version, Excel may display an unsupported-function indicator such as #NAME? or a compatibility-related function name.

When sharing a workbook, ask which Excel version the recipient uses and whether the file is being opened in Excel or another spreadsheet application. If an older version must be supported, use a compatible function or provide a calculated-value copy when appropriate. Do not replace a formula with a value without considering that the result will no longer update when its inputs change.

A practical troubleshooting order

Work from the simplest checks toward more involved ones. This reduces the chance of changing a correct formula to compensate for a display or calculation setting.

  1. Select the cell and inspect the formula bar to confirm what Excel actually stored.
  2. Confirm the entry begins with = and is not preceded by an apostrophe or space.
  3. Check the cell format; if it is Text, change it to General and re-enter the formula.
  4. Read any error code, then check the formula’s spelling, parentheses, references, and input types.
  5. Verify that referenced cells contain the intended values and that copied formulas point to the intended rows or columns.
  6. Choose Formulas > Calculation Options > Automatic if results are stale.
  7. Check for unsupported functions if the workbook moves between Excel versions or spreadsheet programs.

If the problem remains, test a simplified version in an unused cell or in a copy of the workbook. For instance, a complicated formula can be examined one reference at a time to see which input introduces the unexpected result. Keep the original workbook intact while diagnosing it, especially if it contains important formulas, links, or manually entered data.

Frequently Asked Questions

Why is Excel showing my formula instead of the answer?
Check whether the cell is formatted as Text, has a leading apostrophe, or has a space before the equals sign. If many formulas are visible, turn off Show Formulas from the Formulas tab.

Why does my Excel formula not update automatically?
Calculation may be set to Manual. In Excel for Microsoft 365 on Windows, choose Formulas > Calculation Options > Automatic, then check whether the result recalculates.

Why does Excel say there is a problem with this formula?
Check for a misspelled function, missing parentheses, invalid references, or an argument separator that does not match your regional settings. The formula bar can help you find the exact character or reference that needs attention.

Why does my formula return #NAME?
Excel may not recognize a function name or a text value in the formula. Check spelling and quotation marks, and confirm that your Excel version supports the function.

Why does a copied formula give the wrong answer?
Relative references adjust when copied. Check whether the formula should use a fixed reference with dollar signs, or whether it is pointing to the correct row and column after copying.

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.