ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Blank Links in Worksheets (https://www.excelbanter.com/links-linking-excel/21589-blank-links-worksheets.html)

Roberta Fischer

Blank Links in Worksheets
 
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

JulieD

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





All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com