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!
Bookmarks