Author: Oscar Cronquist Article last updated on May 04, 2022

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

1. ERROR.TYPE Function Syntax

ERROR.TYPE(error_val)

Back to top

2. ERROR.TYPE Function 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

The ERROR.TYPE function returns #N/A! error if there is no error value in the argument.

Back to top

3. ERROR.TYPE Function example

Formula in cell C3:

=ERROR.TYPE(B3)

Back to top