If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Leave cell blank when linked to another workbook
I want to keep cells blank (empty) when they are linked to
empty (blank) cells. How do I prevent the "0" from showing up. Oh and the if the "0" is entered in a cell it is a valid value. The link is simply =[Book3]Sheet1!A7 Oh and there can be no formula on the source workbook, everything has to be done on the target.. any ideas? Remove #$%^& from email address to send directly thanks, |
#2
|
|||
|
|||
Leave cell blank when linked to another workbook
To make the cell *look* blank, you can change your formula:
=IF(=[Book3]Sheet1!A7="","",=[Book3]Sheet1!A7) Wesley Sparks wrote: I want to keep cells blank (empty) when they are linked to empty (blank) cells. How do I prevent the "0" from showing up. Oh and the if the "0" is entered in a cell it is a valid value. The link is simply =[Book3]Sheet1!A7 Oh and there can be no formula on the source workbook, everything has to be done on the target.. any ideas? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Leave cell blank when linked to another workbook
Works exactly as I needed, thanks
-----Original Message----- To make the cell *look* blank, you can change your formula: =IF(=[Book3]Sheet1!A7="","",=[Book3]Sheet1!A7) Wesley Sparks wrote: I want to keep cells blank (empty) when they are linked to empty (blank) cells. How do I prevent the "0" from showing up. Oh and the if the "0" is entered in a cell it is a valid value. The link is simply =[Book3]Sheet1! A7 Oh and there can be no formula on the source workbook, everything has to be done on the target.. any ideas? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
Thread Tools | |
Display Modes | |
|
|