linking to other workbooks

G

Guest

I am linking cells from one worksheet to another. When there is nothing
entered yet in the worksheet that I want the into to carry over from, it
is inserting a 0 in the cell (but shows my formula in the top fx box).
Do you know how to get rid of that 0 so the cell is completely blank
until the info is entered on the worksheet it is linked to?
 
G

Gord Dibben

=IF(Sheet1!A1="","",Sheet1!A1)

Will make the cell look blank.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking sheets how do I display the zeros (0) as blank cells 1
I need a cell to be blank. 4
Linking multiple cells between workbooks 2
Linking Cells, Incorrect Result 1
result should equal a blank field 2
Linking worksheets 1
Linking a workbook to worksheets 1
Excel 2007 - Linking workbooks 1

Top