Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Information Functions

 

If #NULL! or #DIV0!, display messages

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