Excel Formula Not Calculating? Common Causes and Fixes

If a formula will not calculate in Excel, check that the cell is not formatted as Text, that the formula begins with an equals sign, and that calculation is set to Automatic. Then re-enter the formula or recalculate the workbook; the right fix depends on whether Excel shows the formula itself, an old result, or an error.

Start by identifying what Excel displays

A cell that appears not to work can have several different issues. Look at the formula bar and the cell result before changing settings: a formula displayed literally, a stale value, an error message, and a blank-looking result point to different causes. If you can, select the cell and inspect its number format and the formula bar as well.

You see the formula characters in the cell: Excel may be treating the entry as text, or Show Formulas may be turned on.
You see a previous answer that does not change: calculation may be set to Manual, or the formula may not refer to the cell you edited.
You see an error such as #VALUE! or #NAME?: the formula is being evaluated, but Excel cannot resolve an input, function, reference, or operation.
You see a blank or an unexpected zero: the formula may be designed to return that result, or formatting may hide what the cell contains.

These distinctions matter. Repeatedly pressing Enter will not fix a misspelled function, while changing calculation settings will not make a text-formatted formula parse correctly.

Check calculation mode and recalculate

In Excel for Microsoft 365 on Windows, open Formulas > Calculation Options and select Automatic. In Automatic mode, Excel normally recalculates formulas when their referenced values change. If the workbook is set to Manual, results can remain unchanged until you request a calculation. Calculation mode can affect other open workbooks too, so check it if a second workbook also appears not to update.

To prompt a calculation on Windows, press F9 to calculate open workbooks, or press Shift+F9 to calculate the active worksheet. Ctrl+Alt+F9 forces a full calculation of formulas in open workbooks. On a Mac, keyboard mappings can depend on the keyboard and function-key settings; use the calculation commands on the Formulas tab if a shortcut does not work. Excel for the web also recalculates supported formulas, though its available controls can differ from desktop Excel.

Use Manual calculation only when you have a reason, such as a very large workbook whose formulas take a long time to update. If you choose it, remember that a displayed value may be out of date. Before relying on a result, switch back to Automatic or explicitly recalculate and confirm the value changes as expected.

Fix formulas being treated as text

If you see something like =SUM(B2:B4) in the cell instead of its answer, first make sure Formulas > Show Formulas is not enabled. That command changes the worksheet display from calculated results to formulas; it does not change the formulas themselves. Turn it off to return to the usual results view. The Windows shortcut Ctrl+` toggles this display; the key may be in a different location on some keyboards.

If Show Formulas is off, the cell may be formatted as Text. Select the cell, choose Home > Number Format and select General, then edit the entry and press Enter so Excel parses it again. Merely changing the format does not always convert an existing text entry into a formula; re-entering it is the important step. A leading apostrophe also tells Excel to treat an entry as text. Remove that apostrophe if it was accidental.

Another possibility is that the formula was pasted with a character before the equals sign or as plain text from another source. Click the cell and inspect the formula bar. If the entry should be a calculation, remove unwanted characters, ensure the first character is =, and press Enter. If you intentionally need to display a formula as text—for documentation, for example—do not remove the apostrophe or change the cell to a formula.

Verify the formula’s syntax and separators

Excel formulas need valid syntax: a function name must be recognized, parentheses must balance, and references and operators must be in the right places. For example, with 10, 20, and 30 in cells B2:B4, the formula below belongs in another cell and returns 60:

=SUM(B2:B4)

Check that the formula starts with = and that function arguments are separated correctly for your regional settings. The examples here use commas. Some Excel installations expect semicolons because of locale settings; if Excel rejects a correctly structured formula with a message about the formula, try the separator used by your installation. Do not replace commas with semicolons indiscriminately if your Excel expects commas.

Typos can also prevent a formula from working. A misspelled function may produce #NAME?, while an extra or missing parenthesis can prompt Excel to flag a formula as invalid. When editing a long formula, inspect it in the formula bar and use Excel’s function argument prompts where available. If the formula came from a website or another spreadsheet program, check for incompatible function names or syntax rather than assuming every spreadsheet uses identical formulas.

Check references, inputs, and copied formulas

A formula can calculate successfully and still give the wrong answer because it points to the wrong cells. Select the formula cell and look at its references in the formula bar. When copying a formula down or across, relative references adjust automatically; absolute references marked with dollar signs stay fixed. A reference that shifted unexpectedly can make a result appear not to respond to the intended input.

For instance, with 12 in A2 and 8 in B2, entering this formula in C2 returns 20:

=A2+B2

If you copy that formula to C3, Excel normally changes the references to A3 and B3. If the desired calculation should always use a fixed cell, make that reference absolute before copying. Also check that the changed input is actually within the formula’s referenced range. A formula summing B2:B4 will not respond to a value entered in B5.

Inputs that look like numbers may be stored as text, particularly when pasted from a website, exported file, or system using different decimal and thousands separators. A number stored as text may behave unexpectedly in arithmetic, comparisons, or sorting. Check for warning indicators, inconsistent alignment, or an apostrophe in the formula bar. Convert the source values to real numbers using an appropriate Excel conversion method, then verify the calculation again.

Understand common formula errors

An error value is useful evidence: it means Excel evaluated the formula but encountered a problem. The error type often narrows the search. #DIV/0! commonly means a calculation divides by zero or an empty cell. #VALUE! often points to an input of the wrong type. #REF! means a reference is invalid, often because referenced cells were deleted. #NAME? can indicate an unrecognized function or an unquoted text label. #N/A generally means a value needed by a lookup or another operation was not available.

Do not hide an error before finding its cause. For example, wrapping a formula in an error-handling function might make a worksheet look tidy while concealing a broken reference or missing input. First inspect the cells involved, confirm that expected values are present, and check for deleted or moved source cells. If the error is expected for some rows, then decide how the workbook should present that case.

A circular reference is another special case: a formula refers, directly or indirectly, to its own result. Excel may warn about it, and the outcome depends on whether iterative calculation is enabled. Most ordinary totals and calculations should not need a circular reference. Trace the references and correct the loop unless the workbook intentionally uses iterative calculations and has been designed for them.

When the result looks blank or incorrect

Sometimes Excel is calculating, but the displayed result is misleading. A custom number format can hide values, and a formula may intentionally return an empty string under certain conditions. A column that is too narrow can also display number signs for some numeric formats; widen it to see whether the value becomes visible. Select the cell and check the formula bar to distinguish a truly empty cell from a cell that contains a formula or value.

Rounding and display precision can cause another misunderstanding. A cell may show 1.23 while its underlying value contains more decimal places, so later calculations use more precision than the screen suggests. If the displayed answer seems off by a small amount, inspect the number format and the underlying value before changing the formula. Formatting a value to show fewer decimals is not the same as rounding the value used in later calculations.

Also examine the logic of the formula. A conditional formula can return a blank or zero when a test is false, and a lookup can return a valid but unexpected match if its lookup range or match settings are wrong. Check the inputs and each part of the formula rather than assuming every unexpected result is a calculation failure.

Work through a reliable troubleshooting sequence

A short, ordered check is usually faster than changing several workbook settings at once. Start with the simplest explanations, then investigate references and errors. If you make one change at a time, it is easier to identify what actually resolved the problem.

Click the cell and see whether the formula bar contains a formula, a text entry, or an error.
If the formula itself appears in the grid, turn off Show Formulas and check whether the cell uses Text format or starts with an apostrophe.
Confirm the formula starts with =, uses recognized function names, and has valid separators and parentheses.
Check Formulas > Calculation Options and select Automatic if you want results to update as inputs change.
Confirm the edited input is included in the formula’s references and is stored in the intended type, such as a number rather than text.
Recalculate the worksheet and inspect any error value or unexpectedly hidden result.

If the problem occurs only in one workbook, compare its calculation mode, formulas, and source data with a workbook that behaves normally. If it occurs across files, look for an application-wide calculation setting or a difference in regional separators. Avoid enabling macros, changing security settings, or installing add-ins as a first response; those steps rarely address a basic formula-entry or calculation-mode issue.

Frequently Asked Questions

Why is Excel showing my formula instead of the answer?

Check whether Formulas > Show Formulas is turned on. If it is off, change the cell’s format from Text to General and re-enter the formula. Also check for a leading apostrophe, which makes Excel treat the entry as text.

How do I make Excel recalculate a formula?

Set Formulas > Calculation Options > Automatic to update formulas as inputs change. For a one-time refresh on Windows, F9 calculates open workbooks and Shift+F9 calculates the active worksheet. On Mac, use the Formulas tab if the keyboard shortcut differs on your setup.

Why does my formula return zero when the cells contain values?

Check the formula’s references first: the values may be outside the range it uses. Then check whether those values are stored as text, whether a condition in the formula returns zero, and whether number formatting is hiding or rounding the displayed result.

Why does Excel say there is a problem with this formula?

Common causes include a missing equals sign, mismatched parentheses, an unrecognized function name, or an argument separator that does not match your regional settings. Review the formula in the formula bar and check whether your Excel expects commas or semicolons between arguments.

Why does a formula work in one row but not another?

Copied formulas usually adjust relative references. A formula that worked in one row can point to different cells after copying, or the later row may contain a blank or text value. Select both formulas and compare their references and inputs.

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

More in Formulas & functions

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

Spotted an error in this guide? Let us know.