Help With Excel Errors: Find and Fix Common Problems

Errors & fixes · Updated November 20, 2026

To get help with an Excel error, read the error code, check the formula and its referenced cells, then fix the underlying issue rather than hiding the warning. In Microsoft Excel for Microsoft 365 on Windows, start with Formulas > Error Checking or select the affected cell and inspect the formula bar; the steps below explain what common errors mean and how to resolve them safely.

Start with the cell and its formula

An error usually appears in a cell because Excel cannot calculate the formula as written, cannot find a requested value, or has lost a reference. Click the cell and look at the formula bar to see the full formula; the grid may show only part of it. Then inspect each referenced cell, including cells on other sheets, for unexpected blanks, text, changed values, or errors of their own. A formula that displays an error can be downstream of the cell where the original problem began.

Excel may also show a small green triangle in a cell. That indicator flags a possible issue, such as a number stored as text, but it does not necessarily mean the calculation is wrong. Select the cell to see the warning icon and available options. Do not choose an option just to make the warning disappear: first determine whether the value is meant to be text or a number.

For a guided check, select the formula cell and use Formulas > Error Checking. The dialog can identify the error type and let you step through parts of a formula. Formulas > Evaluate Formula can also show how Excel evaluates a formula one part at a time. These tools help locate a fault, but you still need to decide what result the worksheet should produce.

What common Excel error codes mean

Error codes are clues, not complete diagnoses. The same code can have different causes depending on the formula and the data. These are some of the errors you are most likely to encounter:

  • #DIV/0! means a formula divides by zero or by a blank cell treated as zero. Check the denominator and decide whether a missing value should produce a blank, a message, or a calculation.
  • #N/A commonly means a lookup formula cannot find a match. Check for missing records, extra spaces, different data types, or an incorrect lookup range.
  • #VALUE! means a formula received a value of an unexpected type, such as text where it needs a number or date. Inspect the cells used in the calculation.
  • #REF! means a formula refers to a cell or range that is no longer valid, often because a referenced row, column, or sheet was deleted.
  • #NAME? usually means Excel does not recognize text in a formula. A misspelled function name or a text value without quotation marks can cause it.
  • #NUM! indicates a problem with a numeric value or calculation, such as a function being given an out-of-range number.
  • #NULL! can occur when a formula uses a space between ranges where Excel interprets that space as an intersection, but the ranges do not overlap.
  • #SPILL! appears when a dynamic-array formula cannot place its results because cells in the output area are occupied or otherwise obstructed.

Newer Excel functions may also return #CALC! in certain situations, and a circular-reference warning can appear when a formula directly or indirectly depends on its own result. A display of #### is usually different: the value may not fit in the column, or a date or time calculation may produce a negative value that the cell format cannot display. Widen the column and check the underlying value before treating hashes as an error code.

Use a consistent troubleshooting sequence

A short, repeatable process is often faster than rewriting a formula at random. Work from the visible symptom toward the source:

  1. Confirm what the cell is supposed to show. A blank, a warning, a number, or a missing-match message may each be appropriate in different situations.
  2. Read the whole formula. Check function names, parentheses, commas, quotation marks, sheet names, and cell references. Excel formulas generally use commas between arguments in the standard Microsoft 365 Windows setup; regional settings can affect separators.
  3. Check the inputs. Look for blank cells, text stored as numbers, dates entered as text, leading or trailing spaces, and errors in upstream cells.
  4. Trace references. Select the formula and use Formulas > Trace Precedents to show cells feeding into it. Use Trace Dependents to see which formulas rely on the selected cell. Remove arrows with Formulas > Remove Arrows when finished.
  5. Test a small part. Evaluate Formula can help reveal which calculation step first produces an unexpected value. In a complex formula, temporarily checking a component in an unused cell can also clarify what that component returns.
  6. Recalculate and verify. Confirm that the corrected result makes sense against the source data and other calculations, rather than assuming that the disappearance of an error proves the answer is right.

Be cautious when editing a formula copied across many rows. Relative references move as a formula is filled, while references containing dollar signs are fixed in the specified row or column. An incorrect reference can produce plausible-looking results as well as visible errors, so compare a few rows with hand-checked examples.

Fix calculation and input errors

For #DIV/0!, check whether a denominator is zero or empty and whether that situation should be allowed. For example, with revenue in A2 and units sold in B2, if B2 is zero, the formula below returns the message shown rather than an error:

With revenue in A2 and units sold in B2, enter =IFERROR(A2/B2,"Check denominator"). If A2 contains 100 and B2 contains 0, the result is Check denominator.

IFERROR is convenient, but it catches many kinds of errors, not just division by zero. If the denominator alone is the issue, a targeted test can make the intended behavior clearer. With revenue in A2 and units in B2, enter =IF(B2=0,"",A2/B2). If B2 is zero, the result is a blank-looking cell; if A2 is 100 and B2 is 4, the result is 25. Choose the blank only if it is appropriate for reports and later calculations. A message such as “No units” may be more informative to a reader.

To investigate #VALUE!, check whether values that look numeric are actually numbers. With a suspected value in A2, enter =ISNUMBER(A2). If A2 contains the text value 12 rather than the numeric value 12, the result is FALSE. Correcting the source data is often preferable to adding conversion steps to every formula. If the data is imported, review the import process and the cell’s number format; changing a format alone does not always convert text into a number.

For #NAME?, verify spelling and syntax. Text criteria in formulas generally need straight double quotation marks, while cell references and defined names should match their actual spelling. If a workbook uses a function unavailable in the installed Excel version, Excel may not recognize it. Microsoft 365 includes newer functions such as XLOOKUP, FILTER, UNIQUE, and LET; availability can differ in older perpetual versions and other spreadsheet applications.

Resolve lookup and reference problems

A lookup returning #N/A does not always mean the record is absent. Compare the lookup value with the source values: one may be stored as a number and the other as text, or contain an extra space or different punctuation. Also check that the formula searches the intended column and that the return range has the corresponding rows. When a lookup is meant to find an exact identifier, do not assume that a nearby or partial match is acceptable.

For an exact lookup with Microsoft 365, suppose product IDs are in A2:A4, product names are in B2:B4, and the ID to search for is in E2. Enter =XLOOKUP(E2,A2:A4,B2:B4,"Not found"). If A2:A4 contains P-10, P-11, and P-12, B2:B4 contains Mug, Notebook, and Pen, and E2 contains P-11, the result is Notebook. If E2 contains P-99, the result is Not found. The optional message helps distinguish an expected missing match from other formula errors.

A #REF! error calls for checking the reference itself. If someone deleted a referenced column or sheet, the formula may no longer point to valid cells. Undo may restore a recent deletion if it has not been followed by other changes, but avoid replacing every #REF! with a guessed address. Review the intended source and repair the formula based on the workbook’s layout. When copying formulas, check whether a reference should move or remain fixed.

If a formula returns #SPILL!, inspect the cells where its results would appear. A value, another formula, merged cells, or other obstruction in the output area can prevent the results from spilling. Clear or move the obstruction only if doing so will not delete needed information. Dynamic-array formulas such as FILTER and UNIQUE require Microsoft 365 or a supported newer Excel version; workbooks opened in older versions may not behave the same way.

Check formatting, calculation settings, and workbook links

Not every surprising display is a formula error. If you see ####, widen the column by dragging its boundary or choose Home > Format > AutoFit Column Width. If a result shows too many or too few decimal places, adjust the number format from the Home tab; changing the displayed format does not change the stored value. A date that appears as a serial number may simply have the General or Number format rather than a date format.

If formulas seem not to update after inputs change, check Formulas > Calculation Options > Automatic. A workbook set to Manual calculation may not recalculate in the way you expect. Switching to Automatic can trigger recalculation across the workbook, so save first if the file is large or contains extensive calculations. Excel for Mac has a Formulas tab and calculation options too, although the ribbon layout and menu placement can vary. Excel for the web has a different interface, and some desktop features are unavailable there.

Workbooks linked to other files may display warnings or values that have not been refreshed from the source. Check whether the source workbook is available and whether the link points to the intended file before updating links. Do not enable content or trust an unfamiliar workbook merely to clear a warning. Files from unknown sources can contain unsafe macros or other active content; use your organization’s security guidance and verify the sender and file before enabling anything.

Prevent recurring errors

Prevention starts with consistent data and formulas. Use clear headers, keep one kind of value in each column, and avoid mixing numbers, explanatory text, and blanks in a field that formulas expect to calculate. For repeated calculations, enter and verify a formula in a sample row before filling it down. Excel tables can help keep structured data and formulas aligned as rows are added, but they do not make incorrect source data correct.

  • Use data validation when users should select from a defined list or enter values within a permitted range.
  • Keep a small test case with a known answer so that changes to a formula can be checked quickly.
  • Use meaningful names for sheets and ranges, and avoid deleting source rows or columns without checking dependent formulas.
  • Document what a blank or missing result means; a blank can otherwise be mistaken for zero or a completed calculation.
  • Save a separate copy before making broad edits to formulas, importing data, or changing workbook links.

Use error-handling functions intentionally. IFERROR can make a report easier to read, but a broad wrapper may conceal a misspelled reference, a broken lookup, or an unexpected text value. If the error represents a genuine data problem, displaying a clear message can make the workbook more reliable than silently substituting zero or an empty string. A result that looks tidy is not necessarily a correct result.

Frequently Asked Questions

Why does Excel show #VALUE! in a formula?

Excel often shows #VALUE! when a formula gets text or another unexpected type where it needs a number, date, or compatible value. Inspect the formula’s inputs and check whether numeric-looking entries are stored as text. Fix the source value where possible instead of masking the error.

How do I remove #N/A from an Excel lookup?

First confirm that the lookup value exists in the search range and that both sides use the same data type and spelling. Check for extra spaces and whether the lookup and return ranges cover the intended rows. You can provide a deliberate not-found message with a supported lookup function, but that does not fix an incorrect lookup range.

What does #### mean in Excel?

It usually means the column is too narrow to display the formatted value. Widen the column or use AutoFit Column Width. If the cell contains a date or time formula, also check for a negative date or time result, which some formats cannot display as expected.

Should I wrap every formula in IFERROR?

No. IFERROR can be useful when you have decided what should happen for an error, but it catches many error types and can hide problems that need attention. Handle expected cases specifically and preserve a clear warning when unexpected data or a broken reference should be investigated.

Why is my Excel formula not recalculating?

Check whether calculation is set to Automatic under Formulas > Calculation Options. Also verify that the input cells changed as expected and that the formula references those cells. If you use Excel for the web or a different version, available controls and newer formula support may differ from Microsoft 365 for Windows.

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.