Question: "use an if function to add or subtract the amounts in I22 and I23 depending on how well the student did on their homework =IF()"

A B C F G H K 1 2 DE Dr. Brown's Celebrity Class Semester Average Letter Grade Homework Good Poor 3 Last Name First Name 4 Duck, Donald Duck 5 Hart, Kevin Hart 6 Williams, Serena Williams 7 Winfrey, Oprah Winfrey 8 Rock, The Rock 9 Skywalker, Luke Skywalker 10 Clinton, Hillary Clinton 11 Lawrence, Martin Lawrence 12 Smith, Will Smith 13 Barker, Bob Barker 14 Freeman, Morgan Freeman 15 Roberts, Julia Roberts 16 James, Lebron James 17 Sandler, Adam Sandler 18 Average Score 19 Highest Score 20 Lowest Score 21 22 23 Test Test 1 Test 2 Test 3 Test 4 Average Donald 71 70 84 75.00 Kevin 98 97 90 95.00 Serena 81 70 78 76.33 Oprah 65 65 60 63.33 The 95 79 80 84.67 Luke 90 90 70 83.33 Hillary 50 95 79 74.67 Martin 70 65 95 76.67 Will 90 80 0 56.67 Bob 78 62 77 72.33 Morgan 88 95 78 87.00 Julia 92 86 84 87.33 Lebron 78 65 82 75.00 Adam 50 65 80 65.00 Good Good Poor Good Good Good Poor Good Good Good Poor Poor -5 Poor Good 5 24 Semester Average = Test Average + Homework grade (see chart below for Poor and Good scores) (1)