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
6.9k 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
6.8k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

7.4m questions

9.9m answers

Other Questions

A water towers lowest point is 405 ft and the main line is 6 feet below the ground. The ground elevation is at 276 ft. The main line travels 2.9 miles. The pipe will travel through the following flanged
An activated sludge plant is being designed to handle a feed rate of 0.438 m3 /sec. The influent BOD concentration is 150 mg/L and the cell concentration (MLVSS) is 2,200 mg/L. If you wish to operate the
The bulk modulus of a fluid if it undergoes a 1% change in volume when subjected to a pressure change of 10,000 psi is (a) 0.01 psi (b) 0.001 psi (c) 0.00001 psi (d) 0.000001 psi (e) none of these
In solid motors, HTPB and PBAN are two common types of plasticizers. a) True b) False
Where are all the controls on most circuits?
Link Copied!