1. In cells G6, add a VLOOKUP function that returns the starting raise percentage based on the named range Raise and the number of years employed in column E. Copy the formula through G13.

2. Next, you need to begin determining the employees final raise. In cell H6, create an IF function that will award anyone with a Raise Recommend of "High" in cell F6 the extra bonus listed in cell F2. All other employees get zero bonus. Copy the formula through cell H13. In cell I6, create an IF function that will give anyone with a Raise Recommend of "Low" in cell F6 a deduction listed in cell F3. All other employees get zero deduction. Copy the formula through cell I13.

File Home Insert Page Layout Formulas Data Review View Help 13 =IF(C3="Yes", AVERAGE(D3:H3),AVERAGE(D3:63)) M N Scale 5 = Far Exceeds Expectations 4 = Exceeds Expectations 3 = Meets Expectations 2 = Below Expectations 1 = Well Below Expectations A B D E F G H 1 Confidential Internal Evaluations Customer Team Leadership 2 Name Title Manager Reliable Innovation Service Collaborator Rank Average Raise 3 Meda Rodate Spa Manager Yes 3 4 5 4 4 4 High 4 Christy Istas Therapist No 3 3 3 4 3.25 Standard 5 Jason Niese Massage Therapist No 4 3 4 4 3.75 Standard 6 Paul Medina Coffee Shop Manager Yes 4 5 4 4 5 4.4 High 7 Juanita Gomez Barista No 3 3 5 4 3.75 Standard 8 Susan Brock Gift Shop Manager Yes 4 3 3 3 3 3.2 Low 9 Jay Groth Sales Associate No 4 3 2 2 2.75 Low 10 Kate Munson Sales Associate No 2 4 4 3 3.25 Standard 11 12 Name Manager Raise Recommendations and Notes 13 Meda Rodate High Raise. Very high customer ratings on comment cards. Great at appeasing an upset customer. 14 Christy Istas Standard Raise. Standard employee who works with the team well. 15 Jason Niese Standard Raise. Fills in last minute for other employees and has a large satisfied client following. 16 Paul Medina High Raise. Envisioned and lead a redesign of the Terra Cotta Brew that lead to increased sales. 17 Juanita Gomez Standard Raise. Average employee who has a good rapport with the customers. 18 Susan Brock Low Raise. Average manager who has had some challenging employees. 19 Jay Groth Low Raise. Has received some customer complaints and seems reluctant to get along with other employees. 20 Kate Munson Standard Raise. Good at her job. However, she misses work a lot and never fills in for others who need off. 21 22 23 24 25 26 27 28 29 30 31 32 33 Evaluations Payroll + G6 fix A B D G H J K M N O 1 E Today's Date High Bonus Low Deduct Painted Paradise F 2/21/2021 750 500 Net Payroll Increase Average Raise % 2 $ $ 3 RESORT & SPA 4 Salary $ 71,500 $ 42,100 $ 45,800 $ 35,000 $ 29,900 $ 37,200 $ 28,100 $ 28,700 Years Employed #NUM! 107 108 111 #VALUE! #VALUE! #VALUE! #VALUE! Raise Standard Recommend Raise % High Standard Standard High Standard Low Low Standard Low Final % New High Bonus Deduction Raise Amt Increase Salary #NUM! $ $ $ $ $ $ $ 5 Name HireDate Job Title 6 Meda Rodate 3/14/2010 Spa Manager 7 Christy Istas 8/12/2009 Therapist 8 Jason Niese 8/12/2009 Massage Therapist 9 Paul Medina 2/1/2011 Coffee Shop Manager 10 Juanita Gomez 9/30/2007 Barista 11 Susan Brock 5/15/2010 Gift Shop Manager 12 Jay Groth 3/16/2007 Sales Associate 13 Kate Munson 6/4/2005 Sales Associate 14 Standard 15 Years Employed Raise % 16 0 2.50% 17 2 3.00% 18 5 3.50% 19 7 4.00% 20 21 Raise Count 22 High 23 Standard 24 Low 25 26 Raise Amount Total 27 High 28 Standard 29 Low 30 31 32 Evaluations Payroll Edit