Question: Use the IF function to complete the Comments column of Table 1 . Display Good Job if both the Hours Worked are less than or
Use the IF function to complete the "Comments" column of Table
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 Note: you can combine "less than" and "equal to operators 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
