21. For the data above, use a compound if to give job rating 4 or 5 and 10 or more years of service a bonus of 4000

22. Create a compound IF statement for the following data set: If the grade is B+ or better and have more than 20 credits, then Honor Role

4 Employee Nai Building Department Hire Date Years Benefits Salary Job Rating Bonus Answer 2 Bonus Answer 3 Bon 5 Page, Lisa West ADC 24-Dec-01 18 DMR 60,981 1 6 Taylor, Hector West ADC 3-Feb-14 6 DM 60,915 4 3,500 7 Dawson, Jona West ADC 16-Feb-10 10 97,071 5 3,500 8 Duran, Brian Taft ADC 13-Aug-15 5 115,421 3 2,000 9 Weber, Larry Watson ADC 13-Dec-10 9 M 115,547 4 3,500 10 Pratt, Erik North Training 16-Jan-09 11 DMR 69,212 2 500 11 O'Connor, Ker Taft Training 8-Feb-02 18 DMR 120,198 1 12 Spencer, Boyc Main Training 30-Mar-10 10 107,635 5 3,500 13 Wiggins, Fran North Training 23-Mar-02 18 DMR 113,020 1 14 15 16 21. For the data above, use a compound if to give job rating 4 or 5 and 10 or more years of service a bonus of 4000. 17 22. Using IFS to give people with a job rating of 4 or 5 $3500 bonus, a job rating of 3 $2000 bonus, and a job rating of 2 a $500. bonus. 18