In cell O2 enter a formula using IF function to calculate the maximum amount of 401(k) contributions that the company will match for an employee. The company's 401(k) matching plan is based on an employee's year of service (shown in column M). Use the following parameters and noted reference types when creating tis formula: a). If the employee has a Years Service field value greater than or equal to 15, the Max 401(k) company Match amount is calculated by multiplying the employee's current salary by the value in cell T3 b) If the employee does not have a Years of Service field value greater than or equal to 15, the Max 401(k) Company Match amount is calculated by multiplying the employee's Current Salary by the value in T4. c). Use structured references to the Years Service and current salary fields and absolute references to cells T3 and T4. Note : T3 =7.00% on excel T4 = 4.00%

NZ =IF(M2>20,2,(IF(M2>15,1,0))) R S T P Medical Cost Vision Plan Cost - Variables: 401(k) Matching Plans FT PT 7.00% 4.00% Years service as of: 2014-09-01 1 1 2 3 4 5 6 7 8 9 10 11 12 13 A B Emp ID Last - Name - 1000 Florez 1001 Lane 1002 Edmonds 1003 Caldwell 1004 Crabble 1005 Monis 1006 Pugh 1007 Carter 1008 Fitzgerald 1009 Garrison 1010 Parker 1011 Ralston 1012 Drummon 1013 Yonker N Bonus Week Max 401(k) - Company Mate 2 2 2 2 2 1 1 1 1 1 1 1 1 840 360 540 840 360 540 840 540 840 840 360 840 540 840 840 Medical Plan Family High Family Low None Employee High EmployeeLow Spouse High Spouse Low Monthly Premium $ 1,400 S 900 $ $ 1,000 $ 500 $ 1,200 S 700 1 15 Cance Award