If Excel is not running a formula, first check Formulas > Calculation Options > Automatic, then confirm the cell contains a formula beginning with an equals sign and is not formatted as text. If the formula is visible instead of its result, turn off Formulas > Show Formulas; if the result is simply outdated, recalculate the workbook.
Start by identifying what “not running” means
Excel can appear to ignore a formula for several different reasons. The distinction matters: a formula displayed literally, a result that does not update, and an error such as #VALUE! point to different fixes. Before changing the workbook, click the problem cell and inspect both the formula bar and the cell itself.
- You see the formula characters in the cell: Show Formulas may be on, or the entry may be stored as text.
- You see a result that does not change: Calculation may be set to Manual, or the formula may not depend on the cell you changed.
- You see an error: Excel has evaluated the formula but encountered an issue with its values, references, or syntax.
- You see a blank: The formula may return an empty string, refer to empty cells, or be hidden by formatting.
Make a copy before experimenting if the workbook is important, particularly if you are about to replace formulas or change a large range. A useful first test is to select the formula cell and press F2, then Enter on Windows. This makes Excel re-enter that cell’s existing contents. It can help when an entry was pasted or stored as text, but it will not fix an incorrect formula or a workbook-wide calculation setting.
Check calculation mode and recalculate
In Microsoft 365 for Windows, open the Formulas tab and choose Calculation Options > Automatic. In Automatic mode, Excel recalculates dependent formulas when their inputs change. In Manual mode, displayed results may remain unchanged until you request a calculation. Manual mode can be useful in large, complex workbooks where recalculating after every edit takes too long, but it is a common reason a correct formula appears stuck.
After switching to Automatic, use F9 to calculate formulas in open workbooks, or Shift+F9 to calculate the active worksheet. Ctrl+Alt+F9 forces a full calculation of all formulas in open workbooks. These commands are useful when a result seems stale, but they do not correct a bad reference or make text into a formula. On a Mac, use Formulas > Calculate Now for a dependable menu option; the F-key shortcut may require Fn, depending on the keyboard and macOS settings.
Calculation mode can affect more than the one cell you are investigating. If it switches back to Manual, check other open workbooks: Excel’s calculation setting can be influenced by the first workbook opened in an Excel session, and the setting applies across open workbooks. Close and reopen the relevant files after setting the desired mode if the behavior is confusing. In Excel for the web, calculation is generally automatic, though a workbook’s formulas and dependencies can still cause results that seem unexpected.
Turn off Show Formulas if formulas appear in cells
When cells display entries such as =SUM(B2:B4) instead of a number, Excel may be showing formulas throughout the worksheet. On Windows, select Formulas > Show Formulas to switch back to calculated results. The setting applies to the worksheet, so many formulas may appear to change at once. Check the column width too: a narrow cell can make a long formula difficult to read, but it does not turn the formula into a result.
If only one cell shows the formula while neighboring formulas display results, inspect that cell’s format and contents. A leading apostrophe tells Excel to store an entry as text; the apostrophe may not be visible in the cell. A cell formatted as Text can also cause a newly typed formula to be treated as plain text. Select the cell, choose Home > Number Format > General, and then re-enter the formula. Merely changing the format may not convert an existing text entry, so press F2 and Enter or type the formula again.
Verify the formula’s syntax and starting character
A formula normally begins with an equals sign. If it starts with a space, an apostrophe, or another character, Excel may treat it as text rather than calculate it. Check for a missing parenthesis, a misspelled function name, or a separator that does not match your regional settings. Microsoft 365 for Windows commonly uses commas between function arguments, but some regional settings use semicolons. Excel’s formula bar and function suggestions can help you spot a syntax issue.
For example, with numbers in B2, B3, and B4, enter =SUM(B2:B4) in B5. If those cells contain 4, 6, and 10, the result is 20. The colon indicates a continuous range. If a formula was copied from a website or message, retype it in Excel if it contains unusual quotation marks, nonbreaking spaces, or other characters that look ordinary but are not valid formula characters.
Also distinguish a formula that returns zero from one that does not calculate. For instance, a SUM formula can return zero if its referenced cells contain numbers stored as text. The formula may be working correctly while the input data is not numeric. Select an input cell and check its alignment, warning indicator, or Number Format; imported data often needs conversion before calculations behave as expected.
Inspect cell references and copied formulas
A formula can calculate successfully yet produce the wrong or unchanged result because it refers to the wrong cells. Click the formula cell and follow the colored reference outlines Excel displays while editing. Confirm that the inputs you expect are actually included, and check whether a relative reference shifted when the formula was filled down or across.
Suppose sales amounts are in B2:B4, and you want their total in B5. With those values in B2:B4, the formula =SUM(B2:B4) returns 20 when the entries are 4, 6, and 10. If the total is unexpectedly 10, verify that the formula range has not become B2:B3 or moved to a different column. If a formula needs to keep referring to one fixed cell as it is copied, use an absolute reference such as $B$1; press F4 while editing a reference on Windows to cycle through reference styles. On Mac, the shortcut may depend on keyboard settings, so the formula bar is a reliable way to add the dollar signs directly.
Check for circular references too. A circular reference occurs when a formula refers to its own cell, directly or through a chain of other formulas. For example, a total entered inside its own summed range can include itself. Excel may warn about the circular reference or show a result that does not behave as expected. Move the result outside the range or correct the reference. Iterative calculation can be enabled for intentional circular models, but it should not be used to conceal an accidental reference.
Understand common errors and blank results
An error value is evidence that Excel evaluated something; the next step is to interpret the message rather than repeatedly recalculate. #DIV/0! means a calculation divides by zero or a blank denominator. #VALUE! often means an operation received an incompatible value, such as text where a number is expected. #REF! indicates an invalid cell reference, commonly after referenced cells were deleted. #NAME? can point to a misspelled function or unrecognized text in the formula.
For a lookup formula, #N/A often means Excel did not find a match under the formula’s matching rules. Check extra spaces, number-versus-text differences, and whether the lookup range contains the expected value. For an unfamiliar error, use the warning icon beside the cell or select Formulas > Error Checking to investigate. The exact cause depends on the formula, so replacing every error with zero can hide important data problems.
A blank-looking result may be intentional. Some formulas return an empty string, which looks blank but is not the same as an actually empty cell. A custom number format can also hide a displayed value without changing the underlying result. Select the cell and inspect the formula bar and Home > Number Format before assuming that the formula failed. If the formula uses a condition, check whether the condition is currently false and whether the formula is designed to return a blank in that case.
Check data types, dependencies, and external links
Formulas operate on the values Excel recognizes, not always on what a cell appears to show. A date imported as text may not behave like a date; a number with a leading apostrophe may not add like a number; and extra spaces can stop text comparisons from matching. Use a small test calculation in an empty cell or inspect the input format to isolate whether the problem is the formula or its source data.
Some formulas depend on other workbooks, named ranges, tables, or data connections. If an external workbook is closed or moved, a formula may show an old value, a broken reference, or a request to update links. Check Data > Workbook Links when that command is available for the workbook, and confirm the source file and permissions. A formula that refers to a table column can also change behavior if the table was renamed or its data range changed. These cases need their own source or reference fixed; pressing F9 alone is not a substitute.
Volatile functions such as NOW and TODAY recalculate as Excel recalculates, but their displayed value is not a continuously updating clock. They update during recalculation, not necessarily every second. This is a useful distinction when a timestamp or date seems frozen: confirm calculation mode and recalculate, while remembering that a formula-based timestamp is not the same as a fixed date entered once.
A practical order for troubleshooting
Work from broad settings to the individual cell so you do not alter a correct formula unnecessarily. If the issue affects every formula on a sheet, check Show Formulas and calculation mode first. If it affects just one cell, inspect that cell’s format, leading characters, syntax, and references. If the formula returns an error, diagnose the specific error and the values it uses.
- Click the cell and compare its displayed content with the formula bar.
- Check Formulas > Show Formulas, then set Formulas > Calculation Options > Automatic if appropriate.
- Set a formula cell’s format to General and re-enter it if Excel is displaying the formula as text.
- Confirm the formula starts with an equals sign and that its references include the intended input cells.
- Check whether source values are numbers, dates, or text as required by the calculation.
- Recalculate with F9 on Windows, or use Formulas > Calculate Now on Mac, and then interpret any error that remains.
If only one workbook behaves differently, test a copy in a new workbook or open a known-good workbook in the same Excel session. That can help separate a workbook-specific issue, such as external links or a circular reference, from an Excel-wide calculation setting. Avoid deleting and rebuilding formulas until you have recorded the original formula and identified what is wrong.
Frequently Asked Questions
Why is Excel showing the formula instead of the answer?
Turn off Formulas > Show Formulas. If only one cell is affected, change its number format from Text to General and re-enter the formula; changing the format alone may not convert text that is already stored in the cell.
Why does my Excel formula not update when I change a value?
Check Formulas > Calculation Options > Automatic. In Manual mode, press F9 on Windows to calculate, or use Formulas > Calculate Now on Mac. Also make sure the formula actually references the changed cell.
Why does Excel show the formula as text even after I change the format?
An existing entry may still be stored as text. Set the cell to General, then edit and confirm the entry again with F2 and Enter, or retype the formula beginning with an equals sign. Check for a leading apostrophe or space as well.
Will pressing F9 fix every formula problem?
No. F9 recalculates formulas, but it cannot correct invalid syntax, a wrong range, a broken external link, or text stored where a number is required. If recalculation produces an error or the same unexpected result, inspect the formula and its inputs.
Why does my formula return zero when the cells contain numbers?
The apparent numbers may be stored as text, or the formula may refer to a different range than intended. Check the cell formats and formula references, and verify the inputs by selecting them. Imported data is a frequent source of numbers that look numeric but are not treated as numbers.
Related
- Excel Invoice Bill Format: Build a Useful Template
- Excel Accounting Solver: What It Does and How to Use It
- Excel Budget Spreadsheet Free? Find Templates and Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel SUBSTITUTE Function Not Working? Fixes That HelpIf Excel’s SUBSTITUTE function is not working, check that the text you want to replace matches exactly, that…
- XLOOKUP Exact Match Not Working? Fix Common CausesXLOOKUP uses exact matching by default, so a failed result usually means the lookup value and the values…
- Excel Not Working in QuickBooks Desktop? How to Fix ItIf Excel is not working in QuickBooks Desktop, first confirm that the desktop version of Excel is installed…
- Excel Merged Cells Not Wrapping Text? Fix the LayoutIf text in an Excel merged cell is not wrapping, select the merged cell and choose Home >…
- Excel Page Breaks for Printing: Set, Preview, and FixTo control where a printed worksheet splits, open View > Page Break Preview, then drag a blue page-break…
- How to Resolve a #REF! Error in ExcelTo resolve a #REF! error in Excel, find the formula containing the broken reference, then undo the deletion…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.