Unde 18 A Opboard Input Area 6 Name 7. Bacarella 8 Gnther 9 Chen 10 Laing...

Transcribed Image Text:

Unde 18 A Opboard Input Area 6 Name 7. Bacarella 8 Günther 9 Chen 10 Laing 11 Garbett 12 Gomez 13 Hartvigsen 14 Ikenberry 15 Keone city 2KC Mostly doily Algumant fx-15(E8<152,18*K$2,8153,18 K$3,EB<K$4,18 KS4,TRUE,O Regions South FOM Midwest Northeast Region South Midwest Northeast South South D Atlanta Chicago Boston Atlanta Atlanta Boston Northeast Boston Northeast Cleveland Midwest Chicaro Midwest Account Reo 1-Date Logic 2-Stats Map 3-Finance Title Manager Account Rep Manager Account Rep Account Rep Account Rep Account Rep Account Rep Hire Date 10/18/2010 11/7/2023 3/9/2023 12/14/2012 9/18/2014 10/11/2016 2/18/2023 4/17/2018 4/3/2020 Number Comparison Data Last Day of Year 12/31/2024 Minimum Manager Salary $ 98,000 Year Hired 2010 2023 2023 2012 2014 2016 2023 2018 2020 G Search H Day of Week Hired Years Employed 14.2 Monday 1.2 Tuesday 1.8 Thursday 12.0 Friday 10.3 8.2 1.9 6.7 Thursday Tuesday Saturday Tuesday Friday 4.7 Bonus Decision Hired before Hired before Hired before S $ $ $ $ 5 $ $ C Salary Date 1/1/2013 1/1/2018 1/1/2023 Bonus Amount 7,900 98,750 5 69,575 5 85,800 $ 98,000 $ 77,835 $ 66,725 $ 75,000 $ 65,125 $ 65.125 7,840 3,113 2,649 Percent 8% 4% 2% Type here to search 1 Point XL Step 7.1.5. Nestan AND Function within an Function Go to cell K7 and insert an IF function with a nested AND function to display Due for raise for all managers who earn a salary. of less than the Minimum Manager Salary located in cell G3 (use a mixed cell reference), and N/A for anyone who does not fit the criteria. Raise Status M N ✪ Leaming Aids 5 of 14 Unde 18 A Opboard Input Area 6 Name 7. Bacarella 8 Günther 9 Chen 10 Laing 11 Garbett 12 Gomez 13 Hartvigsen 14 Ikenberry 15 Keone city 2KC Mostly doily Algumant fx-15(E8<152,18*K$2,8153,18 K$3,EB<K$4,18 KS4,TRUE,O Regions South FOM Midwest Northeast Region South Midwest Northeast South South D Atlanta Chicago Boston Atlanta Atlanta Boston Northeast Boston Northeast Cleveland Midwest Chicaro Midwest Account Reo 1-Date Logic 2-Stats Map 3-Finance Title Manager Account Rep Manager Account Rep Account Rep Account Rep Account Rep Account Rep Hire Date 10/18/2010 11/7/2023 3/9/2023 12/14/2012 9/18/2014 10/11/2016 2/18/2023 4/17/2018 4/3/2020 Number Comparison Data Last Day of Year 12/31/2024 Minimum Manager Salary $ 98,000 Year Hired 2010 2023 2023 2012 2014 2016 2023 2018 2020 G Search H Day of Week Hired Years Employed 14.2 Monday 1.2 Tuesday 1.8 Thursday 12.0 Friday 10.3 8.2 1.9 6.7 Thursday Tuesday Saturday Tuesday Friday 4.7 Bonus Decision Hired before Hired before Hired before S $ $ $ $ 5 $ $ C Salary Date 1/1/2013 1/1/2018 1/1/2023 Bonus Amount 7,900 98,750 5 69,575 5 85,800 $ 98,000 $ 77,835 $ 66,725 $ 75,000 $ 65,125 $ 65.125 7,840 3,113 2,649 Percent 8% 4% 2% Type here to search 1 Point XL Step 7.1.5. Nestan AND Function within an Function Go to cell K7 and insert an IF function with a nested AND function to display Due for raise for all managers who earn a salary. of less than the Minimum Manager Salary located in cell G3 (use a mixed cell reference), and N/A for anyone who does not fit the criteria. Raise Status M N ✪ Leaming Aids 5 of 14

Answer rating: 100% (QA)

It appears that you want to insert an IF function with a nested AND function ... View the full answer