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; 8 = #GETTING_DATA; #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 |
Notes
- The #GETTING_DATA state occurs during a live data refresh and isn't an actual error.