Excel Not Taking Formula? Fix the Cell or Calculation

Errors & fixes · Updated November 18, 2026

If Excel is not taking a formula, first check whether the cell is formatted as Text: set it to General, then re-enter the formula by pressing F2 and Enter. If the formula is accepted but its result does not change, check Formulas > Calculation Options > Automatic. These two fixes solve many cases, but formula syntax, display settings, and cell references can cause similar symptoms.

First identify what “not taking” means

Look at the cell after you type a formula and press Enter. The visible symptom points to a different cause, so avoid changing settings at random:

  • The cell shows the formula characters, such as =A2+B2, instead of a result. Excel may be treating the entry as text, or Show Formulas may be enabled.
  • The cell shows an error, such as #NAME? or #VALUE!. Excel has evaluated something, but the formula or its inputs need attention.
  • The cell shows an old result after an input changes. Calculation may be set to Manual, or the formula may not refer to the changed cell.
  • Excel does not appear to accept the entry. Check whether you are editing the cell, whether the sheet is protected, and whether the entry begins with an equals sign.

Click the cell and inspect the formula bar above the worksheet. It helps distinguish what is stored in the cell from how the cell is displayed. If the formula bar shows the expected expression but the grid shows a result, the formula is present; investigate calculation or formatting rather than retyping it.

Fix a formula stored as text

A cell formatted as Text tells Excel to preserve what you type rather than interpret it as a formula. This often happens when a column was formatted before data was entered, or when a formula was pasted from another application. A leading apostrophe can also force text entry; Excel may hide that apostrophe in the grid while showing it in the formula bar.

  1. Select the affected cell or range.
  2. On the Home tab, open the Number Format list and choose General.
  3. Re-enter each formula. Select a cell, press F2, then press Enter. For a range, you can also edit and confirm cells individually; changing the format alone does not convert existing text into formulas.

For a new entry, make sure the first character is an equals sign, with no apostrophe or other character before it. For example, with the values 12 in A2 and 5 in B2, enter this in C2: =A2+B2. The result is 17. If the cell is still formatted as Text, Excel may display the characters =A2+B2 rather than calculate 17.

On Windows, F2 edits the active cell. Some laptop keyboards require Fn+F2. On a Mac, use Control+U to edit a cell, or double-click it; keyboard behavior can depend on the Mac’s function-key settings. The reliable check on either platform is to change the format and confirm the entry again.

Check formula syntax and separators

Excel formulas normally begin with =. A missing equals sign makes an entry ordinary text or a value, not a formula. After that, check for unmatched parentheses, misspelled function names, incorrect cell references, or quotation marks that do not pair correctly. A formula with a typo in a function name may return #NAME?; that is different from Excel refusing to recognize a formula at all.

Argument separators depend on regional settings. In many installations, commas separate function arguments; in others, Excel expects semicolons. If a formula copied from a website is rejected even though its structure looks right, check the separator used by your installation. Excel’s Insert Function dialog and formula suggestions can help show the syntax expected in your environment.

For example, with numbers in B2:B4, enter this in B5: =SUM(B2:B4). If B2 is 3, B3 is 4, and B4 is 5, the result is 12. The colon means the range includes every cell from B2 through B4. If Excel rejects a function with multiple arguments, compare its separators with a formula created using the Function Arguments dialog rather than changing commas and punctuation blindly.

Also check that text inside formulas uses straight quotation marks, not typographic “curly” quotation marks introduced by a word processor. A formula copied from formatted text can contain lookalike punctuation that Excel does not parse as intended. Retyping the punctuation directly in Excel is often the quickest correction.

Make sure calculation is updating

When a formula is visible in the formula bar and produces a plausible but outdated result, calculation mode is a strong possibility. In Excel for Microsoft 365 on Windows, select Formulas > Calculation Options > Automatic. In Automatic mode, Excel recalculates dependent formulas when their inputs change. With Manual selected, results can remain unchanged until a calculation is requested.

Press F9 to recalculate open workbooks, or use Formulas > Calculate Now. To calculate only the active worksheet, use Formulas > Calculate Sheet. On a Mac, the Formulas tab also provides calculation controls; function-key shortcuts may require the Fn key depending on keyboard settings. Excel for the web has a Formulas tab too, though available controls can differ from the desktop app.

Manual calculation can be useful in a workbook with many complex formulas, but it can make a correct formula look broken. After switching to Automatic, inspect a result that depends on several formulas to confirm that the updates have flowed through. If only one value is stale, check whether that particular formula actually refers to the changed input.

Rule out Show Formulas and display formatting

If many cells display expressions instead of results, Show Formulas may be turned on. In Windows desktop Excel, choose Formulas > Show Formulas to switch back to results. The Windows shortcut is Ctrl+` (the grave-accent key, usually near the top-left of the keyboard). On a Mac, use the Formulas tab command if the shortcut differs on your keyboard. This setting changes the worksheet view; it does not remove or repair formulas.

A cell can also contain a calculated value that looks blank or misleading because of its number format, column width, or font color. Widen the column if you see hash marks such as #####, and check Home > Number Format if a result appears as an unexpected date, percentage, or rounded value. Those symptoms do not usually mean Excel rejected the formula.

To verify what Excel stored, select the cell and read the formula bar. You can also use Formulas > Evaluate Formula on the desktop app to step through how Excel evaluates a formula. This is especially helpful when the formula returns an unexpected answer rather than an error.

Understand common formula errors

An error value means Excel parsed and attempted to calculate the expression; the next step is to diagnose the error rather than reformat the cell. Common examples include:

  • #NAME?: Excel does not recognize a name in the formula. Check for a misspelled function, an undefined named range, or text that needs quotation marks.
  • #VALUE!: An operation received an incompatible value, often text where a number is needed. Check the referenced cells and any imported data.
  • #REF!: A reference is invalid, often because a referenced row, column, or sheet was deleted.
  • #DIV/0!: A calculation divides by zero or by a blank cell used as the divisor.
  • #SPILL!: A dynamic-array formula cannot place its results because one or more destination cells are occupied or otherwise unavailable.

Click the warning icon beside an error, when present, for Excel’s explanation and available options. Do not simply suppress an error with an error-handling function until you know why it occurred; hiding an error can make a worksheet appear correct while concealing bad inputs or broken references.

Check references, editing state, and worksheet limits

A formula may be accepted but appear not to work because it points somewhere unexpected. Click the formula cell and inspect the colored reference outlines that appear while editing. Confirm that the intended row, column, and worksheet are referenced. When copying formulas, relative references move by default; dollar signs make a reference absolute. If a formula should always use one input cell when copied down, consider whether that reference needs to be fixed with dollar signs.

Check whether Excel is still in cell-edit mode. A formula is not committed until you press Enter or click the check mark by the formula bar. Press Esc to cancel an accidental edit. If the worksheet is protected, some cells may not permit changes; use Review > Unprotect Sheet if you have permission and the sheet is protected. A protected workbook or organizational policy may require its owner or administrator to grant access.

Finally, inspect nearby cells if a formula is meant to return multiple results. Dynamic-array formulas in Microsoft 365 can spill results into adjacent cells, and existing content in the output area can prevent that. Clear only cells you know are safe to change. This is a different issue from a single-cell formula being stored as text.

A practical troubleshooting order

Work from the simplest checks to the less common causes. This sequence avoids deleting a formula or altering workbook settings before you know what is wrong:

  1. Click the cell and inspect the formula bar. Decide whether it contains a formula, text, or an error.
  2. If the formula characters appear in the grid, check Home > Number Format, remove any leading apostrophe or space, choose General, then re-enter.
  3. If an entire sheet shows expressions, turn off Formulas > Show Formulas.
  4. If the result is stale, set Formulas > Calculation Options to Automatic and recalculate.
  5. If there is an error, read its exact code and inspect names, references, inputs, and separators.
  6. If editing is blocked or results cannot spill, check sheet protection and the cells around the formula.

When a formula comes from a downloaded or shared workbook, save a copy before making broad changes. Avoid using Find and Replace across a whole workbook to alter formula punctuation unless you understand which cells it will affect. One carefully checked test formula in an empty cell can help separate a workbook-specific issue from a general Excel setting.

Frequently Asked Questions

Why does Excel show the formula instead of the answer?

The cell may be formatted as Text, the formula may start with an apostrophe, or Show Formulas may be enabled. Check the cell’s number format and re-enter the formula; if many cells show formulas, toggle Formulas > Show Formulas off.

Why does my Excel formula not update when I change a value?

Check Formulas > Calculation Options > Automatic. If calculation is already automatic, verify that the formula references the cell you changed and that the value was entered in the expected cell.

Do Excel formulas need an equals sign?

Yes. A formula entered in a worksheet cell normally starts with =. Without it, Excel treats the entry as text or a value rather than as a calculation.

Why does Excel reject commas in my formula?

Your regional settings may use semicolons as function-argument separators. Check the syntax Excel offers in the Function Arguments dialog or in a formula suggestion, then use the separator your installation expects.

Will changing a cell from Text to General fix an existing formula?

Not by itself. Change the format, then edit and confirm the entry again—for example, select the cell, press F2, and press Enter. That prompts Excel to interpret the stored characters as a formula.

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.