Errors
In some cases formula values may return errors. For example, you might have entered an expression with invalid syntax, or you might be referencing a cell that does not exist. The specific error value that is returned can hint at the cause of the issue and help find a solution.
The following table contains information about all supported errors.
|
#SPILL! |
Spill Error occurs when a dynamic array formula cannot spill its results because one or more of the target cells are occupied by non-empty content that the formula does not own. To resolve the error, clear or move the blocking cells. The error is represented by the |
|
#CALC! |
Calculation Error occurs when the calculation engine cannot determine the size of the array result. This typically happens when the array dimensions are infinite or cannot be resolved because of unbounded or circular dependencies. The error is represented by the |
|
#DIV/0! |
Divide by Zero Error occurs when the formula contains an expression that results in division by zero. For example, such error is produced when the following expression is calculated: =5/0. |
|
#VALUE! |
Error in Value occurs when an argument is not of the correct type. For example, passing the ABS function (ABS function returns the absolute value of a number) a text value as an argument (which is not a text number representation, such as "5") produces the #VALUE! error: =ABS("string"). |
|
#REF! |
Reference Error implies that the referenced cell does not exist (for example, ABCDE1) or has been deleted. |
|
#NAME? |
Invalid Name Error indicates that the cell value contains a name of an unknown function or variable. For example, an attempt to use a function that is not in the built-in functions list produces the #NAME? error: =ABCDEF(). Another case that produces the error is use of an undefined name. |
|
#NUM! |
Number Error indicates that the number does not meet function requirements. For example, passing the LN function (LN function returns the natural logarithm of a number) a negative number as argument produces the #NUM! error: =LN(-10). |
|
#N/A |
Value Not Available Error occurs when a function cannot produce a valid output. For example, passing the MODE function (MODE function returns the most frequently occurring or repetitive value in an array or range of data) the arguments 1, 2, 3 causes the #N/A error because each of the numbers appears exactly once and the set of numbers does not have a mode: =MODE(1,2,3). |
|
#NULL |
Null Error occurs when the two cell ranges passed to an intersection operator do not intersect. For example, the value =A1:A2 B1:B2 returns a null error because the two ranges do not have cells in common. |