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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Sharing workbooks limitations - Merged Cells 12
Linking cell to different workbook 2
Mulitple Workbooks and Ignoring Blank Cells 5
Copying linked sheet 2
Link cell to another workbook 5
Excel 2003 - Parameterize Workbook Links? 4
referencing cells in different workbooks 2

Back
Top