Woops should have been:

=IF(C5="","",B5/C5) unless C5 could contain a zero when
=IF(OR(C5="",C5=0),"",B5/C5) or =IF(SUM(C5)=0,"",B5/C5) will be needed.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk
"renold1958" wrote in message
...
Have a spreadsheet....one column keeps coming up with #DIV/0!.........I
know
reasons as of to why, etc etc............is there anyway have the #DIV/0!
values disappear from a column?