It is best to setup your formulae such that they do not try to divide is divisor is zero, eg:
=IF(N(B1),A1/B1,"")
So if B1 is 0 or text etc a Null value "" is returned, only if B1 were numeric and anything other than zero would the division be processed.
Bookmarks