Hi brainiacs,
Not sure if my title was clear. From the sheet, the main columns to focus on are H and J.
What I am trying to do:
If cell H has a date in it, cell J says "Yes".
If cell H has a "Yes" in it, cell J says "Yes".
If cell H has "N/A" in it, cell J says "N/A".
If cell H is blank, cell J says "No".
I've tried playing around with the IF function, and the IS function, but so far I am having no luck and maybe I am using the wrong function.
That's where I am hoping you super stars will be able to help.
Thanks in advance for your support and feel free to ask any questions if more clarification is needed.
Thanks all
Bookmarks