View Single Post
  #2   Report Post  
paul
 
Posts: n/a
Default

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