Need a formula to address the following:
If cell E10 on a worksheet identified as “CandidateSelection” = “C” and cell G6 on that same worksheet is not blank, post thevalue “Y” to the recipient cell….if these conditions are not met, the recipientcell is to remain blank.
Help is appreciated
If cell E10 on a worksheet identified as “CandidateSelection” = “C” and cell G6 on that same worksheet is not blank, post thevalue “Y” to the recipient cell….if these conditions are not met, the recipientcell is to remain blank.
Help is appreciated