ERROR.TYPE
Description
Returns an integer representing the error type of the specified value. 1 = #NULL!; 2
= #DIV/0!; 3 = #VALUE!; 4 = #REF!; 5 = #NAME?; 6 = #NUM!; 7 = #N/A; #N/A = Anything
else.
Syntax
ERROR.TYPE(
error_value
)
- error_value: The value to return the error type for.
Example
Formula | Result |
|---|---|
=ERROR.TYPE(12/0) | 2 |
=ERROR.TYPE({10,11,12}) | #N/A |