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.

Instruction Files

Related Questions in computer science category