#DIV/0!
It means that your formula attempted to divide a number by 0, which is an
illegal operation. You can write your formula to circumvent the error with
something like the following:
=IF(B1=0,"",A1/B1)
or
=IF(your_formula = 0,"",your_formula)
or, in 2007,
=IFERROR(A1/B1,"")
"Jim S" wrote in message
...
What does #DIV/0! mean when it shows up in a cell with a formula?
--
Jim S
|