please show all formulas

Insert Draw Home Page Layout Formulas Data >> Tell me Share A. % v El Conditional Formatting Format as Table Cell Styles Paste Font Alignment Number Cells Editing idea F11 vfe B D E F G H 3 Inputs and Constants 4 Today: 5 Years Threshold: 6 High Year Rate: 7 Low Year Rate: 11/1/20 5 3.25% 2.00% 000 New Rating Bonus Raise Compensation Current Date Hired Salary 4/1/04 $ 50,000 7/15/12 $ 75,250 10/31/08 $ 67,250 9/8/03 $ 45,980 3/14/11 $ 58,750 6/18/10 $ 61,000 Years Employed 16.58 8.29 12.00 17.15 9.63 10.37 Rating Score 5 3.5 4.2 2 1.5 4.5 10 11 12 13 14 15 16 17 18 19 20 21 22 23 94 25 26 27 28 29 Bonus Bonus Data Rating 1 S 2 $ 3 $ 4 $ 5 $ 100 250 500 1,000 Salary + Enter Requires your last namel Crain's Consulting Firm Inputs and Constants Requires a Date Formula "Today Today: 7/17/2014 Requires Year Years Threshold: Frac Function Requires a VLOOKUP (3-points) High Year Rate: 3.25% (2.points) Low Year Rate: 2.00% Rating Bonus Raise New Salary Current Years Rating Date Hired Salary Employed Score 4/1/2004 $50,000 110.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 1086 2 3/14/2011 $ 58,750 3.34 1.5 6/18/2010 $ 61,000 4.08 4.5 Requires Addition (1-point) Requires an IF Statement (3-points) Bonus Bonus Data Rating 1 $ 2 $ 3 $ 4 $ 5 $ This is a table that is a part of your VLOOKUP (1-point) 2 100 250 500 1,000 5 Insert Draw Home Page Layout Formulas Data >> Tell me Share A. % v El Conditional Formatting Format as Table Cell Styles Paste Font Alignment Number Cells Editing idea F11 vfe B D E F G H 3 Inputs and Constants 4 Today: 5 Years Threshold: 6 High Year Rate: 7 Low Year Rate: 11/1/20 5 3.25% 2.00% 000 New Rating Bonus Raise Compensation Current Date Hired Salary 4/1/04 $ 50,000 7/15/12 $ 75,250 10/31/08 $ 67,250 9/8/03 $ 45,980 3/14/11 $ 58,750 6/18/10 $ 61,000 Years Employed 16.58 8.29 12.00 17.15 9.63 10.37 Rating Score 5 3.5 4.2 2 1.5 4.5 10 11 12 13 14 15 16 17 18 19 20 21 22 23 94 25 26 27 28 29 Bonus Bonus Data Rating 1 S 2 $ 3 $ 4 $ 5 $ 100 250 500 1,000 Salary + Enter Requires your last namel Crain's Consulting Firm Inputs and Constants Requires a Date Formula "Today Today: 7/17/2014 Requires Year Years Threshold: Frac Function Requires a VLOOKUP (3-points) High Year Rate: 3.25% (2.points) Low Year Rate: 2.00% Rating Bonus Raise New Salary Current Years Rating Date Hired Salary Employed Score 4/1/2004 $50,000 110.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 1086 2 3/14/2011 $ 58,750 3.34 1.5 6/18/2010 $ 61,000 4.08 4.5 Requires Addition (1-point) Requires an IF Statement (3-points) Bonus Bonus Data Rating 1 $ 2 $ 3 $ 4 $ 5 $ This is a table that is a part of your VLOOKUP (1-point) 2 100 250 500 1,000 5