#DIV/0! Error

J

Joohn Calder

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Ignoring Blank cells 9
#Div/0 10
How to render HTML inside a Powerpoint slide through VBA 0
Surpress Average Error 3
How do I make #DIV/0! error message go away? 2
#DIV error 5
divide so no error Excel 2007 1

Top