Cells

[Guest]

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!

 

[Guest]

David,

Hide the error with
=IF(ISERROR(A1/B1),0,A1/B1)

Miek

 

[Dave Peterson]

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

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

 

[Dave Peterson]

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)