Years Service Percent Last Day of Year 12/31/2018 10 or more 9% 5 to less than 10 5% less than 5 3% Transpayne Sales Rep Salary Information Employee ID Name Location Title Hire Date Years Employed Salary Bonus Amount Raise 3824 Adams Atlanta Manager 10/14/2007 11 $ 68,750 4955 Akmatalieva Chicago Account Rep 11/3/2018 $ 49,575 2521 Barnes Boston Account Rep 6/14/2014 5 $ 46,000 4453 Crandell Boston Manager 3/9/2009 10 $ 75,800 2967 Deberard Chicago Account Rep 12/4/2014 4 $ 46,795 2645 Doering Atlanta Account Rep 6/5/2014 5 $ 43,750 1268 Forgan Atlanta Account Rep 9/3/2015 3 $ 45,250 4458 Franklin Atlanta Account Rep 7/19/2014 4 $ 47,240 1370 Garbett Atlanta Account Rep 9/18/2014 2 $ 47,835 2848 Gomez Boston Account Rep 10/15/2016 2 $ 46,725 3996 Hartvigsen Boston Account Rep 2/18/2015 4 $ 45,000 4070 Keone Chicago Account Rep 4/3/2015 4 $ 45,125 3099 Laing Chicago Manager 1/17/2011 8 $ 65,500 2698 Lenz Atlanta Account Rep 4/15/2012 7 $ 49,750 2611 Nitz Chicago Account Rep 8/15/2017 1 $ 41,000 1256 Peterson Atlanta Account Rep 11/4/2015 3 $ 45,100 2009 Scholfield Atlanta Account Rep 7/14/2016 2 $ 39,750 4428 Selinger Boston Account Rep 11/8/2016 2 $ 41,525 4545 Terriquez Chicago Account Rep 4/15/2012 7 $ 49,750 1281 Unice Chicago Account Rep 1/31/2014 5 $ 43,750

On this worksheet all functions/formulas must use absolute references where appropriate for full credit.
In range F7:F26 put a formula that will calculate the number of years an employee has worked. Use 364 days in a year when converting the number of days
to the years and only display full years.
In H7:H26 enter a formula to put in the correct bonus amount. The amount is based on the years employeed (column F) and the percentages
authorized by the company in cells I2:I4. The formula must reference the values in cells I2:I4 in case the company changes the authorized %.
Once the raise percentage is determined multiply by the salary to get the whole dollar amount of the bonus.
In I7:I26 enter a formula that calculates the employees raise rounded to the whole dollar. If the employee works in Atlanta or Boston they receive a
3% raise and everyone else recieves a 2.5% raise. The amount of the raise is based on the % specified and the current salary (column G).