Prev: Extremely slow calculation of lookup formula
Next: Excel super slow on paste function in 2007
From: Aline on 15 Mar 2010 12:35
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
From: Dave Peterson on 15 Mar 2010 12:45
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
 | 
Pages: 1
Prev: Extremely slow calculation of lookup formula
Next: Excel super slow on paste function in 2007