View Define Name - Trace Precedents 1 Use in Formula Trace Dependents " e Watch Calculation ger Create from Selection Remove Arrows Window Options Defined Names Formula Auditing Calculation E Search Results: Last Day of Fiscal Year: Manager Salary Threshold: $ G H Bonus Amount Date Percent 7/31/2018 Hired before 7/31/2012 10 85,000 Hired on or before 7/31/2016 Hired after 7/31/2016 nformation Years Raise In cell 17, insert a nested function that displays Increase salary to all managers that earn less than $85,000 and N/A for anyone that does not fit the criteria. Copy the function in cell 17 to the range 126 Hire Date Employed Salary Bonus Amount Status P 11/8/2016 1.7 ep 10/3/2017 0.8 9/3/2015 2.9 Lep 7/19/2014 4.0 5555 41,525 $ 1.661 49.575 $ 1.983 45.250 $ 2.715 47.240 $ 2.834 Rep 2/18/2015 3.5 $ 45,000 $ 2.700 Rep 8/14/2012 6.0 ole $ 46.000 $ 2.760 Rep 4/15/2018 0.3 $ 49.750 $ 1.990 Rep 9/18/2014 3.9 $ 47,835 $ 2.870 es Rep 11/4/2015 2.7 $ 45,100 $ 2.706 es Rep 4/3/2015 3.3 $ anager 1/17/2009 9.5 Pan 10/15/2016 1.8 555 45.125 $ 2.708 < 3 of 12 > $ 80.500 $ 8.050 46.725 $ 1.869 Attempts Remaining: 3 1.0 $ 41,000 $ 1,640 1070 View All C Reset