=ERROR.TYPE("#NULL!") Number of the #NULL! error : ERROR.TYPE « Information functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Information functions
  3. ERROR.TYPE
Fill A1 with =1/0
Fill A1 with =1/0
Input the formula: =ERROR.TYPE(A1). Press Enter to get the result.
Input the formula: =ERROR.TYPE(A1)








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