Ask 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 leadership training, and if not, whether that staff member is eligible for leadership training.

+5
Answers (1)
  1. 5 July, 07: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 the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers