Question

Create a nested formula that places the word 'yes' into column G for any person who has worked more than 5.0 years for administrators and teachers or over 1,000 days for staff. The formula should place the word 'no' into column G if these criteria are not met.

Answer 1

The nested formula in question uses the IF function combined with OR and AND logical functions to check if an employee meets job-specific criteria regarding years or days worked, and outputs 'yes' or 'no' in column G accordingly.

Step-by-step explanation:

To create a nested formula in a spreadsheet that places 'yes' in column G based on specific conditions for administrators, teachers, and staff, you can use the IF function combined with AND/OR logical functions. Assuming that the job title is in column B, the years worked is in column C, and the days worked is in column D, your formula in column G might look something like this:

=IF(OR(AND(B1="administrator", C1>5), AND(B1="teacher", C1>5), AND(B1="staff", D1>1000)), "yes", "no")

This formula checks if the job title is either administrator or teacher and if they have worked more than 5 years, or if the job title is staff and they have worked more than 1000 days. If either condition is met, 'yes' is placed in column G; otherwise, 'no' is displayed