To be eligible to work with the swim team, an employee must have at least two years of experience or have completed CPR training.
computer science
Description
1.
To be eligible to work with the swim team, an
employee must have at least two years of experience or have completed CPR
training. In cell K3 enter a formula using the IF and OR functions as
follows to determine if Tiffany Adams can work with the swim team:
a.
The IF function should determine if the
employee's Years of Experience is greater
than or equal to 2 OR if the employee's CPR trained status is "Yes", returning the text Yes if an employee meets one or both of
those criteria or the text No if an
employee meets neither of those criteria.
b.
Fill the formula into the range K4:K32, if
necessary.
