Linking Cells

  • Thread starter Thread starter jolowe
  • Start date Start date
J

jolowe

Is there any way NOT to have the "0" in a linked cell? There are times that
one or more of the destination cells will not have information because the
linked cell need to be blank. But I still need the cell liked because the
data changes from day to day.
I need blank destination cells!!!!

Thank you for any help with this -
 
In David's reply up above he uses the IF to check what's in A1, but
only links to the data when the result is not empty.
The IF uses 3 parameters:
IF(condition,true response,false response)
which means that his formula says
If whatever is in cell A1 happens to be equal to a NULL string
(written as ""), then write a Null string in this cell, otherwise
place the value that you found in A1.
This then will generate an apparently blank result if A1 is blank, but
will write a value otherwise (note that a zero in A1 will generate a
zero here as well).
 

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

Comparison of columns using Conditional Formatting 3
Link to an empty cell question. 2
linking cells to another workbook 1
I need a cell to be blank. 4
Source and Destination worksheet difference 5
Link changes in destination workbook 4
Linking sheets how do I display the zeros (0) as blank cells 1
Link cell between WS w/o dest display 0-jan if no entry at source 1

Back
Top