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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!