Register
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
93.1k views
0 votes
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.

User Andrew Murphy
by
8.3k points

1 Answer

1 vote

Answer:

=IF([@[Academic Technology Training]]="Yes",IF([@[Service Years]]>2,"Yes","No"))

Step-by-step explanation:

=IF([@[Academic Technology Training]]="Yes",IF([@[Service Years]]>2,"Yes","No"))

User Andrew Hundt
by
7.9k points
← Prev Question Next Question →

Related questions

Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.2m answers

Other Questions

4. Which of the following is the first thing you should do when attempting to park? A. Securing the parking spot by standing in it B. Turning on your hazard lights C. Confirming the space can fit your
A car has an initial speed of 10 m/s. It then undergoes a constant acceleration of 0.05 m/s^2 over a distance of 5 km. Determine: a) The car final speed. b) The time needed to travel the 5 km.
Where are all the controls on most circuits?
Teresa is emotionally volatile, particularly with friends and boyfriends. She is extremely dramatic about even the smallest disappointments and is sexually and behaviorally very impulsive. Teresa would
Vitrification is a process of: a. Chemical reaction bonding of aggregate ceramic powder b. Cementing aggregate ceramic powder with a liquefied material c. Solid-state diffusion of aggregate ceramic powder
Link Copied!