Excel ERROR.TYPE function

Function              ERROR.TYPE

Description        Excel ERROR.TYPE function take input of an error value and returns an integer. That integer indicates the type of error.

Syntax  ERROR.TYPE(error_val)

error_val  The error for which to get an error code.

1 = #NULL!

2 = #DIV/0!

3 = #VALUE!

4 = #REF!

5 = #NAME?

6 = #NUM!

7 = #N/A

8 = #GETTING_DATA

#N/A = Anything Else