help! not sure how to enter the formulas

Crain's Consulting Firm Requires a Date Formula "Today" Inputs and Constants Today: 7/17/2014 Years Threshold: 5 High Year Rate: 3.25% Low Year Rate: 2.00% Requires Year Frac Function (2-points) Requires a VLOOKUP (3-points) Rating Rating Bonus Raise New Salary Current Years Date Hired Salary Employed Score 4/1/2004 $ 50,000 10.19 5 7/15/2012 $ 75,250 2.01 3.5 10/31/2008 $ 67,250 5.71 4.2 9/8/2003 $ 45,980 10.86 2 3/14/2011 $ 58,750 1.5 6/18/2010 $ 61,000 4.08 4.5 3.34 Requires Addition (1-point) Requires an IF Statement (3-points) Bonus Data Rating $ Bonus This is a table that is a part of your VLOOKUP (1-point) 100 . 28 R MacBook Air = 6 General ill $ % 9 0 Calibri 26 LA BI U Dab Paste A A A Clipboard Font Alignment fx Krystina Arguello's Consulting Firm B D Conditional Fo Formattingas Table Undo Number A1 E F G Krystina Arguello's Consulting Firm 2 3 Inputs and Constants 4 Today: 10/28/2020 5 Years Threshold: 5 6 High Year Rate: 3.25% 7 Low Year Rate: 2.00% 8 9 Raise New Compensation 10 11 12 13 14 15 16 17 18 19 Years Date Hired Current Salary Employed Rating Score Rating Bonus 4/1/2004 $ 50,000 16.58 5 7/15/2012 $ 75,250 8.29 3.5 10/31/2008 $ 67,250 11.99 4.2 9/8/2003 $ 45,980 17.14 2 3/14/2011 $ 58,750 9.62 1.5 6/18/2010 $ 61,000 10.36 4.5 Bonus Data Salary + 1 Judo Clipboard Font Formatti Alignment 27 Number fx B D E F G D G Raise New Compensatio Years Date Hired Current Salary Employed Rating Score Rating Bonus 4/1/2004 $ 50,000 16.58 5 7/15/2012 $ 75,250 8.29 3.5 10/31/2008 $ 67,250 11.99 4.2 9/8/2003 $ 45,980 17.14 2 3/14/2011 $ 58,750 9.62 1.5 6/18/2010 $ 61,000 10.36 4.5 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Bonus Bonus Data Rating 1 $ 2 $ 3 S 4 $ 5 $ 100 250 500 1,000 Salary + Calculation Mode: Automatic Workbook Statistics 28 MacBook Ai