If #NULL! or #DIV/0!, display messages : ERROR.TYPE « Information functions « Microsoft Office Excel 2007 Tutorial






Fill A1 with: =1/0
Fill A1 with: =1/0
Input the formula: =IF(ERROR.TYPE(A1)<3,CHOOSE(ERROR.TYPE(A1),"Ranges do not intersect","The divisor is zero"))
Press Enter to get the answer
Press Enter to get the answer








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