ExcelBanter - #DIV/0! Error

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - #DIV/0! Error (https://www.excelbanter.com/new-users-excel/46371-div-0-error.html)

Joohn Calder

#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

Bob Phillips

=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

All times are GMT +1. The time now is 10:58 AM.