Question: In cell B6, enter a function that will count the number of lessons for the Student ID in cell B2. In cell B7, enter a
In cell B6, enter a function that will count the number of lessons for the Student ID in cell B2. In cell B7, enter a function that will sum all the lessons for the Student ID in cell B2. Students at Fiddlers can start earning free lessons once they have taken more than 5. In cell B8, enter an IFS function to return 0 earned if the Total Lessons in cell B6 is less than 5, return 1 earned if the Total Lessons is less than 10, otherwise return 2 earned. Hint: While the value in B8 could also be calculated using a nested if, use the IFS function unless you are using an older version of Excel (prior to 2016) because IFS is easier to use than a nested IF.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
