Want the cell blank
 

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

presumably if one is blank the other will also be blank
=if(D41="","",D41/E41)
--
paul
remove nospam for email addy!



"LMB" wrote:

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




"LMB" wrote in message
...
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

Thanks Paul and CLR...both worked...what is the difference in the
statements?

Thanks,
Linda

"LMB" wrote in message
...
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

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
--
paul
remove nospam for email addy!



"LMB" wrote:

Thanks Paul and CLR...both worked...what is the difference in the
statements?

Thanks,
Linda

"LMB" wrote in message
...
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

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

Thanks Paul and CLR...both worked...what is the difference in the
statements?

Oh....Is Error!

Thanks,
Linda

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

Thanks Paul and CLR...both worked...what is the difference in the
statements?

Another alternative...........

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

Vaya con Dios,
Chuck, CABGx3





"LMB" wrote in message
...
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