Hi!
You can use it

=IF(ISERROR(A1/B1),0,A1/B1)


Bond! <Chon, Sung-Chul


"renold1958"님이 작성한 내용:

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?