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

M

MitchP

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

Michael

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

Michael
 
M

MitchP

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

MitchP said:
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.
Click to expand...
Click to expand...

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