ERROR.TYPE(error_val) returns a number corresponding to an error type : ERROR.TYPE « Information functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Information functions
  3. ERROR.TYPE

If error_val is ERROR.TYPE returns

#NULL! 1

#DIV/0! 2

#VALUE! 3

#REF! 4

#NAME? 5

#NUM! 6

#N/A 7

Anything else #N/A

17.2.ERROR.TYPE
17.2.1.ERROR.TYPE(error_val) returns a number corresponding to an error type
17.2.2.=ERROR.TYPE("#NULL!") Number of the #NULL! error=ERROR.TYPE(
17.2.3.Combine CHOOSE and ERROR.TYPE to display friendly error messageCombine CHOOSE and ERROR.TYPE to display friendly error message
17.2.4.If #NULL! or #DIV/0!, display messagesIf #NULL! or #DIV/0!, display messages