#1   Report Post  
Posted to microsoft.public.excel.misc
neilbrown1965
 
Posts: n/a
Default Link cell

When using the above. When the source cell is empty the target cell has data,
how can I get rid, so the target cell is blank until source cell has data
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Link cell

You can check first:

=if(b99="","",b99)
or
=if(sheet1!a1="","",sheet1!a1)



neilbrown1965 wrote:

When using the above. When the source cell is empty the target cell has data,
how can I get rid, so the target cell is blank until source cell has data


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link page header with cell contents Matthew Excel Worksheet Functions 8 May 1st 07 06:22 PM
hyperlink - link one cell to another in a worksheet. how? Drewz Excel Worksheet Functions 1 October 20th 05 04:09 PM
How do I use a cell value as the filename in an external link? wattkisson Excel Worksheet Functions 1 July 8th 05 11:51 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 03:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"