Question regarding link cells in different workbooks

[Aline]

After succesful linking from one workbook to another,, we would get "0"
(zero) on the designed cells if there is no data on the resource cells.

My question is what should I do if I want to have something instead e.g.,
"NA".

 

[Dave Peterson]

I like showing "" if the sending cell is empty.

=if(a1="","",a1)
or
=if('sheet 99'!a1="","",'sheet 99'!a1)
or
=if([book1.xls]Sheet1!$A$1="","",[book1.xls]Sheet1!$A$1)

I had my sending workbook open when I built the formula--so I didn't have to
type the drive/path, too.

But you could return whatever you wanted:
=if('sheet 99'!a1="","NA",'sheet 99'!a1)
or for a real error:
=if('sheet 99'!a1="",na(),'sheet 99'!a1)