Results 1 to 4 of 4

True false statement with dates

Threaded View

  1. #1
    Registered User
    Join Date
    10-17-2011
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    6

    True false statement with dates

    Probably a novice issue, but I cannot figure out how to do a true/false if/then statement.

    I want a formula that for cell C3 says if cell H3 (in a different worksheet) has a date in it, then display Yes, if there is nothing in it, display No.

    I have tried =IF('Participant Overview'!H3, "Yes", "No") thinking a logical argument would work that if there was something in the cell it would equal true and false would be nothing in the cell. However, I get No displayed no matter what is in the H3 cell.

    Thanks!
    Last edited by hrclark; 10-18-2011 at 11:42 AM.

Thread Information

Users Browsing this Thread

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

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