empty links display
 

Dear Excel Experts-

I have many cells linked to other worksheets but when nothing has been
entered in the source, the link displays as zero. Is there anyway to specify
what is displayed when the source is empty? Can I tell it to n/a or just to
print nothing? Thanks-

Allison

empty links display
 

Try this:

=IF(Sheet2!B1<"",Sheet2!B1,"")

This returns a blank cell.
Enter anything else you might like displayed, in between the set of double
quotes.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Allison" wrote in message
...
Dear Excel Experts-

I have many cells linked to other worksheets but when nothing has been
entered in the source, the link displays as zero. Is there anyway to
specify
what is displayed when the source is empty? Can I tell it to n/a or just to
print nothing? Thanks-

Allison