Thread: #DIV/0!
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default #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