![]() |
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 |
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