=IF(B1=0,"",A1/B1)

--
HTH

Bob Phillips

"Joohn Calder" wrote in message
...
Hi

I get an error (#DIV/0!) when I divide one cell by the other and there are
no entries in the cells.

How can i get the folrmula to surpress the error (show a blank cell) when
there are no entries in the cells that the formula refers to?

Could you please provide an example

Thanks

John