Excel Error Reference
Plain-English explanations of every Excel and Google Sheets error, with causes and fixes.
#VALUE!VALUE ErrorOccurs when a formula has the wrong type of argument — for example, using text where a number is expected.
4 fixes →
#REF!REF ErrorOccurs when a formula references a cell or range that no longer exists, has been deleted, or is invalid.
4 fixes →
#N/AN/A ErrorStands for "Not Available." Occurs when a lookup formula cannot find the value it's searching for.
4 fixes →
#DIV/0!DIV/0 ErrorOccurs when a formula tries to divide a number by zero or by an empty cell.
3 fixes →
#NAME?NAME ErrorOccurs when Excel/Sheets doesn't recognize text in a formula — usually a misspelled function name or an undefined named range.
4 fixes →
#NUM!NUM ErrorOccurs when a formula has an invalid numeric value — such as a number too large, or a math operation that's impossible.
3 fixes →
Have a specific error to debug?
Paste your formula into our AI error explainer for a diagnosis tailored to your specific formula.
Open Error Explainer →