empty links display

A

Allison

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
 
R

RagDyeR

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!
=====================================================


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
 
Top