division by zero error

  • Thread starter Thread starter peter
  • Start date Start date
P

peter

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
 
Back
Top