Cells

D

David

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!
 
D

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)
 
D

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