ERROR.TYPE

ERROR.TYPE

Synopsis

ERROR.TYPE(value)

Description

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.

Examples

ERROR.TYPE(NA()) equals 7.

See also

ISERROR.