Ask Question
17 June, 15:08

In cell M2, enter a formula using a nested IF function and structured references to determine first if a staff member already has completed leadership training, and if not, whether that staff member is eligible for leadership training.

+3
Answers (1)
  1. 17 June, 16:16
    0
    =IF ([@[Academic Technology Training]]="Yes", IF ([@[Service Years]]>2,"Yes","No"))

    Explanation:

    =IF ([@[Academic Technology Training]]="Yes", IF ([@[Service Years]]>2,"Yes","No"))
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “In cell M2, enter a formula using a nested IF function and structured references to determine first if a staff member already has completed ...” in 📙 Engineering if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers