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.