Question regarding link cells in different workbooks
 

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".
--
Aline

Question regarding link cells in different workbooks
 

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)

Aline wrote:

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".
--
Aline

--

Dave Peterson