Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!ub!uhura.cc.rochester.edu!ee.rochester.edu!rajiv
From: rajiv@ee.rochester.edu (Rajiv Arora)
Newsgroups: comp.sys.mac.apps
Subject: Teensy Excel question
Message-ID: <1991Mar21.150720.9313@ee.rochester.edu>
Date: 21 Mar 91 15:07:20 GMT
Sender: rajiv@ee.rochester.edu (Rajiv Arora)
Organization: University of Rochester Department of Electrical Engineering
Lines: 18


I have a problem in Excel 2.2 that I'm sure has a simple answer. I'm creating a
link between two cells in different worksheets. The problem I'm having is that
when I leave my source cell blank (indicating *missing value* rather than 0),
my destination cell always gets the value zero. This is mucking up my
calculations (average and standard deviation).

My question: is there any way to suppress the link returning a 0 intead of a
missing value?

I did RTFM but couldn't find any thing about it. (Which doesn't mean it's not
there, in bold face, staring me straight in the face!)

-Rajiv Arora
-- 
Addresses:
	UUCP:   ...!rochester!ur-valhalla!rajiv
    Internet:   rajiv@ee.rochester.edu