#DIV/0

Sally · Sep 3, 2003

How can I get a cell to read 0% instead of #DIV/0?
I want to eliminate the error.

Thank you

Niek Otten · Sep 4, 2003

Hi Harlan,

I agree.

Rob · Sep 8, 2003

=IF(ISERROR(cell1/cell2),"0%",cell1/cell2)

Taking Average ignoring #DIV/0! in the range...	1	Apr 16, 2009
Supress DIV/0	2	Oct 8, 2013
Need to average data if in cells, but ignore blank cells.	4	Jul 1, 2009
Formula	2	Apr 28, 2009
Averaging a column that contains text	4	May 28, 2010
#DIV/0! error with DAVERAGE Function	5	Aug 5, 2009
Get rid of DIV/0 error message	4	Dec 11, 2008
dividing by 0 error	6	Nov 21, 2008

Ask a Question