Typing a Formula in Excel but It Is Not Calculating?

Errors & fixes · Updated November 21, 2026

If a formula you type in Excel is not calculating, first check that the cell is not formatted as Text: change its format to General, then edit the cell and press Enter. If formulas appear instead of results, turn off Formulas > Show Formulas; if results stay outdated, set Formulas > Calculation Options to Automatic.

First identify what “not calculating” means

Excel problems that sound alike often have different causes. A cell might display the formula itself, show a result that does not change, display an error such as #VALUE!, or remain blank. Notice which is happening before changing settings. A formula displayed as text points toward cell formatting or an extra character; a stale result suggests calculation mode or references; an error usually means Excel evaluated the formula but could not complete it.

Try a small test in an empty cell. With 2 in A1 and 3 in B1, enter =A1+B1 in C1. The expected result is 5. If C1 shows the characters =A1+B1, investigate text formatting and Show Formulas. If C1 returns 5 but your original formula does not, the problem is more likely in that formula’s inputs, references, or logic. This quick distinction prevents unnecessary changes to the whole workbook.

Check whether Excel is showing formulas

When Show Formulas is enabled, Excel displays formulas in worksheet cells in place of their calculated results. This is a viewing mode, not evidence that the formulas have stopped working. It can make columns appear wider because formulas often take more space than results, and it can affect the view of the worksheet rather than just one cell.

In Excel for Microsoft 365 on Windows, go to Formulas > Show Formulas to switch the view off. The Windows shortcut is Ctrl+` (the grave-accent key, usually near the upper-left of the keyboard). On a Mac, use Formulas > Show Formulas; the shortcut may differ with the keyboard layout. If only one cell displays its formula while neighboring cells show results, Show Formulas is less likely to be the cause: inspect that cell’s format and contents instead.

Set calculation mode to Automatic

Excel can be set to calculate formulas automatically or wait for a manual calculation. In manual mode, a formula may show an old result even after you change one of its inputs. Open Formulas > Calculation Options and select Automatic. Then edit an input or recalculate to see whether the result updates. Automatic is the usual choice for everyday workbooks.

Manual calculation can be useful in a large workbook where recalculating after every edit takes noticeable time. The trade-off is that displayed results can become out of date, which is risky if someone reads or shares the workbook without recalculating first. If you intentionally use manual mode, make recalculation part of your workflow and verify important results before relying on them.

On Windows, F9 recalculates formulas in open workbooks. Shift+F9 recalculates the active worksheet. If a workbook still appears to have stale dependencies, Ctrl+Alt+F9 forces calculation of all formulas in open workbooks. Laptop function keys may require holding Fn. These shortcuts recalculate formulas; they will not fix a formula stored as text or correct an invalid reference.

Convert text to a real formula

A cell formatted as Text treats what you type as text, so an entry beginning with an equals sign may be displayed literally rather than evaluated. This often happens when a cell or column was formatted before data was entered, or when content was pasted in from another source. Changing the cell’s format to General is necessary, but it may not convert an existing entry by itself: Excel may continue to store the old contents as text.

For a single cell, select it, choose Home > Number Format > General, then edit the cell and press Enter. On Windows, you can select the cell and press F2 to edit it before pressing Enter. For a range, select the affected cells, set their format to General, and re-enter the contents so Excel parses them as formulas. Check a few results before applying a bulk change to important data.

Also look for an apostrophe or a space before the equals sign. An entry such as ‘=A1+B1 (with an apostrophe at the beginning) is deliberately treated as text; a leading space can likewise prevent normal formula entry. Remove the extra character, then confirm that the entry begins with =. Do not confuse a text result with a formula that returns text: a valid formula can calculate successfully and still produce a word or an empty string, depending on its logic.

Check formula syntax and cell references

If Excel displays an error instead of a result, it may be calculating but encountering a problem in the expression. Check that parentheses are balanced, operators are in the intended order, and references point to the cells you mean. In functions, arguments must be separated using the list separator expected by your Excel settings. Commas are common, but some regional settings use semicolons; if Excel rejects a formula that uses commas, check the separator used by your existing formulas.

For a basic addition example, with quantities in A2 and B2, enter =A2+B2 in C2. If A2 contains 12 and B2 contains 8, the result is 20. For a total, with amounts in B2 through B4, enter =SUM(B2:B4) in B5. If those cells contain 10, 15, and 25, B5 should show 50. These examples also help check whether the cells contain numeric values rather than numbers stored as text.

Errors give clues. #NAME? can mean Excel does not recognize a function name or text in a formula was not enclosed correctly. #REF! indicates an invalid reference, often because a referenced cell was deleted. #VALUE! often means an argument or referenced value has the wrong type for the operation. Correct the underlying issue rather than hiding the error: wrapping a formula to suppress an error can conceal a real data problem.

Check references when copying formulas, too. A reference such as A2 changes when a formula is copied to another row; a reference such as $A$2 stays fixed. If a copied formula gives unexpected results, select it and inspect the colored reference outlines in the worksheet. An incorrect reference can produce a plausible number, so compare the formula with the intended calculation, not just with whether it displays a number.

Look for input and formatting issues

Sometimes the formula is valid, but its inputs are not the values they appear to be. A number imported from a text file may be stored as text, dates may be interpreted differently under regional settings, and a cell may contain spaces that are hard to see. If adding two apparent numbers produces an error or an unexpected result, inspect the source cells and try entering a simple test number in a blank cell.

Formatting can also make a result look wrong. A cell with a date format may display a number as a date; a narrow column may show ### for a value that does not fit; and a custom number format can hide displayed zeros. These are display issues rather than proof that calculation failed. Select the result cell and check its number format under Home > Number Format, then widen the column if needed.

For formulas involving dates or times, confirm that the inputs are recognized as dates or times by Excel, not merely text that resembles them. For example, subtracting two real date values can return the number of days between them, while text dates may not behave as expected. Avoid converting a whole column or changing regional settings until you have checked a small sample and know how the imported data should be interpreted.

Refresh calculations and diagnose workbook issues

If the formula looks correct and is not stored as text, test whether a fresh calculation changes the result. Press F9 on Windows, or change an input temporarily and restore it. If the result updates only after recalculation, check the calculation mode and any formulas that depend on other cells. If it does not, trace the references and confirm that the cells being used contain the values you expect.

Another useful check is to enter the test formula from the first section in an empty cell. If that works, the issue is specific to the original formula or its inputs. If it also displays literally, inspect the test cell’s format and the worksheet’s Show Formulas setting. If it calculates but a more complicated formula does not, simplify the expression in stages or use Formulas > Evaluate Formula to follow how Excel evaluates parts of it. This is especially helpful with nested functions and long references.

Be cautious with circular references: a formula that directly or indirectly refers back to its own result may produce a warning or an unexpected outcome. For example, a total cell that includes itself in its sum range creates a circular reference. Review the ranges in totals and make sure the formula cell is not included accidentally. Do not enable iterative calculation just to make a warning disappear unless the workbook is intentionally designed to use circular calculations and you understand the consequences.

If the problem occurs only in one workbook, save a separate copy before making broad changes. Compare the affected formula with a working one, check for external workbook links, and see whether the issue persists in a new blank workbook. This helps distinguish a workbook-specific configuration or data issue from a setting that affects Excel more generally.

Excel for the web and Mac differences

The main checks are similar in Excel for the web: inspect the cell’s number format, look for a leading apostrophe or space, and check the workbook’s calculation settings where available. Menus and keyboard shortcuts can differ from the Windows desktop app, and browser shortcuts may be intercepted by the browser. If a command is not present in the web ribbon, open the workbook in the desktop app to check the full calculation controls.

On Mac, use the ribbon’s Formulas tab to find Show Formulas and Calculation Options when those controls are available in your Excel version. Function keys may require Fn, and keyboard shortcuts vary with the keyboard layout and system settings. The underlying distinction remains the same: a formula shown literally is different from a formula that has calculated to an old value or returned an error.

Frequently Asked Questions

Why does Excel show the formula instead of the answer?
Most often, Show Formulas is enabled, or the cell is formatted as Text. Turn off Formulas > Show Formulas to check the first possibility. If only one cell is affected, set it to General and re-enter the formula; changing the format alone may not convert content already stored as text.

Why does my Excel formula show as text even after I change the format?
Excel may still have the original entry stored as text. After setting the cell to General, edit the entry and press Enter so Excel reads it again. Also remove any leading apostrophe or space before the equals sign.

Why is my Excel formula not updating when I change a value?
Check Formulas > Calculation Options and select Automatic. If the workbook is intentionally in manual mode, recalculate with F9 on Windows. Then confirm that the formula actually refers to the cell you changed.

Why does Excel show a formula error instead of calculating?
An error usually means Excel did evaluate the formula but found a problem, such as an invalid reference, an unrecognized function name, or an input of the wrong type. Read the error, check the referenced cells and separators, and compare the expression with a simpler working calculation.

Can I fix a whole column of formulas stored as text?
Yes, but first make a copy of the workbook or test on a small range. Select the cells, set their number format to General, and re-enter the contents so Excel parses them. Verify that the results and references are correct before applying the change to the remaining rows.

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.