Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need the correct functions for these problems please. Dell co obs Ob 10 May Total C 500 1 2 IM A more co SO
I need the correct functions for these problems please.
Dell co obs Ob 10 May Total C 500 1 2 IM A more co SO + 1 > 2 1 $2.000 SAATI NORS 2. SA SH SU ON $ 50 00 50 NOON ES 40 50 50 1 SA 16 VI 14 15 16 7 SOMS NOON O os 50 40 CH 1 2 24 73829328 883 RSRSR88888 VINO 30,00 51.73 SA 11 NO M NO 1 15 DO we 11 30 30 ON ON ON 30 > 32 1 PE 0 su 54 Se SE ho 1 > 2 2 2 2 2 3 1 1 2 2 1 1 IS 18 12 M su 1 WOON NO 4 100 S. SL . R $1,250 $2,50 1 10 BONUS ON 95 2 WOLON VE 06 19 1 VI NOR NOBO ON SA 15 Table 2 Toucher e HR For my dow T Cu tie BONS 0 WIM WA CE SM 11 12 1 1 TE 150 y of By Tallestial may To Te ONS SULES (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 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. 12.5 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. A (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 - "4" to check for less than or equal to" Display "Too Much Time" if the "Hours Worked" on a project exceed the "Estimated Hours" for that project Otherwise, display "Poor Quality": Reuse your formula to complete the column Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started