About Error Values
Error values are displayed in cells that have incorrect formulas for that cell.
If a formula references a cell that contains an error value, that formula also displays an error value. You can use the function ISERR, ISERRNA, ISERROR, or ISERRVALUE to look for error values.
Error values
If the cell displays |
The formula includes |
Example |
#DIV/0! |
Division by 0 |
10/0 |
#VALUE! |
An argument or operand of the wrong type |
5 + "House" |
#REF! |
A reference to a cell that does not exist |
A cell that refers to another cell that no longer exists |
#NUM! |
An invalid number |
Square root of a negative number |
#N/A! |
Not an available value |
NA( ) function |
#DIM! |
A dimensional value that exceeds the dimension range (valid powers are integers -128 <= n <= 127) A dimensional value used with an inappropriate operation |
1in^100 * 1in^100 (the result is 1in^200, which is beyond the dimension range) 5.2cm^1.5 (not an integer power) |