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

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.

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

Michael
--
Michael Mitchelson


"MitchP" wrote:

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.

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

"MitchP" wrote:

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.

"JayDax" wrote:

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

"MitchP" wrote:

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