#DIV/0

[Sally]

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

Thank you

 

[Niek Otten]

Hi Harlan,

I agree.

 

[Rob]

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