#REF!
Invalid cell reference
What it means
A formula refers to a cell that no longer exists, usually because a row, column or sheet it pointed to was deleted or moved. The most destructive error, since the original reference is permanently replaced by the text #REF!.
How to fix
Press Ctrl+Z immediately to undo the deletion. Use absolute references or named ranges to make formulas more robust. Search the workbook for #REF! and fix each affected formula.
In other languages
German #BEZUG!
French #REF!
Spanish #¡REF!
Italian #RIF!
Portuguese #REF!
Dutch #VERW!
Polish #ADR!
Russian #ССЫЛ!
#N/A
Value not available
What it means
A lookup function (VLOOKUP, XLOOKUP, MATCH) searched and found nothing. Common causes: the value is not in the range, trailing spaces, or a number stored as text.
How to fix
Verify the lookup value exists in the range. Trim spaces and match data types. Wrap the lookup in IFNA() to show a friendly message instead of the error.
In other languages
German #NV
French #N/A
Spanish #N/D
Italian #N/D
Portuguese #N/D
Dutch #N/B
Polish #N/D!
Russian #Н/Д
#DIV/0!
Division by zero
What it means
The formula divides by zero or by an empty cell. AVERAGEIF and similar functions also throw it when no cells match the criteria.
How to fix
Check the divisor is not zero or blank. Use =IF(B2=0,"",A2/B2) to suppress only the expected case, or =IFERROR(A2/B2,"") to catch all errors.
In other languages
German #DIV/0!
French #DIV/0!
Spanish #¡DIV/0!
Italian #DIV/0!
Portuguese #DIV/0!
Dutch #DEEL/0!
Polish #DZIEL/0!
Russian #ДЕЛ/0!
#VALUE!
Wrong type of argument
What it means
A formula receives the wrong type of value, such as text where a number is expected, or text inside a DATE or math function.
How to fix
Check that referenced cells contain the right data type. Use ISNUMBER or ISTEXT to find the offending value, and correct the input.
In other languages
German #WERT!
French #VALEUR!
Spanish #¡VALOR!
Italian #VALORE!
Portuguese #VALOR!
Dutch #WAARDE!
Polish #ARG!
Russian #ЗНАЧ!
#NAME?
Unrecognized name
What it means
Excel cannot recognize a function or named range, usually from a misspelled function name, missing quotes around text, or a function not available in your Excel version.
How to fix
Check the spelling of function and range names. Newer functions like XLOOKUP, FILTER and LAMBDA require Excel 2021 or Microsoft 365; older versions show #NAME?.
In other languages
German #NAME?
French #NOM?
Spanish #¿NOMBRE?
Italian #NOME?
Portuguese #NOME?
Dutch #NAAM?
Polish #NAZWA?
Russian #ИМЯ?
#NUM!
Invalid number
What it means
A numeric operation is invalid: square root of a negative number, a result beyond ±1×10^308, or an iterative function (IRR, RATE) that fails to converge.
How to fix
Use valid numeric inputs. For IRR or RATE, supply a guess argument, e.g. =IRR(A1:A12, 0.1), to help the function converge.
In other languages
German #ZAHL!
French #NOMBRE!
Spanish #¡NUM!
Italian #NUM!
Portuguese #NÚM!
Dutch #GETAL!
Polish #LICZBA!
Russian #ЧИСЛО!
#NULL!
No intersection
What it means
A space was used as the intersection operator between two ranges that do not intersect, e.g. =SUM(A1:A10 C1:C10) instead of a comma or colon.
How to fix
Replace the stray space with a comma to add ranges, =SUM(A1:A10, C1:C10), or a colon for one continuous block, =SUM(A1:C10).
In other languages
German #NULL!
French #NUL!
Spanish #¡NULO!
Italian #NULLO!
Portuguese #NULO!
Dutch #LEEG!
Polish #ZERO!
Russian #ПУСТО!
#SPILL!
Spill range blocked
What it means
A dynamic array result cannot spill because something already occupies the spill range, or the formula sits inside an Excel table. Appears only in newer Excel versions.
How to fix
Clear any data in the spill range and make sure no cells are merged. Do not use dynamic array functions inside Excel tables.
In other languages
German #ÜBERLAUF!
French #DÉBORDEMENT!
Spanish #¡DESBORDAMIENTO!
Italian #SPILL!
Portuguese #DERRAM.!
Dutch #OVERLOOP!
Polish #ROZLANIE!
Russian #ПЕРЕНОС!
#CALC!
Calculation error
What it means
A dynamic array formula hit a calculation it cannot complete, for example FILTER returning an empty result with no fallback specified.
How to fix
Add an if_empty argument, e.g. =FILTER(range, condition, "No match"), and check the array syntax is correct.
In other languages
German #KALK!
French #CALC!
Spanish #¡CALC!
Italian #CALC!
Portuguese #CÁLC!
Dutch #BEREKEN!
Polish #OBLICZ!
Russian #ВЫЧИСЛ!