#DIV/0! Error

G

Guest

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

#Div/0 10
Surpress Average Error 3
divide so no error Excel 2007 1
#DIV error 5
incorporate the remove #DIV/0! code into another formula to get bl 5
Ignoring Blank cells 9
#DIV/0! 14
Formula help 3

Top