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
|