linked cells

  • Thread starter Thread starter tom in chats
  • Start date Start date
T

tom in chats

if the source cell is blank as in no middle initial in a
name, why does the linked cell shoe "0" instead of blank?
can the source formula be formatted so that the linked
cell will also be blank if the source cell is blank?
 
Hi
another solution would be to use a formula like
=IF('sheet1'!A1<>"",'sheet1'!A1,"")
 
Tom

Link on same sheet.....

=IF(A1="","",A1)

Link on other sheet.....

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

Alternative.......Tools>Options>View. Uncheck "zero values"

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

linked workbook cell returns 0 is source workbook cell is blank? 4
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Excel formula, sum the value cell and if empty cell left blank 0
Link to an empty cell question. 2
Comparison of columns using Conditional Formatting 3
HELP!!!!!!!!! 2
Linking sheets how do I display the zeros (0) as blank cells 1
I need a cell to be blank. 4

Back
Top