ERROR.TYPE « Information functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Information functions
  3. ERROR.TYPE
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