Want the cell blank

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hi Guys,

Using Excel 2000. I have a formula below. If the cells D41 and E41 are
blank, it returns this #DIV/0! I would like the cell to be blank if there
is no info in it. How do I do that?


=D41/E41


Thanks,
Linda
 
Wrap your formula in an IF statement, like

=IF(ISERR(D41/E41),"",D41/E41)

Vaya con Dios,
Chuck, CABGx3
 
mine is a simple if statement(If d41 is blank then blank otherwise d41/e41)
which does what you asked for but limited to d41 being blank....however if
you type 0 in d41 you will get the div 0 error again.The other one says if
there is an error then blank,otherwise d41/e41
 
Linda

Just a head's up.

The ISERROR will mask all errors that arise and could mask some other error
that is undesirable like #REF! or #VALUE! or #NAME?


Gord Dibben Excel MVP
 
Oh....Is Error!

Thanks,
Linda

Gord Dibben said:
Linda

Just a head's up.

The ISERROR will mask all errors that arise and could mask some other
error
that is undesirable like #REF! or #VALUE! or #NAME?


Gord Dibben Excel MVP
Click to expand...
 
Another alternative...........

=IF(OR(E41="",E41=0),"",D41/E41)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top