division by zero error

I have a spreadsheet that divides one cell by another. The problem is
the cells do not always contain data. Is there any way to remove the
#DIV/0! message that comes up? It does not look too professional.
Thanks,
Peter

Peter here is one way, instead of =A1/B1 you could use
=IF(ISERROR(A1/B1),"",A1/B1)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"peter" <plaz987@yahoo.com> wrote in message
news:1105288819.860742.31040@c13g2000cwb.googlegroups.com...
> I have a spreadsheet that divides one cell by another. The problem is
> the cells do not always contain data. Is there any way to remove the
> #DIV/0! message that comes up? It does not look too professional.
> Thanks,
> Peter
>

Thanks, Paul!