Excel Formulas Not Calculating: Causes and Fixes

When Excel formulas are not calculating, the cause may be a workbook setting, a cell format, or a small issue in the formula itself.

These checks help identify why results are missing or stale and how to fix them without changing unrelated data.

Check whether Excel is set to calculate automatically

If formulas remain unchanged after you edit their inputs, the workbook may be using manual calculation.

In Excel for Windows, open Formulas > Calculation Options and select Automatic.

On Mac, check the calculation settings under Excel’s preferences or the Formulas tab; labels can vary by version.

To recalculate a worksheet manually, press F9.

Use Ctrl+Alt+F9 in Windows Excel to force a full calculation of all open workbooks.

On Mac, keyboard shortcuts can differ by keyboard and Excel version, so use the calculation commands in the Formulas menu if needed.

Manual mode can be useful in large workbooks because it prevents lengthy recalculations after every change.

But calculation mode may affect other open workbooks in the same Excel session.

After switching to automatic, check whether the affected formula updates when you change one of its referenced cells.

Why is Excel displaying the formula instead of its result?

If a cell shows =A1+B1 rather than the sum, Excel may be treating the entry as text, or the worksheet may be showing formulas across the grid.

Turn off Show Formulas: Select Formulas > Show Formulas.

The shortcut is often Ctrl+` in Windows, where the grave accent key is usually near the top-left of the keyboard.
Check the cell format: Select the cell and choose Home > Number Format > General.
Re-enter the formula: After changing a text-formatted cell to General, press F2 and then Enter.

Formatting alone may not convert an existing text entry into a formula.
Look for a leading apostrophe: An entry such as '=A1+B1 is stored as text.

Remove the apostrophe, then confirm the formula.

For example, if A1 contains 4 and B1 contains 6, =A1+B1 should return 10.

If the formula is visible as text, check its format and the Show Formulas setting before rewriting it.

Inspect the formula for syntax and separator issues

A formula must begin with an equals sign, and its function names, parentheses, references, and argument separators must match the syntax Excel expects.

For instance, a SUM formula for cells A1 through A5 is =SUM(A1:A5).

Regional settings can affect the separator between function arguments.

One installation may accept =IF(A1>0,"Yes","No"), while another expects semicolons: =IF(A1>0;"Yes";"No").

If Excel reports a problem with a formula copied from a website or another computer, check the list separator in your regional settings and replace commas or semicolons as needed.

Also check for missing closing parentheses, unmatched quotation marks around text, and references that point to the intended cells.

For example, =A1+B1 adds two cells, while =A1+B2 refers to a different second row.

A formula that calculates successfully can still return an unexpected answer if its references are wrong.

Look for text values, spaces, and hidden characters

Numbers stored as text can cause formulas to behave unexpectedly, especially in imported CSV data or copied values.

A green triangle in a cell may indicate that Excel has identified a number stored as text.

Depending on the data, use the warning menu’s conversion option or a suitable conversion method, then verify the result.

For a simple check, if A1 contains the text 12 and B1 contains the number 3, the formula =A1+B1 may work in some circumstances because Excel coerces text that looks numeric.

Other functions and text formats may not.

Avoid relying on implicit conversion when the data is inconsistent.

Leading or trailing spaces can interfere with lookups and comparisons.

For text in A2, =TRIM(A2) removes ordinary extra spaces at the beginning and end and reduces repeated internal spaces.

It does not remove every nonprinting character; imported data may contain nonbreaking spaces or other characters that need separate cleanup.

Review references, ranges, and workbook links

Check that the formula points to the expected cells and that its range includes all relevant rows.

For example, =SUM(B2:B10) excludes values in B11.

If you copy formulas down a column, relative references adjust automatically; add dollar signs to lock a reference when needed.

In =$A$1*B2, the reference to A1 stays fixed while B2 changes as the formula is copied.

Formulas linked to another workbook may show old values or prompt you to update links.

Confirm that the source file is available and that the link points to the correct location.

Excel may also display a cached value when the linked workbook is closed, so verify the link status before treating that value as current.

For formulas using newer functions such as XLOOKUP, FILTER, or LET, check the Excel version and platform.

These functions are available in supported Microsoft 365 versions and newer perpetual releases, but may be unavailable in older Excel editions.

An unsupported function may display #NAME? or another error rather than calculate as expected.

Google Sheets supports many similar functions, but function availability and syntax can differ.

Use the displayed error to narrow the cause

Error values are clues, not interchangeable failures.

Check the specific formula and inputs before changing the workbook:

#VALUE! often points to an incompatible value type or an argument the function cannot use.
#REF! indicates an invalid reference, often because a referenced row, column, or sheet was deleted.
#NAME? can mean Excel does not recognize a function name or text in the formula.
#DIV/0! appears when a calculation divides by zero or by an empty cell treated as zero.
#N/A commonly signals that a lookup did not find a match, though it can also be returned intentionally by a formula.

For a division formula in C2, =A2/B2 returns #DIV/0! when B2 is zero or blank.

If zero is a valid possibility, decide how the result should be represented.

For example, =IF(B2=0,"",A2/B2) leaves C2 blank when B2 is zero; the formula should be adapted if a blank would hide meaningful information.

When should you check for circular references?

A circular reference occurs when a formula refers to its own cell, either directly or through a chain of other formulas.

For example, entering =A1+1 in A1 creates a direct circular reference.

Excel may show a warning or a circular reference indicator, and the result may not behave as intended.

Trace the cell references and correct the formula if the circular link is accidental.

Some financial models intentionally use iterative calculations, but enabling iteration changes how Excel resolves circular formulas.

Check the workbook’s design before turning that setting on.

Quick troubleshooting order

Confirm that the cell contains a formula beginning with =, not text that resembles one.
Check whether Show Formulas is enabled and whether the cell is formatted as Text.
Set calculation to Automatic, then recalculate with F9 if needed.
Review separators, parentheses, cell references, and range boundaries.
Inspect input cells for text-formatted numbers, spaces, blanks, and error values.
Check external links, function compatibility, and circular references.

Make one change at a time and compare the result with a small, known example.

This helps pinpoint the cause while preserving the rest of the worksheet’s formulas and data.