Blank Links in Worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roberta Fischer - 12 Apr 2005 14:09 GMT

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

Reply to this Message

JulieD - 12 Apr 2005 15:45 GMT

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.

Signature

Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway

> Hello,
>
[quoted text clipped - 11 lines]
>
> Thanx in advance

Reply to this Message