This tutorial shows you how to fix and remove #DIV/0! error in Microsoft Excel by using the IFERROR or ISERROR function.

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 ...

While they did admit the Excel coding error, their statement said that they “object to in the strongest terms” the accusation of selective data omission.