Linking blank cells

V

--Viewpoint

I created a workbook for others to use. The first sheet in the Excel
workbook has general information that I linked to cells on other worksheets.

However, when cells on the general information sheet are blank, a zero
appears in the other worksheets.

What must I do to maintain the link to the general information sheet but
eliminate the zero?
 
G

Gord Dibben

Either turn off zero values display in Options or trap for blank cell.

I prefer the trap.

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


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

Sharing workbooks limitations - Merged Cells 12
Need to merge worksheets - Excel 2003 0
Excel Move or Copy Stopped Working? 0
cells linked from worksheet to worksheet 1
How do I remove zeros from a linked blank cell? 3
links 1
Paste Values in linked Cells Only 4
Number Formatting 1

Top