View Single Post
  #8   Report Post  
CLR
 
Posts: n/a
Default

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