Excel Formula

Terry-Martins 

Thanks for this, I had no idea about the homework assignment agreement between the regular users of this platform but I appreciate you bringing it to my notice.

I'm glad you appreciate it. For what it's worth, by "regular users" I have in mind a number of us who are among the more active in responding to questions. It's not as though there's a written agreement or "terms of use" that everybody supposedly agrees to. 

But I hope it also makes sense to you AS a student. You're going to learn Excel more through struggling through to an answer than you will if it's presented to you on the proverbial silver platter.

FWIW, your solution works well when the various conditions are limited in number. Now that you've resolved it with the use of some nested IF functions--which can become unmanageable when too many layers deep--you might want to research the IFS function, which helps to a great degree but still has logistical limits. Beyond that, using tables with some of the various LOOKUP functions (as well as INDEX and MATCH) can be very powerful for handling multiple conditions.