I need help with this If function. I keep getting the wrong answer. Im trying to find out if Bella azura is a "first year","sophomore","junior", or "senior"

mmwmunwma L _1_: AG 12 13 14 15 16 17 1B 19 20 21 22 23 24 25 26 27 2B 29 3D 31 32 33 34 35 36 =IF( |ogica|_test , value_if_true , A value_if_fa|se ) a.) Year: =|F( IOEiCI-IUESI , V (using the IF function} VLOOKUP Table Intervals for Left Hand Credits End . oints Class Year 0.. 32 33.. 54 65.. 96 97.. c.) Year: : (using the VLOOKUP function) This spreadsheet has an input cell for the number of credits earned by a student, which determines ifthe student is a rst-year (96) and outputs the correct class year for the credits given. tn} The nested IF function you entered can be replaced with a VLOOKUP function. Fill in the VlOOKUP table, entering the left-hand endpoints for the ranges given, and the appropriate class years. c.) Enter a VLOOKUP function that gives the correct class year for the credits given