The formula to do that is: IF (DIVISOR = 0, “Please enter a divisor other than 0”, DIVIDEND/DIVISOR) So, if you’re dividing B2 by C2, the formula would be: =IF (C2=0,“Please enter a divisor other than ...

You could also instruct Excel to leave that cell blank or perform some sort of calculation. IFERROR will provide a substitution for the following errors: #DIV/0!, #NAME?, #N/A, #NULL!, #NUM!, #REF!, ...

If the ERROR.TYPE function in Excel not working for you, ensure the formula is correct, check for errors in the referenced cell, or repair Excel.