Excel Formula Errors Explained — Every Error Code and How to Fix It

Excel errors are confusing because they're cryptic by design — they tell you what went wrong in the formula engine, not in plain English. Here's every error code decoded, with the exact formula to fix each one.

#DIV/0! — Division by Zero

Meaning: You're dividing by zero or by an empty cell.

Common causes: =A2/B2 when B2 is empty or 0.

#N/A — Value Not Available

Meaning: A lookup formula couldn't find what it was looking for.

Common causes: VLOOKUP value not in the table, MATCH finding no match.

Check for extra spaces using TRIM, or mismatched data types (text "123" vs number 123).

#NAME? — Unrecognized Formula Name

Meaning: Excel doesn't recognize the function name. Usually a typo.

Common causes: =VLOOKP instead of =VLOOKUP, or using a function not available in your Excel version.

#REF! — Invalid Cell Reference

Meaning: The formula is referring to a cell that doesn't exist (deleted row/column) or is out of bounds.

Common causes: Deleting rows or columns that a formula referenced, or a col_index_num in VLOOKUP exceeding the table width.

#VALUE! — Wrong Data Type

Meaning: You're trying to do math on text, or providing the wrong type of argument.

Common causes: =A2+B2 where one cell contains text like "five" instead of the number 5.

#NULL! — Invalid Intersection

Meaning: You used a space between two ranges that don't intersect, where you probably meant to use a comma or colon.

#NUM! — Invalid Numeric Value

Meaning: A formula contains an invalid numeric operation — usually a result too large for Excel, or an impossible calculation.

The Universal Error Fix

When you're not sure which specific error you'll get, wrap everything in IFERROR:

Prevent Errors Before They Happen

• Always wrap VLOOKUP with IFERROR
• Use TRIM() on imported data before lookups
• Use IF(denominator=0, 0, numerator/denominator) for division
• Lock table arrays with $ when copying formulas
• Use VALUE() to convert text numbers to real numbers