Excel Function Not Showing Result? Fix the Formula

Errors & fixes · Updated November 18, 2026

If an Excel function is not showing a result, first check whether Excel is displaying formulas, treating the entry as text, or set to manual calculation. In Microsoft Excel for Microsoft 365 on Windows, use the checks below to identify the cause and make the result appear; the same ribbon options are generally available on Mac, although some keyboard shortcuts differ.

Start with the quickest checks

Look at the cell and the formula bar. If the cell displays something beginning with an equals sign, such as =SUM(B2:B4), Excel may be showing the formula itself rather than calculating it. If the cell is empty, the formula may intentionally return a blank, refer to empty cells, or be hidden by formatting. If it displays an error such as #VALUE!, the function is calculating but cannot produce the intended result from its inputs.

Try these checks in order, since the first few often resolve the issue without changing the formula:

  1. On the Formulas tab, turn off Show Formulas if it is selected.
  2. Set calculation to Automatic through Formulas > Calculation Options > Automatic.
  3. Check that the cell is not formatted as Text, and re-enter the formula if necessary.
  4. Inspect the formula’s references and inputs, then look for error messages or display formatting that could conceal the result.

Before editing a complicated formula, select its cell and read the formula bar. That lets you distinguish an actual formula from a value that only looks like one, and helps avoid replacing working logic while troubleshooting.

When Excel displays the formula instead of its answer

If many cells show expressions instead of results, the workbook may be in Show Formulas mode. Choose Formulas > Show Formulas to switch back to normal results. The setting affects how formulas appear on the worksheet; it does not replace them with text or remove their calculations. Column widths can change when formulas are displayed, so the sheet may look different after you switch modes.

On Windows, Ctrl+` (the grave-accent key, often near the number 1 key) toggles Show Formulas. Keyboard layouts can place that character in different locations, and Mac shortcut behavior can vary by keyboard and Excel settings. Using Formulas > Show Formulas is the clearest method across platforms.

If only one cell shows its formula, Show Formulas is less likely to be the cause. Check whether that cell is formatted as Text, or whether an apostrophe was entered before the equals sign. An apostrophe is used to store an entry as text and is not normally displayed in the cell. Click the cell and inspect the formula bar for an entry that begins with an apostrophe or a formula stored as plain text.

Check whether the cell is formatted as Text

Excel treats a formula entered into a Text-formatted cell as text instead of evaluating it. This commonly happens when a cell or an entire imported column was formatted as Text before someone typed or pasted formulas. Changing the format alone may not convert an existing text entry into a working formula; the formula often needs to be re-entered.

  1. Select the affected cell or range.
  2. On the Home tab, open the Number Format dropdown and choose General.
  3. Click the formula cell, press F2, and then press Enter. This re-commits the entry so Excel can interpret it as a formula.

On a Mac, use the same Home tab number-format control. If the keyboard does not have a dedicated F2 key, use the applicable function-key combination for your Mac or edit the cell in the formula bar and confirm the entry. A leading space before the equals sign can also prevent Excel from recognizing an entry as a formula, so remove unintended spaces or apostrophes.

For example, with values in B2:B4, enter =SUM(B2:B4) in B5. If B2, B3, and B4 contain 10, 20, and 30, the result should be 60. If B5 was Text-formatted when the expression was entered, it may show the characters of the formula instead. After changing the format to General, re-enter the formula.

Make sure calculation is set to Automatic

Excel can be configured to calculate formulas manually. In that mode, changing an input may leave a formula’s previous value on screen until the workbook is recalculated. Open Formulas > Calculation Options and select Automatic. This setting is especially worth checking if several formulas stopped updating after a workbook was opened or edited.

When Automatic is already selected, use Formulas > Calculate Now to request a recalculation. On Windows, F9 recalculates open workbooks, while Ctrl+Alt+F9 forces a full recalculation of formulas. Function keys on Mac keyboards may control system features by default, so use the Formulas tab if a shortcut does not work. Avoid changing calculation mode casually in a shared workbook: the mode can affect other open workbooks in the same Excel session.

Manual calculation does not usually make a formula disappear; it can make the displayed value stale. A simple test is to change an input cell and see whether a dependent result updates. If pressing Calculate Now changes the result, calculation mode or recalculation timing was likely involved. If it does not, investigate the formula, references, and display format instead.

Inspect the formula and its cell references

A formula may be valid but refer to the wrong cells, an empty range, or data that does not meet its conditions. Select the formula cell and read its references carefully. Excel highlights referenced cells while you edit a formula, which can reveal that the range stops one row too early or points to another worksheet. A copied formula can also shift its references: relative references adjust when copied, while dollar signs make a row or column absolute.

For a basic arithmetic check, with a price in A2 and a quantity in B2, enter =A2*B2 in C2. If A2 is 12 and B2 is 3, C2 should return 36. If it does not, check whether the inputs are numbers rather than text, whether either cell contains an unexpected value, and whether C2 is displaying a result in a misleading number format.

Functions with conditions may return an unexpected but legitimate result. For example, with a test value in A2 and a calculation in B2, =IF(A2=0,0,A2*B2) in C2 returns zero whenever A2 is zero; it does not multiply B2 in that case. A formula may also be designed to return an empty-looking result when a condition is not met. In such cases, inspect the function’s logical test and inputs rather than assuming that a blank cell means Excel failed to calculate.

For a long formula, use the formula bar to review the expression and check parentheses, commas, operators, and sheet names. Excel’s Insert Function controls can help build a function, but they cannot determine whether the chosen calculation matches your intent. Compare the formula with a small hand-calculated example to isolate whether the problem is syntax, references, or logic.

Understand errors and missing inputs

An error value is evidence that Excel evaluated the formula but encountered a problem. The exact error often points toward the next check:

  • #NAME? can mean a function name or named range is not recognized, or text in a formula is not correctly enclosed in quotation marks.
  • #VALUE! commonly indicates an unexpected value type, such as text where a calculation expects a number.
  • #REF! indicates an invalid cell reference, often because a referenced row, column, or sheet was deleted.
  • #DIV/0! means a calculation attempted to divide by zero or by a blank denominator.
  • #N/A often means a lookup did not find a matching item, though the intended cause depends on the formula.

Do not hide an error before understanding it. For a lookup, check that the search value exists and that extra spaces or mismatched data types are not preventing a match. For a division, inspect the denominator. If a formula uses a function that is unavailable in the installed Excel version, Excel may not recognize it; XLOOKUP, for example, requires Excel 2021 or Microsoft 365. A workbook opened in an older edition may therefore behave differently.

Check number formats and other display settings

Sometimes Excel has calculated a value, but the cell’s format makes it look blank or incorrect. A custom number format can suppress displayed zeros, and white font on a white background can make text hard to see. Select the cell and check the Home tab’s Number Format, font color, and fill color. Temporarily choosing General is a useful diagnostic; then restore an appropriate format such as Number, Currency, or Percentage.

Also check the column width. A narrow column can show number signs for some numeric formats or cut off visible text, making a result seem missing. Widen the column by dragging its right boundary or double-clicking the boundary between its heading and the next column to AutoFit. If the formula returns a very small decimal but the cell is formatted to show no decimal places, the displayed value may round to zero even though the stored value is not zero.

To check whether a zero is being hidden, select the cell and look at the formula bar, then try General format. If a nonzero value appears after changing the format, the calculation was working and the issue was presentation. A workbook-level setting can also affect whether zero values appear on a worksheet; check Excel Options > Advanced and the display options for that worksheet if zeros are missing across many cells.

Investigate spilled results and version differences

Some modern formulas return multiple results that spill into neighboring cells. If an output area is blocked by existing content, Excel may show #SPILL! rather than filling the range. Clear the obstructing cells, check for merged cells in the spill area, and make sure the formula is not inside an Excel table where a spilled array is not supported in the expected way. The formula cell may be correct even when the surrounding worksheet prevents the full result from appearing.

Functions such as XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE, and LET require Excel 2021 or Microsoft 365. If a workbook is opened in an older Excel version, a function may produce an unsupported-function error instead of the expected result. LAMBDA, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, and HSTACK require Microsoft 365 or Excel 2024. Excel for the web and Mac have their own release and update availability, so check the version and update channel when a formula works for one person but not another.

When sharing a workbook, find out which Excel edition the recipient uses and whether they opened it in Excel, a browser, or another spreadsheet app. Compatibility can affect newer functions, dynamic arrays, and display behavior. Avoid replacing a newer function with a complicated workaround until you know the recipient’s version and what result the workbook needs to preserve.

A practical troubleshooting order

Use a controlled process rather than rewriting the formula immediately. Start by selecting the cell and checking the formula bar, then test whether the problem affects one cell or a whole worksheet. A whole-sheet pattern suggests a display or calculation setting; a single-cell problem more often points to text format, a stray character, a reference, or formula logic.

  • Confirm the entry begins with an equals sign and is not stored as text.
  • Turn off Show Formulas and check calculation mode.
  • Recalculate, then inspect any displayed error.
  • Check input values, referenced ranges, and copied relative references.
  • Temporarily use General format and widen the column to rule out display issues.
  • Check for a blocked spill range or an unsupported function if the formula is recent.

If the workbook contains important work, save a copy before making broad changes such as replacing formulas, changing many formats, or editing calculation settings. In a shared workbook, record the original setting and communicate changes so another user is not surprised by altered calculation behavior.

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 format from Text to General, then edit and re-enter the formula. Also remove any unintended leading apostrophe or space.

Why does my Excel formula stay blank?
The formula may deliberately return an empty result when a condition is not met, or it may refer to blank cells. Check the formula bar, its logical tests, and its inputs. Also check whether a custom format is hiding zero values.

How do I force Excel to update a formula?
Select Formulas > Calculate Now, and set Formulas > Calculation Options to Automatic if you want formulas to recalculate as inputs change. On Windows, F9 recalculates open workbooks; Mac function-key behavior can depend on keyboard settings.

Why does Excel show zero instead of the expected result?
Check the formula’s references and conditions first. Then inspect number formatting and decimal places: a small value may be rounded to zero on screen, or a custom format may suppress zeros. General format can help distinguish the stored value from its presentation.

Why does a formula work on one computer but not another?
The computers may use different Excel versions, update channels, calculation settings, or regional list separators. Newer functions require supported editions, and localized settings can affect how formulas are entered. Check the function’s availability and the receiving workbook’s environment.

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.