Excel Error Messages Explained: #N/A, #REF!, #VALUE! and More

Last updated: November 2026 · Works in Excel for Microsoft 365, Excel 2021, Excel 2019 and Excel 2016

An error value in a cell is Excel telling you exactly what went wrong, if you know how to read it. Each error code points to a different cause: a missing value, a deleted cell, a typo in a function name, or a division by zero. This guide explains every common error, shows a typical example of how it happens and gives the fix. It finishes with tools that help you trace errors through a large workbook.

#N/A: value not available

#N/A almost always comes from a lookup function such as VLOOKUP, XLOOKUP or MATCH that could not find what it was looking for.

Typical causes and fixes:

#VALUE!: wrong type of value

#VALUE! appears when a formula expects one kind of value and receives another, most often text where a number should be.

#REF!: invalid reference

#REF! means a formula points to a cell that no longer exists. The usual cause is deleting a row, column or sheet that a formula used. If =B2*C2 is in D2 and you delete column C, the formula becomes =B2*#REF!.

#DIV/0!: division by zero

Any formula that divides by zero or by an empty cell returns #DIV/0!. It is common in percentage and average columns where some rows have no data yet.

#NAME?: Excel does not recognise something

#NAME? means Excel found text in a formula that it cannot interpret.

#NUM! and #NULL!

#NUM! appears when a calculation produces an impossible or enormous number, for example =SQRT(-4), or when functions such as IRR or RATE cannot find an answer. For IRR, try giving a guess as the second argument, such as =IRR(B2:B10,10%).

#NULL! is rare. It appears when you separate two ranges with a space instead of a comma or colon, so Excel looks for the cells where they intersect and finds none. =SUM(A2:A10 C2:C10) should be =SUM(A2:A10,C2:C10).

#SPILL!: the result has nowhere to go

In Microsoft 365 and Excel 2021, formulas such as FILTER, SORT and UNIQUE can return many values that "spill" into neighbouring cells. If any of those cells already contain something, you see #SPILL!. Select the formula cell and Excel draws a dashed border around the area it needs. Clear or move whatever is in the way. Spill formulas also cannot be placed inside an Excel Table, so put them just outside it.

##### is not really an error

A cell full of hash signs simply means the column is too narrow to show the number or date. Double-click the right edge of the column heading to auto-fit it. If the hashes remain on a date or time, the value is negative, which often means a start time is later than an end time. Check the calculation or see our guide to date and time functions.

Circular reference warnings

A circular reference happens when a formula refers to its own cell, directly or through a chain. Putting =SUM(A2:A20) in A20 is the classic example. Excel warns you and usually returns zero. The status bar at the bottom-left shows the address of the circular cell; you can also use Formulas > Error Checking > Circular References. Change the range so the total sits outside the cells being added.

Tools for tracing errors

Summary

Back to: all Excel tutorials.