Substituting #DIV/O! for blank

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

I currently have my template for my final document. However, in one of my
columns all the cells are filled in with #DIV/0!. I presume that this is due
to there being no data in these cells as yet.

Nevertheless, is there anyway I can format these cells, so that they just
appear blank??

Thanks
 
Hi
try the following
- select the cells (lets say starting in D1)
- goto 'format - Conditional Format'
- enter the following formula
=ISERROR(D1)
- choose a white font for this condition
 
Or you could modify your formula:

=if(iserror(yourformula),"",yourformula)

You don't always have to test the whole formula. Lots of times it's enough to
just test to see if the denominator is different from 0.

=if(sum(a1:b1)=0,"",average(a1:b1))
 
Back
Top