Occurs when a number is divided by zero.

A1 contains 123

B1 contains nothing or 0

=A1/B1 will throw the #DIV/0! error.

You can trap the error using

=IF(AND(ISNUMBER(B1),(B1<0)),A1/B1,"")

which will make the cell look blank if B1 is blank or 0 or not a number.


Gord Dibben MS Excel MVP

On Wed, 7 Mar 2007 17:46:53 -0700, "Jim S" wrote:

What does #DIV/0! mean when it shows up in a cell with a formula?