#DIV/0! Error

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

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

--
HTH

Bob Phillips

"Joohn Calder" <[email protected]> wrote in message
news:[email protected]...
> 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