ERROR.TYPE

ERROR.TYPE — the type of error

ERROR.TYPE(error)

error: an error

ERROR.TYPE returns an error number corresponding to the given error value. The error numbers for error values are:

#DIV/0! 2

#VALUE! 3

#REF! 4

#NAME? 5

#NUM! 6

#N/A 7

This function is Excel compatible.

Synopsis