Reference
Excel errors
An error is Excel telling you what went wrong. Each page shows the error happening on a live sheet, why it happens, and how to fix it.
Error What it means
#N/A #N/A means a lookup could not find what it was asked to find. The formula is usually fine; the value is not in the list. #N/A means a lookup could not find what it was asked to find. The formula is usually fine; the value is not in the list.#REF! #REF! means the formula points at a cell or position that does not exist: off the edge of a range, or a cell that has been deleted. #REF! means the formula points at a cell or position that does not exist: off the edge of a range, or a cell that has been deleted.#VALUE! #VALUE! means a formula was given the wrong kind of thing: most often text where a number was needed. #VALUE! means a formula was given the wrong kind of thing: most often text where a number was needed.#DIV/0! #DIV/0! means a formula tried to divide by zero or by an empty cell, which has no answer. #DIV/0! means a formula tried to divide by zero or by an empty cell, which has no answer.#NAME? #NAME? means Excel found a word in the formula it does not recognise: usually a misspelt function or text without quotes. #NAME? means Excel found a word in the formula it does not recognise: usually a misspelt function or text without quotes.#NUM! #NUM! means a calculation has no valid numeric answer: the square root of a negative number, or a result too large to hold. #NUM! means a calculation has no valid numeric answer: the square root of a negative number, or a result too large to hold.#SPILL! #SPILL! means a formula wants to fill several cells with its results, but something is already in the way. #SPILL! means a formula wants to fill several cells with its results, but something is already in the way.#CALC! #CALC! means a formula that returns a list has ended up with nothing to return, or was written in a way Excel cannot work out. #CALC! means a formula that returns a list has ended up with nothing to return, or was written in a way Excel cannot work out.