Ask Question
26 January, 03:31

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.

+2
Answers (1)
  1. 26 January, 05:37
    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?
Find 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 you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers