I need help with this "If" function. I keep getting the wrong answer. I'm quite stuck can someone please explain to me what to put down and why ... I'm trying to find out if Bella azura is a "first year", "sophomore", "junior", or "senior"

=IF(logical expression, value if true, value if false)

In cell ca, use the nested IF function to determine the class year for the Credits in Cell Cl " Note : Use " First-year" Sophomore"Junior ", and " senior " as class years in the arguments of the IF functions In cells D13: 016, enter the left- hand endpoints for the ranges given In cells (3: C16. In cells E13: Elle, enter the class years Corresponding to the ranges given In Calls (13: Cle 11 In Cell C20, use the VLOOKUP function to determine the class year for the Credits given in cell CleDm'e-JONU'l-lh-WNF ' _l_l do =|F( logical_test , value_if_true , A value_if_fa|se ) Last First Student: ram- 3.) Year: =|F( logicaLteSt . V [using the IF function) VLOOKUP Table Intervals for Left Hand Credits End - oints Class Year 0.. 32 33.. 64 65.. 96 97.. c.) Year: E (using the VLOOKUP function) This spreadsheet has an input cell for the number of credits earned by a student, which determines if the student is a rst-year ( 96). .1.) Enter an IF function that tests if a student is a rst-year (c: 32), then sophomore (c: 64), then junior [96) and outputs the correct class year for the credits given. 1).) 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