The ERROR.TYPE function evaluates an error value and returns an integer based on the type of the supplied error.

Syntax

=ERROR.TYPE(error_val)

Arguments

Argument Description
error_val the supplied error_val is a value or a reference to a cell containing a value, that you want to return the error type of.

The integers returned by the ERROR.TYPE function, and their corresponding error types are listed in the table below:

  1 #NULL!  
  2 –  #DIV/0!  
  3 #VALUE!  
  4 #REF!  
  5 #NAME?  
  6 #NUM!  
  7 #N/A  
  #N/A Anything else  

Examples

  A B C D
1 Error Formula Result Notes
2 #VALUE! =ERROR.TYPE(A2) 3  
3 #REF! =ERROR.TYPE(A3) 4  
4   =ERROR.TYPE(1/A4) 2 formula produces the #DIV/0! error
5 10 =ERROR(A5) #N/A there is no error in B5, thus formula returns the #N/A error