#DIV/0! message



I am trying to create a formula for a percentage whereby the #DIV/0
does not appear if the cell is left blank or is not calcuable.

I can work it out for a percentage change using the following :

=IF(C14=0,"not calculable",(C14-B14)/B14)

but I want it to work for example e4/d14 with values in d being 0 and
being 1, then i get #DIV/0!

and also if the cells are left blank.

Any suggestions


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

problem of an empty cell 5
#DIV/0! Error 2
#div/0 error 2
Using iserror in formula 1
SUM ... Numbers, Nulls "", & Div/0 5
#DIV/0! error 4
HIDE #div/0 1
Wildcard in the Replace function 2