Question regarding link cells in different workbooks

  • Thread starter Thread starter Aline
  • Start date Start date
A

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".
 
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)
 
Back
Top