🚀 go-pugleaf

In article <1991Mar21.150720.9313@ee.rochester.edu> rajiv@ee.rochester.edu (Rajiv Arora) writes:
>
>My question: is there any way to suppress the link returning a 0 intead of a
>missing value?

I've got the "brute force, complex formula" solution.  Maybe someone has
a more elegant method, but here's mine.  Replace the basic formula with
the following:

   =IF(ISBLANK(Worksheet2!$A$1),"",Worksheet2!$A$1)

Of course, in this example, Worksheet2 is the linked worksheet, and I'm
referencing cell $A$1.  Change to suit your requirements.  ;).  Warning:
This could get very memory-intensive if you have >lots< of links that 
you need to check for zero/blank status.  However, it does work, and will
correctly treat a zero and a blank differently when performing averages
and the like.

-rob.