Oops, you wanted 0's.

#1. You can't.

#2. Check to see if the denominator is zero first:
=if(a1=0,0,b1/a1)

or check for an error
=if(iserror(b1/a1),0,b1/a1)





David wrote:

Q1) How do i get a cell to show/display zero when no data has been input or
when the dat has been deleted.

Q2)how do i get a cell to display 0 instead of #DIV/0!

--

Dave Peterson