Linking question
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 |
Linking question
=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 |
Linking question
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 |
Linking question
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 |
All times are GMT +1. The time now is 11:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com