Linking Cells

[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 -

 

[David Biddulph]

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

 

[jolowe]

Wont using the IF function in the destination cell delete the the link in
the cell

 

[Reitanos]

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).