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