Author: Oscar Cronquist Article last updated on September 04, 2018

The ERROR.TYPE function returns a number that represents one of the error values in Excel.

Formula in cell C3:

=ERROR.TYPE(B3)

Excel Function Syntax

ERROR.TYPE(error_val)

Arguments

error_val Required. A cell reference to an error value that you want to know the number of.
error_val ERROR.TYPE
#NULL! 1
#DIV/0! 2
#VALUE! 3
#REF! 4
#NAME? 5
#NUM! 6
#N/A! 7
#GETTING_DATA 8

Comments

If no errror value in argument the ERROR.TYPE function returns #N/A! error.