need these functions please!
G H M O Employee Wage Information Jun Jill $52 $50 Jake $47 Jennifer S48 Bonus information Time 10% Outcome 10% Comments 5 Table 1. Painting Projects 2 Hours Worked Hourly Ware Difficulty Quality Time Bonus? Outcome Bonds? lob Pay Time Bonus $ Outcome Bonus 54 $52 3 3 NO BONUS YES $2,308 $0 9 40 550 5 2 NO BONUS YES $2.000 10 $0 36 $52 4 NO BONUS YES $4.472 SO 11 1 2 NO BONUS NO $1,974 90 12 78 $52 1 NO BONUS NO $4,056 SO 13 18 $ 3 BONUS YES $1,75 10% 14 51 $ 3 3 NO BONUS YES 52,052 35 36 SAB 3 1 NO BONUS NO $1,7211 16 $52 1 2 BONUS NO $2,496 17 12 $50 2 2 NO BONUS NO $3,100 11 24 47 2 1 NO BONUS NO $1,471 10 51 2 1 NO BONUS NO 52.441 20 540 2 1 NO BONUS NO 53,300 23 $42 2 2 BONUS NO $2,724 ION 22 547 1 BONUS YES $1,100 10 1 NO BONUS NO 52,400 34 SA 1 2 BONUS NO $2,256 10 $ 2 3 NO BONUS YES 53.250 26 61 2 3 NO BONUS YES $1.050 22 29 S41 1 NO BONUS NO 53.2 28 20 Table - Employee Summary 10 Employee of Jobs Total Hous Total Pay of Touchups Cost Touchups Average Cost/lob 31 Cost 12 3400 $100 DIV/01 1 5600 Baka $250 DIV/01 1 Saoo 14 $300 Jennifer DIV/0! 4 $2.100 NOIV/0! 39 393 Re 5538533338388 && $8888888 Total Pay $2,808 $2.000 $1,472 $1,974 $4,056 $1,786 $2,652 $1,728 $2.456 $2,100 S3,478 $2.450 53,360 $2,720 $9,102 52.400 $9.250 $3,250 $3,050 53.792 True Cost/Hour NDIV/01 DIV/ MDIV/01 DIVO: Difficulty of Jobs Total Pay $9.91 Spending Amortation Table - Prolet Summary by Difficulty it of Touchupa Cost Touchups Total Cost $9.91 Average Cont/ob Averace Hour/lob $2.46 sting Google (2.2) Use the AND function to complete the "Time Bonus?" column of Table 1. An employee earns a time bonus if the "Hours Worked" on a project are less than the "Estimated Hours" for that project as long as the work "Quality" is also greater than 1. Reuse your formula to complete the column. 12.5 A (2.3) Use the OR function to complete the "Outcome Bonus?" column of Table 1. An employee earns an outcome bonus if the difficulty of a job is greater than 3 or the quality of their work is equal to 3. Reuse your formula to complete the column. 2.4 Use the IF function to complete the "Time Bonus $" column of Table 1. If an employee earns a time bonus (the corresponding cell in the "Time Bonus?" column is TRUE), then "Time Bonus $" is the "Job Pay" for that project times the bonus percentage in cell M3) Otherwise "Time Bonus $is 0. Reuse your formula to complete the column. 10 2.5 Use the IF function to complete the "Outcome Bonus $" column of Table 1 If an employee earns an outcome bonus (the corresponding cell in the "Outcome Bonus?" column is TRUE), then "Outcome Bonus $" is the "Job Pay" for that project times the outcome bonus percentage in cell M4 . Otherwise "Outcome Bonus $" is 0. Reuse your formula to complete the column. (2.6) Use the IF function to complete the "Comments" column of Table 1. Display "Good Job" if both the "Hours Worked" are less than or equal to the "Estimated Hours" for a project and the assessed "Quality" of that project is greater than 1. Note: you can combine "less than" and "equal to" operators - "
