About Error Values
Last modified: March 09, 2015
Applies to: Office 2013 | Visio 2013
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.
|
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) |