Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!zaphod.mps.ohio-state.edu!mips!apple!robg
From: robg@Apple.COM (Rob Griffiths)
Newsgroups: comp.sys.mac.apps
Subject: Re: Teensy Excel question
Message-ID: <50587@apple.Apple.COM>
Date: 21 Mar 91 19:15:49 GMT
References: <1991Mar21.150720.9313@ee.rochester.edu>
Organization: Apple Computer Inc., Cupertino, CA
Lines: 19

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.