File Home Insert Page Layout Formulas Data Review View Tell me what you want to do... fx G Define Name Use in Formula Trace Precedents Show Formulas Trace Dependents Error Checking AutoSum Recently Financial Lagical Text Date & Lookup & Math B Insert Function Name More Create from Selection Used Evaluate Formula Time Reference Trig Functions Manager Remove Arrows Wi Function Library Defined Names Formula Auditing 18 C D E G 1 Criteria: Search Results: Bonus Amount Date Percent 7/31/2012 Hired on or before 7/31/2016 Last Day of Fiscal Year Manager Salary Threshold: $ Hired before 10% 2 7/31/2018 6% 3 85,000 Hired after 7/31/2016 4% 4 Salary Information 5 Years Raise Status Employed Bonus Amount Salary $ 49,575 $ 45,250 $ 47,240 $ 45,000 $ $ Region North Mid-West East Title Hire Date 11/8/2016 Sales Rep Sales Rep Sales Rep Sales Rep Sales Rep Sales Rep 1,661 1.7 41,525 1,983 0.8 10/3/2017 2.715 2.9 9/3/2015 7/19/2014 2,834 East North 4.0 2.700 3.5 2/18/2015 46.000 $ 2.760 8/14/2012 6.0 North 000 Salary Details dy O Ask me anything 0e Point XL. Step 7.1.3. Nest an AND Function Inside an IF Function cell 17, insert a nested function that displays Increase salary to all managers that earn less than $85,000 nd N/A for anyone that does not fit the criteria. opy the function in cell 17 to the range 18 126 File Home Insert Page Layout Formulas Data Review View Tell me what you want to do... fx G Define Name Use in Formula Trace Precedents Show Formulas Trace Dependents Error Checking AutoSum Recently Financial Lagical Text Date & Lookup & Math B Insert Function Name More Create from Selection Used Evaluate Formula Time Reference Trig Functions Manager Remove Arrows Wi Function Library Defined Names Formula Auditing 18 C D E G 1 Criteria: Search Results: Bonus Amount Date Percent 7/31/2012 Hired on or before 7/31/2016 Last Day of Fiscal Year Manager Salary Threshold: $ Hired before 10% 2 7/31/2018 6% 3 85,000 Hired after 7/31/2016 4% 4 Salary Information 5 Years Raise Status Employed Bonus Amount Salary $ 49,575 $ 45,250 $ 47,240 $ 45,000 $ $ Region North Mid-West East Title Hire Date 11/8/2016 Sales Rep Sales Rep Sales Rep Sales Rep Sales Rep Sales Rep 1,661 1.7 41,525 1,983 0.8 10/3/2017 2.715 2.9 9/3/2015 7/19/2014 2,834 East North 4.0 2.700 3.5 2/18/2015 46.000 $ 2.760 8/14/2012 6.0 North 000 Salary Details dy O Ask me anything 0e Point XL. Step 7.1.3. Nest an AND Function Inside an IF Function cell 17, insert a nested function that displays Increase salary to all managers that earn less than $85,000 nd N/A for anyone that does not fit the criteria. opy the function in cell 17 to the range 18 126