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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Hi Mitch
Give us an example of your formula and we will probably be able to expand it
for you.

Michael
 
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
 
Back
Top