Linking question

[gjack72]

I am linking my source workbook to a destination workbook.
When I have a link with no data in the source cell, it is giving it a value of '0'
in my destination cell. How do I get the destination to show a null value
like my source cell.

Thanks,

GJ

[Dave Peterson]

=if(a1="","",a1)
or
=if(sheet2!a1="","",sheet2!a1)


gjack72 wrote:
>
> I am linking my source workbook to a destination workbook.
> When I have a link with no data in the source cell, it is giving it a
> value of '0'
> in my destination cell. How do I get the destination to show a null
> value
> like my source cell.
>
> Thanks,
>
> GJ
>
> --
> gjack72
> ------------------------------------------------------------------------
> gjack72's Profile: http://www.excelforum.com/member.php...o&userid=30375
> View this thread: http://www.excelforum.com/showthread...hreadid=500323

--

Dave Peterson

[gjack72]

Thanks,
I tried IIF(), that did not work, did not try IF() Yet.

GJ

[Dave Peterson]

IIF isn't a worksheet function (well, in the USA version).

But it is a function in VBA.

gjack72 wrote:
>
> Thanks,
> I tried IIF(), that did not work, did not try IF() Yet.
>
> GJ
>
> --
> gjack72
> ------------------------------------------------------------------------
> gjack72's Profile: http://www.excelforum.com/member.php...o&userid=30375
> View this thread: http://www.excelforum.com/showthread...hreadid=500323

--

Dave Peterson