Excel Not Evaluating Formula? Fix Common Causes

Errors & fixes · Updated November 18, 2026

If Excel is not evaluating a formula, first select Formulas > Calculation Options > Automatic, then check that the cell is not formatted as Text and that Show Formulas is turned off. These checks resolve many cases; if the cell still does not show the expected result, inspect the formula’s syntax, references, and any calculation errors.

Start with three quick checks

Before changing a workbook’s settings, identify what the cell actually displays. A formula cell may show the formula itself, a stale result, an error such as #VALUE!, or a result that looks wrong because of number formatting. Each symptom points to a different cause.

  1. If you see the formula instead of an answer: turn off Show Formulas, then check whether the cell is stored as text.
  2. If you see an old answer: set calculation to Automatic or recalculate the workbook.
  3. If you see an error: read the error and inspect the inputs and references rather than changing calculation mode.

Also confirm you are looking at the intended cell and workbook. Click the cell and look at the formula bar: it helps distinguish a displayed result from the actual cell contents. If a formula was just entered, press Enter once and see whether Excel accepts it.

Check Excel’s calculation mode

In Microsoft 365 for Windows, open Formulas > Calculation Options and select Automatic. In Automatic mode, Excel recalculates formulas when their inputs change. If the setting is Manual, formulas can remain unchanged until you request a calculation. Manual mode is sometimes used in large workbooks to reduce delays, but it can make results appear out of date.

After switching to Automatic, recalculate if necessary. On Windows, F9 calculates open workbooks, while Shift+F9 calculates the active worksheet. If function keys control hardware features on your keyboard, you may need to hold Fn as well. On Mac, use the Formulas tab’s calculation commands if the function-key shortcut is intercepted by macOS or your keyboard settings. Excel for the web also has calculation options on the Formulas tab, though the available controls can depend on the workbook and browser experience.

Automatic calculation is usually the right choice for ordinary workbooks. If a file is large and calculation is intentionally manual, remember to recalculate before relying on or sharing the displayed results. A workbook that opens with old values is not necessarily damaged; it may simply have been saved while calculation was set to Manual.

Look for formulas stored as text

A cell formatted as Text may keep an entry that looks like a formula as literal text instead of evaluating it. This often happens when a user formats a column as Text before pasting data, or imports a file that treats every field as text. A leading apostrophe can have a similar effect: Excel uses it to mark an entry as text, and it is not part of the displayed value.

To correct a single cell, select it, choose Home > Number Format, and change Text to General. Then re-enter the formula: press F2 and then Enter on Windows, or double-click the cell and press Return on Mac. Changing the format alone does not reliably convert existing text into a working formula; Excel must parse the entry again.

For a range of text-formatted entries, select the cells, change their format to General, and use Data > Text to Columns followed by Finish when appropriate. This can prompt Excel to reinterpret the contents, but inspect the result first, especially if the range contains dates, identifiers, or values with leading zeros. Those may need to remain text. For one cell, re-entering the formula is often the clearest fix.

For example, with the number 12 in A2 and 8 in B2, the formula to add them is =A2+B2, which returns 20. If that entry is stored as text, Excel displays the characters rather than calculating the sum. After changing the cell to General, edit and confirm the entry again.

Turn off Show Formulas

Excel has a view setting that displays formulas in worksheet cells instead of their calculated results. If many cells suddenly show expressions, this is a likely explanation—not a failure of calculation. In Windows, press Ctrl+` (the grave-accent key, often near Esc) to toggle the view, or select Formulas > Show Formulas. On Mac, Control+` commonly toggles it; use the Formulas tab if the shortcut differs on your keyboard.

When Show Formulas is enabled, columns may appear wider because formulas take more space than typical results. Turning it off restores the normal display, but does not change the formulas or their underlying values. This setting affects the worksheet view, so check it when many formula cells display their expressions at once.

If just one cell shows an expression while neighboring cells show results, Show Formulas is less likely to be the cause. Check that individual cell for Text formatting, a leading apostrophe, or a missing formula-entry step. The formula bar can help: if the cell contents begin with an apostrophe or include unexpected spaces, edit the entry carefully.

Inspect formula syntax and cell references

Excel may reject a formula, interpret part of it as text, or return an error when its syntax is wrong. A formula generally begins with an equals sign, and parentheses and quotation marks must be paired. Function names must be valid, and text arguments need straight double quotation marks. Excel’s formula bar and error message often point to the part it cannot parse.

Argument separators can differ by regional settings. Many installations use commas between function arguments, while some use semicolons because of the computer’s list-separator settings. If a formula copied from a website or another computer is rejected, check the separator expected by your Excel installation; do not assume the formula logic itself is wrong. Excel will often display a helpful syntax prompt as you edit a function.

For a concrete check, suppose B2 contains 12, B3 contains 8, and B4 contains 5. With those values in B2:B4, =SUM(B2:B4) returns 25. If the result differs, confirm that the cells contain numbers rather than text, that the range includes the intended rows, and that no unexpected values are present. A function can calculate successfully and still return an unintended answer because its reference is wrong.

Relative references also change when formulas are copied. If a formula is filled down, a reference such as A2 normally shifts to A3, A4, and so on. To keep a reference fixed when copying, Excel uses dollar signs in an absolute reference, such as $A$2. Check the references in the formula bar when a formula works in one row but not another; the copied formula may be pointing somewhere different than expected.

Distinguish a calculation problem from a display problem

Sometimes Excel has calculated a value, but formatting makes it look like nothing happened. A narrow column may show hash marks for a date or number that does not fit. A number format with zero decimal places can hide small changes, and a custom format can suppress displayed values. Widen the column or inspect Home > Number Format before concluding that the formula has not run.

Dates can be confusing because Excel stores dates as serial numbers and displays them according to the chosen format. A formula that returns a number may appear as a date if the result cell is formatted as Date. Conversely, a date-like value stored as text may not behave like a date in arithmetic. Select the cell and temporarily choose General to inspect the underlying result, then apply the format that suits the intended output.

A result of zero can also be legitimate. For example, a formula may subtract equal values, refer to blank cells, or return zero because a condition was not met. Check the referenced cells and the formula’s logic. Avoid treating every unexpected-looking display as a calculation failure: the value may be current but formatted or logically produced in a way you did not expect.

Understand errors, circular references, and links

An error message usually means Excel evaluated the formula but could not produce the requested result. #DIV/0! indicates division by zero or a blank divisor in a relevant calculation; #NAME? often means Excel does not recognize a name or function; and #REF! indicates an invalid reference. #VALUE! commonly points to an argument or value of an unexpected type. Read the error, then trace the referenced cells and any function arguments.

A circular reference occurs when a formula depends on its own result, directly or through a chain of other formulas. Excel may warn about the reference, and the displayed value may not be what you expect. Find the circular reference and correct the logic unless the workbook deliberately uses iterative calculation. That setting is available under File > Options > Formulas on Windows; enabling it changes how Excel handles circular calculations, so it should not be used as a general fix for an unexplained formula.

Formulas that depend on another workbook may also show unexpected values if the source file is unavailable or the link has not been updated. Check whether the formula refers to an external workbook, whether that workbook has moved, and whether Excel is asking you to update links. Do not enable updates blindly if you do not recognize the source; confirm that the referenced file is trusted and current.

A reliable troubleshooting order

Use this sequence to narrow down the cause without making unnecessary changes to the whole workbook:

  1. Click the affected cell and inspect the formula bar to confirm what is actually in it.
  2. If the formula is visible in the grid, turn off Show Formulas. If only one cell is affected, check for Text formatting or an apostrophe.
  3. Set calculation to Automatic, then recalculate the worksheet or workbook.
  4. If an error appears, investigate the error and the referenced inputs rather than repeatedly pressing Calculate.
  5. Check number formatting, column width, references, and any links to other workbooks.
  6. Save a copy before making broad edits, especially in a workbook with imported data or complex formulas.

Do not delete and rebuild formulas until you know which symptom you have. Re-entering one text-stored formula is different from replacing a valid formula, and changing regional settings can affect how other applications interpret separators. A small, targeted correction is safer and easier to verify.

Frequently Asked Questions

Why is Excel showing the formula instead of the answer? Show Formulas may be enabled, or that cell may be stored as text. Toggle Formulas > Show Formulas first. If other cells show results normally, change the affected cell to General and re-enter the formula.

How do I make Excel recalculate a formula? Set Formulas > Calculation Options > Automatic. To recalculate on Windows, press F9 for open workbooks or Shift+F9 for the active worksheet. On Mac, use the calculation commands on the Formulas tab if the keyboard shortcut is unavailable.

Why does changing a cell from Text to General not fix it? Changing the number format does not always make Excel parse an existing text entry as a formula. After selecting General, edit the cell and confirm the entry again with Enter or Return.

Why does my formula work on one computer but not another? Regional settings may use different argument separators, or the computers may have different calculation settings. Compare the formula’s separators and the calculation mode. Also check whether the formula uses a function unavailable in the other Excel version.

Why does a formula return zero when I expect a value? Verify the referenced cells, the formula’s conditions, and whether numbers are stored as text. Also check whether number formatting is hiding decimals. A zero can be a valid calculated result even when the formula itself is working correctly.

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.