Hello,

I'm using windows xp and am trying to link 2 worksheets using the following
example:
Sheet 1, block 1A equals Sheet 2 , Block 1A using this command =Sheet1!A1

My problem is that as soon as I type this in a press enter, if the source
block has nothing in it a "0" appears in my result block.

How do I get rid of thÃ*s "0"? (ie, the result cell should be blank until the
source cell is filled with data.)

Thanx in advance

Hi Roberta

you can use an IF function e.g.
=IF(ISBLANK(Sheet1!A1),"",Sheet1!A1)

this will make the cell look blank unless there is something in sheet1 a1
but be aware that the cell actually contains a zero length string (rather
than nothing) that may impact on your formulas.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Roberta Fischer" <Roberta wrote in
message ...
Hello,

I'm using windows xp and am trying to link 2 worksheets using the
following
example:
Sheet 1, block 1A equals Sheet 2 , Block 1A using this command =Sheet1!A1

My problem is that as soon as I type this in a press enter, if the source
block has nothing in it a "0" appears in my result block.

How do I get rid of thís "0"? (ie, the result cell should be blank until
the
source cell is filled with data.)

Thanx in advance