+ Reply to Thread
Results 1 to 3 of 3

Linked cell showing data even though no data in cell it's linked to

Hybrid View

  1. #1
    Registered User
    Join Date
    01-03-2013
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    22

    Linked cell showing data even though no data in cell it's linked to

    I'm using this formula in a Compliance spreadsheet:

    =IF(ISERROR(Dashboard!HZ5),"-",Dashboard!HZ5)

    It links to the Dashboard spreadsheet. If there is no data in the cell in the Dashboard spreadsheet then the cell in the Compliance spreadsheet should have '-' in it. However, it is showing a date (dd/mm/yyyy) even though there is no date in the Dashboard spreadsheet currently.

    Any ideas on why this is happening? I have this formula in various other places throughout the workbook and it is working without an issue.

    Thanks.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Linked cell showing data even though no data in cell it's linked to

    Try this....

    =IF(Dashboard!HZ5="","-",Dashboard!HZ5)
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    01-03-2013
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Linked cell showing data even though no data in cell it's linked to

    Thank you very much! It worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 09-21-2011, 10:02 PM
  2. Using duplicate cell linked data
    By mgerada in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-25-2011, 03:25 AM
  3. Linked cell value's showing 0 if empty?
    By softice11 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-17-2006, 07:02 PM
  4. Linked cell value showing 0 if empty
    By softice11 in forum Excel General
    Replies: 1
    Last Post: 09-17-2006, 08:00 AM
  5. Replies: 1
    Last Post: 09-21-2005, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1