About Error Values

Office 2013 and later

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.

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)

Show: