What every Excel error means, why it happens, and how to fix it. Don't want to debug? Let AI fix the formula.
#N/A
A lookup couldn't find a match — the value is "not available".
#REF!
A formula refers to a cell that no longer exists.
#DIV/0!
A formula is dividing by zero or an empty cell.
#VALUE!
A formula has the wrong type of argument — often text where a number is expected.
#NAME?
Excel doesn't recognize text in the formula — usually a typo in a function or name.
#NUM!
A formula produced an invalid or too-large number.
#NULL!
Two ranges that don't intersect were combined with a space.
#SPILL!
A dynamic array can't spill because something blocks its output range.
Circular Reference
A formula refers back to its own cell, directly or indirectly.
#CALC!
A dynamic array formula hit a calculation it can't complete.
#####
The column is too narrow to display the value (or a negative date/time).
Formula shows as text
Excel displays the formula text instead of calculating it.
#GETTING_DATA
Excel is still calculating or fetching data for the cell.
#BLOCKED!
A linked data type or dynamic feature is blocked from returning a value.
#FIELD!
A linked data type doesn't have the field you asked for.
#PYTHON!
Python in Excel couldn't run or return a result.
#UNKNOWN!
A newer function isn't recognized by your version of Excel.