how do I generate a blank cell when I paste link; comes up - or 0

[Guest]

I'm trying to make a template for invoice / bill of lading where data is
linked from an input worksheet and linked to a form worksheet. When I link
blank cells, the results are - or 0. I would like the cells on the form to
be blank if empty on the template.

 

[Guest]

Hi Mitch
Give us an example of your formula and we will probably be able to expand it
for you.

Michael

 

[Guest]

How about -if([cell ref.]="","",[cell ref.])

 

[Guest]

How about -if([cell ref.]="","",[cell ref.])

I'm trying to make a template for invoice / bill of lading where data is
linked from an input worksheet and linked to a form worksheet. When I link
blank cells, the results are - or 0. I would like the cells on the form to
be blank if empty on the template.

This seems way too easy, thanks. I've been looking at this so lond I missed
the obious.
MitchP