Blog
Guides to getting more out of Excel, every function explained, and what each error means.
Guides
How to fix #N/A in Excel Why a lookup returns #N/A, the usual causes, and how to find which one you have. The Excel formulas every analyst uses The handful of functions that cover most of the work in a finance or operations job, with an example of each. VLOOKUP vs XLOOKUP: which should you use? What each one does, where VLOOKUP trips people up, and when the old one is still the right call.
Errors explained
#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.