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