Formula Error Message

Chambersteacher · Mar 9, 2005

Is there a way to not have the formula error message DIV/0! display in a cell
and still keep the formula?

Myrna Larson · Mar 9, 2005

If the formula is, e.g., =a1/b1 change it to =IF(B1=0,"",A1/B1)