Please show how to do excel formulas for each section. Including the YEARFRAC, VLOOKUP, IF statement.

s and Constants Threshold: 5 Year Rate: 3.25% Year Rate: 2.00% te Hired Current Years Rating Rating New Salary Employed Score Bonus Raise Compensation 4/1/04 50,000 5 7/15/12 75,250 3.5 10/31/08 67,250 4.2 9/8/03 45,980 2 3/14/11 58,750 1.5 6/18/10 61,000 4.5 Bonus Data Rating Bonus 0 W N 100 250 500 1,000