Excel Error Symbols: What They Mean and How to Fix Them

Excel’s error symbols are values such as #VALUE! and #DIV/0! that explain why a formula cannot return a normal result; the green triangle in a cell is a separate warning indicator, not an error value itself. Read the displayed error to narrow down the cause, then inspect the formula, its references, and the data it uses.

Error values and warning indicators are different

People often call both the text in a cell and a small colored corner an “Excel error symbol,” but they mean different things. An error value appears in the cell where a formula’s result would normally appear. It usually starts with a number sign and identifies a problem with the calculation, a reference, or a connected data source.

A green triangle in the upper-left corner is Excel’s background error-checking indicator. It flags something Excel thinks may be wrong, such as a formula that differs from nearby formulas or a number stored as text. The cell might still display a normal value, and the warning can sometimes be harmless. Conversely, a cell can show an error value without having a green triangle.

When a warning is available, selecting the cell may reveal a warning icon with suggested actions. That menu helps explain the specific warning; it does not mean every suggestion is right for your workbook. Check the formula and intended data before choosing an action such as correcting a formula or ignoring the warning.

What the green triangle usually means

The triangle is produced by Excel’s error-checking rules, which look for patterns that might indicate a mistake. For example, a formula in one row might add two cells while the formulas above and below add three. Excel flags the difference because it could be an accidental omission. But the formula may be intentionally different, such as a subtotal at the end of a section.

Other common reasons for a green triangle include a number entered as text, a formula that refers to cells in a way that differs from neighboring formulas, or a formula that omits cells in a nearby range. The exact warning depends on the cell and the enabled error-checking rules. A green triangle does not diagnose the problem conclusively; it points to something worth reviewing.

To investigate in Excel for Microsoft 365 on Windows, select the flagged cell and read the message available from its warning icon. For formula-specific checks, use Formulas > Formula Auditing > Error Checking. Excel may offer actions for the current issue, but review their effect before applying one. In Excel for the web, error indicators and available commands can differ; open the workbook in the desktop app if you need the full desktop error-checking controls.

Common Excel error values and their meanings

Different error values point toward different kinds of problems. These are the ones many spreadsheet users encounter:

#DIV/0! means a formula divides by zero or by a blank cell. If a quantity cell is empty, for instance, a calculation that divides sales by that quantity cannot produce a valid result.
#VALUE! usually means a formula received a value of the wrong type. A calculation expecting a number may fail if a referenced cell contains text that Excel cannot use as a number.
#NAME? means Excel does not recognize text in the formula. A misspelled function name, an undefined name, or text that should have been enclosed in quotation marks can cause it.
#N/A means a value is not available. It commonly appears when a lookup cannot find a requested match, and it can also be deliberately used to mark unavailable data.
#REF! means a formula contains an invalid cell reference. Deleting a row, column, or cell that a formula relied on can leave this error behind.
#NUM! signals a numerical problem, such as a calculation that cannot produce a valid number or a function given a number outside its supported range.
#NULL! often indicates an unintended use of the range-intersection operator, which is a space in a formula. It can occur when the referenced ranges do not intersect.
#SPILL! appears when a dynamic-array formula cannot place its results because something blocks the cells where those results need to go.
#CALC! is a calculation error used for certain problems Excel cannot otherwise classify, including some situations involving dynamic arrays.

Excel can also show errors associated with features such as linked data types or external connections. For example, #FIELD! can indicate a missing field in a linked data type, while connection-related errors can point to unavailable data or a service that has not finished responding. These messages depend on the feature in use and may not appear in every workbook or Excel version.

How to trace an error to its source

Start with the cell displaying the error, but do not assume that cell is where the original mistake happened. A formula can pass an error from one cell to another. If a total depends on a calculation that already returns #VALUE!, the total may display that same error because its input is faulty.

Select the error cell and inspect the formula in the formula bar. Look for misspelled names, missing operators, incorrect quotation marks, or references to unexpected cells.
Follow the referenced cells and check their contents. Look for blanks, text in numeric data, errors in earlier calculations, and values that do not match the formula’s assumptions.
Use Formulas > Formula Auditing > Error Checking to review an issue, or use the formula-auditing tools to trace precedents and dependents where available.
Compare the formula with similar cells nearby. A single formula that differs from a consistent column pattern may reveal a copied formula with a shifted or missing reference.
Check whether the problem is a genuine calculation issue or a temporary data issue, especially if the formula depends on a linked data type, external workbook, or connected service.

For example, with revenue in B2 and quantity in C2, =B2/C2 returns #DIV/0! if C2 is zero or blank. The formula may be syntactically valid; the issue is that the denominator does not contain a usable nonzero quantity. If zero is a legitimate quantity, decide what the report should show in that case rather than hiding the error automatically.

Fix the cause rather than just the display

The right correction depends on what the spreadsheet is meant to calculate. For #DIV/0!, confirm whether the divisor should contain a value, whether zero is valid, and what result is appropriate when there is no quantity. For #REF!, restore or replace the broken reference. For #NAME?, check spelling and whether a named range or function is available in the Excel version being used.

For #N/A in a lookup, check that the lookup value exists, that the lookup and return ranges are appropriate, and that the values use compatible formats. A number stored as text may look identical to a number but fail to match it. Also confirm whether the lookup is supposed to require an exact match; changing match behavior can produce a result without making it the correct result.

For #SPILL!, inspect the cells where the formula’s results need to appear. Clear unintended contents or merged cells from the spill area, and check that the result is not being placed inside an Excel table where dynamic-array spilling is restricted. Do not delete surrounding data until you know it is safe to do so.

When you correct a source cell, Excel will generally recalculate formulas that depend on it. If the error remains, check whether calculation is set to automatic under Formulas > Calculation Options, and recalculate as appropriate. A workbook can also contain multiple independent errors, so fixing one may reveal another further along the calculation chain.

When it is reasonable to ignore an error-checking warning

A green-triangle warning is not always a defect. A column of product codes may contain digits stored as text on purpose, or a subtotal formula may intentionally differ from the formulas above it. If you have checked the cell and the difference is intentional, you can use the warning icon’s available option to ignore that warning for the cell. You can also adjust error-checking rules through File > Options > Formulas in Excel for Windows.

Ignoring a warning is different from replacing an error value with a blank or a zero. An error value means a formula has not returned an ordinary result; hiding it changes what readers see but does not necessarily correct the underlying calculation. If a report needs a particular fallback, define that behavior deliberately and make sure users can distinguish “no result” from a real zero.

Disabling a broad error-checking rule may reduce distracting warnings, but it can also make genuine problems easier to miss. If only one cell is an intentional exception, handling that warning locally is usually clearer than turning off a rule for the whole workbook.

Prevent recurring formula errors

Consistent spreadsheet structure makes mistakes easier to spot. Keep similar calculations in the same columns, use clear headers, and avoid mixing numbers and text in a field that is intended for numeric calculations. When copying formulas, inspect the first few results and check that cell references moved as intended.

Validate inputs where practical, especially fields used as divisors, dates, or lookup keys.
Use consistent data formats, and check whether imported numbers have arrived as text.
Keep source data separate from calculations so that formulas are less likely to be overwritten.
Review unusual results and error indicators before sharing a workbook, particularly after deleting or rearranging rows and columns.
Document intentional exceptions, such as a different subtotal formula, so another person does not mistake them for accidental inconsistencies.

These habits do not prevent every error. They do make it easier to distinguish an expected edge case from a broken formula and reduce the chance that one bad input quietly affects many downstream results.

Frequently Asked Questions

What does the green triangle in an Excel cell mean?
The green triangle is an error-checking indicator. It means Excel has spotted a pattern it thinks might be wrong, such as a number stored as text or a formula that differs from nearby formulas. It is a warning to review, not proof that the cell is incorrect.

Is the # symbol itself an Excel error?
No. Excel displays a number sign as part of many error values, such as #REF! and #VALUE!. The sign alone does not identify the problem; the letters that follow it do.

Why does my Excel formula show #N/A?
#N/A means the requested value is unavailable. In a lookup, the value may not be present, or its format may not match the lookup data. It can also be an intentional marker for missing information.

Can I remove an Excel error symbol without fixing the formula?
You can sometimes hide or replace an error display, but doing so does not necessarily repair the calculation. First decide what the formula should return in that situation; then use an appropriate formula or reporting method so that missing, invalid, and zero results are not confused.

Why is there a green triangle if the cell’s result looks correct?
The result may be correct even though it differs from a pattern Excel expects. For example, a deliberately different subtotal formula or a code stored as text can trigger a warning. Verify the cell’s purpose and formula before ignoring the alert.

Do Excel error symbols mean the workbook is damaged?
Usually not. Most error values point to a formula, input, reference, or data-connection issue rather than a damaged workbook file. Trace the affected calculation and check its inputs; if the workbook itself will not open or behaves abnormally, that is a separate problem from an ordinary cell error.

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.