If an Excel formula is not calculating, first check Formulas > Calculation Options > Automatic, then make sure the cell is not formatted as Text and that Show Formulas is off. If those checks do not fix it, inspect the formula’s references, syntax, and any error message; each points to a different cause.
Start by identifying what Excel is showing
“Not calculating” can describe several different symptoms. A cell might display the formula itself, keep showing an old answer after its inputs change, show an error such as #VALUE!, or display a result that looks wrong. These are not the same problem. Noting exactly what appears in the cell—and what action should make it change—will narrow the diagnosis.
Also check whether the displayed value may simply be hard to see. A narrow column can show hash marks instead of a number or date; widen the column by double-clicking the boundary to the right of its heading. A number format can also round a stored decimal so it appears unchanged. Select the cell and look at the formula bar for the underlying value, then use Home > Increase Decimal if appropriate.
For a simple test, with 12 in A2, 8 in B2, and C2 as the result cell, enter =A2+B2 in C2. The expected result is 20. If Excel shows the characters of the formula instead, investigate text formatting or Show Formulas; if it returns 20 but does not respond to later edits, check calculation settings.
Check calculation mode first
Excel can calculate formulas automatically or wait until you request a calculation. In Microsoft 365 for Windows, select Formulas > Calculation Options > Automatic. If the workbook is set to Manual, a formula may retain its previous result after an input changes. Select Formulas > Calculate Now to recalculate open workbooks, or Formulas > Calculate Sheet to recalculate the active sheet.
Windows keyboard shortcuts can help confirm the issue: press F9 to calculate, or Shift+F9 to calculate the active worksheet. On some keyboards, F9 requires the Fn key. Excel for Mac has corresponding calculation commands on the Formulas tab; function-key behavior depends on the keyboard settings, so the ribbon command is a dependable option there. Excel for the web generally calculates automatically, but a workbook created or edited elsewhere can still have formula or compatibility issues.
Calculation mode can affect other workbooks open in the same Excel session, so changing it may alter how another open file updates. If a file is large, someone may have selected Manual to avoid delays while editing. Set it back to Automatic when appropriate, and verify that the workbook’s key results refresh.
When the formula appears as text
If a cell displays something like =A2+B2 instead of 20, first make sure Show Formulas is disabled. On Windows, Ctrl+` toggles formula display; the grave-accent key is usually near the top-left of the keyboard. You can also select Formulas > Show Formulas. This setting can make many cells show formulas at once, so if an entire worksheet looks that way, it may be the explanation.
If only one cell shows the formula, it may have been entered while the cell was formatted as Text, or it may begin with an apostrophe. Select the cell, choose Home > Number Format > General, then edit the entry and press Enter. Changing the format alone may not make Excel reinterpret existing text; editing and confirming the entry prompts Excel to parse it again. On Mac, the same general approach works, though the ribbon layout can vary with window size.
Also look for a leading space or apostrophe before the equals sign. Excel treats an entry intentionally prefixed with an apostrophe as text. If formulas throughout a sheet suddenly become visible, check the Show Formulas toggle before editing every cell individually.
Inspect syntax, separators, and references
A formula must begin with an equals sign and use valid function names, parentheses, operators, and cell references. A missing parenthesis or a misspelled function generally produces an error or a warning rather than a silent calculation. Click the cell and review the formula bar; Excel often highlights a reference while you edit. For a complex expression, temporarily simplify it or evaluate it in smaller pieces to find where the result diverges from expectations.
Argument separators can depend on regional settings. Many Excel installations use commas between function arguments, while some use semicolons because of the computer’s regional number format. If a formula copied from a web page is rejected, check the separator Excel expects in your installation instead of assuming the formula’s logic is wrong. The examples here use commas, as in the standard English-language syntax.
Check that each reference points to the intended cells. In a copied formula, relative references shift as the formula moves; absolute references marked with dollar signs stay fixed. For example, a copied formula may start using a blank cell or a different row than expected. Select the result cell and use Formulas > Trace Precedents to show cells feeding into it. Use Formulas > Evaluate Formula to step through a calculation, especially when the formula contains nested functions.
Understand error messages and circular references
An error is useful evidence: it means Excel attempted to evaluate something but could not produce the requested result. The cell may show #DIV/0! when a calculation divides by zero or a blank denominator, #NAME? when Excel does not recognize text in the formula, or #REF! when a referenced cell or range has been deleted. #VALUE! often indicates an unexpected type of input, such as text where a numeric value is needed. Check the cells feeding the result before changing the formula.
A circular reference occurs when a formula depends, directly or through a chain of cells, on its own result. For instance, a total cell included in the range it is meant to total can create a loop. Excel may warn about the circular reference or show a result that does not behave as expected. Use the warning or the circular-reference indicator in the status bar, then revise the range or dependency so the calculation flows in one direction. Iterative calculation is available for intentionally circular models, but it should not be enabled merely to hide an accidental loop.
Some newer functions are not supported by older Excel versions. A workbook opened in an older release may show an unsupported-function error or a prefixed function name. XLOOKUP, FILTER, and UNIQUE require Excel 2021 or Microsoft 365; functions such as TEXTSPLIT and VSTACK require Microsoft 365 or Excel 2024. If a file is shared with people using older software, check compatibility or use a function supported by their version.
Check data types, external links, and dynamic arrays
Numbers that look like numbers may actually be text, especially after importing a CSV file or copying data from a website. If a formula expects numeric inputs, text values can cause an error or an unexpected result. Look for left-aligned values, green error indicators, or an option to convert the value to a number. You can also inspect the cell’s format and compare the input with a value typed directly into a blank cell. Do not convert an entire column blindly if it contains codes, postal codes, or identifiers where leading zeros matter.
Formulas linked to another workbook may depend on that workbook being available or on links being updated. If a result seems stale, check Data > Workbook Links when that command is available, and confirm the source file has not moved or been renamed. External data connections and queries are different from ordinary cell formulas: their results may require a refresh through Data > Refresh All. Refreshing data does not repair a broken formula, so identify which kind of source the result uses.
Dynamic-array formulas can return results into neighboring cells. If cells in the intended output area are occupied, Excel may display #SPILL! and leave the result incomplete. Clear or move the blocking content, and inspect merged cells or the edge of an Excel table if the spill range is unexpected. FILTER and UNIQUE are available in Microsoft 365 and Excel 2021; version support matters when a workbook is opened on another computer.
A practical troubleshooting sequence
Work through the checks in this order, changing one thing at a time. That makes it easier to identify the cause and avoid altering a formula that was already correct.
- Record the symptom. Is the formula displayed, is the result stale, is there an error, or is the answer simply unexpected?
- Check automatic calculation. Choose Formulas > Calculation Options > Automatic, then use Calculate Now if needed.
- Check display and format. Turn off Show Formulas and, if one cell displays its formula, change Text to General and re-enter the formula.
- Inspect the formula and inputs. Confirm the equals sign, parentheses, separators, cell references, and data types. Use Evaluate Formula or Trace Precedents for complicated dependencies.
- Resolve the specific error. Check for a circular reference, blocked spill range, deleted reference, unsupported function, or unavailable external source.
- Save and reopen a copy if necessary. If only one workbook behaves strangely, test a separate copy before making broad repairs or changing many formulas.
For a workbook with thousands of formulas, avoid repeatedly forcing a full recalculation while diagnosing a small issue; it can make the file feel slow without explaining the cause. Conversely, if a formula depends on many other cells, recalculating just one sheet may not be enough to refresh all dependencies. The right calculation command depends on how the workbook is structured.
Frequently Asked Questions
Why does Excel show the formula instead of the answer?
Show Formulas may be on, or the cell may be stored as text. Turn off Formulas > Show Formulas; for one affected cell, set its format to General, edit the entry, and press Enter.
How do I force Excel to recalculate?
On Windows, press F9 to calculate or Shift+F9 for the active sheet; use Fn with the key if your keyboard requires it. You can also select Formulas > Calculate Now. On Mac, use the Formulas-tab calculation command if the function key does not work as expected.
Why does my formula update only after I press Enter?
The workbook may be using Manual calculation, or the input may have been stored as text. Set calculation to Automatic first. If only the formula cell is affected, check its number format and re-enter the formula.
Why is Excel returning zero when the formula looks correct?
Check whether referenced cells are genuinely numeric, whether the formula points to the intended range, and whether the cell’s number format is hiding decimals. A displayed zero can also be the correct result if the referenced cells are blank or contain zero.
Will changing a cell to General fix every formula problem?
No. General can help when a formula was entered as text, but it will not fix Manual calculation, an invalid reference, a circular reference, or an unsupported function. After changing the format, edit and confirm the formula so Excel reinterprets it.
Why does a formula work on one computer but not another?
The computers may use different Excel versions, regional separators, calculation settings, or access to linked workbooks. Check those differences before replacing the formula; a newer function may not be available in an older version.
Related
- Excel Protect Sheet: Allow Editing in Selected Cells
- Excel Heat Maps: How to Create, Format, and Read Them
- Excel Group Rows: How to Collapse and Expand Data
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Freeze Panes Wrong Selection? How to Fix ItIf Excel freezes the wrong rows or columns, first choose View > Freeze Panes > Unfreeze Panes, then…
- Analysis ToolPak Not Showing in Excel? Fix ItIf the Excel Analysis ToolPak or its Data Analysis button is missing, enable the add-in in desktop Excel:…
- Excel Box and Whisker Plot Not Working? Fixes to TryIf an Excel box-and-whisker plot is missing, blank, or arranged incorrectly, first check that you are using a…
- Excel Won’t Filter by Dates? Fix the Data and SortIf Excel won’t filter by dates, the most common cause is that some or all of the entries…
- Excel Find Names Missing From a List With FormulasTo find names in one Excel list that are absent from another, put the first list in A2:A100…
- Excel IFERROR Not Working? Fix Common Formula ProblemsExcel IFERROR usually seems not to work because its first argument is not producing an Excel error, the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.