Question: The Evaluations worksheet includes evaluation data collated from various managers. Managers rated employees both quantitatively-numerically-and qualitatively-written notes. The number scores and notes support the raise

 The Evaluations worksheet includes evaluation data collated from various managers. Managers

The Evaluations worksheet includes evaluation data collated from various managers. Managers rated employees both quantitatively-numerically-and qualitatively-written notes. The number scores and notes support the raise recommendation made by the manager. Add the following In cells 13:110, create an IF function to calculate the average numerical ratings for each employee. Only managers get evaluated by the Leadership rank in column H. Column C indicates whether the employee is a manager. Thus, the average calculation should only include the values in column H if the employee is a manager. Even if a rating is given to a non- manager employee in column H, that number should not be included in the average in column

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!