Need cells to populate with text when I add text to a 3rd cell

[Closed]
Report
Posts
1
Registration date
Monday September 12, 2016
Status
Member
Last seen
September 12, 2016
-
Hi..

Don't know if this is possible, I have searched online in various excell sites including excel sites from office.

What I want to do is... Have current date populate Cell C# and the text "Joined" populate Cell E# if I add text "y" in Cell D#.

I already have excel set up so that the current date appears in C# if text "y" is entered into cell D#... If D# is blank then text "Not Posted" populates Cells C#....

Does that make sense?

Thanks for any help