Need for a Conditional Statement

[fishin]

Need a conditional formula to address the following issue:

If cell E10 on a worksheet identified as “Candidate Selection” = “C” and cell G6 on that same worksheet is not blank, post the value “Y” to the recipient cell….if these conditions are not met, the recipient cell is to remain blank.


Help Appreciated

 

[Joe4]

I have noticed that the wording of a lot of your recent questions appears that it might be taken off of homework assignments or tests.
Are these class assignments?

Also, this appears to be a duplicate of this post: https://www.mrexcel.com/forum/excel-questions/1022345-need-conditional-formula.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.