I'm in my final year of university and my final grade is calculated by (0.2*second year grade) + (0.8*final year's 90 best credits). I study one course worth 30 credits and 6 courses worth 15 credits each.
My final year's grade can be either made up of two methods; the first is 30-credit course+four best 15 credit courses OR all six 15-credit courses. Say I have an excel spreadsheet where my final grade for all of these courses will be entered.
A1 - 30 credit course grade
A2 - 15 credit course grade
A3 - 15 credit course grade
A7 - 15 credit course grade
Is there a formula that I can use to automatically decide which method should be used and which courses will be included in my final grade depending on the values within the cell?
Edit: added images (apologies for not doing so before, I didn't know it was permissible)
In this link, my spreadsheet is shown. Right now, the yellow cells in column F show my grades for each course I will be doing this year. In the total section, I simply did the average of each course, thinking they all count to my final grade. I now know this isn't true. I am thinking that some form of a MAX function is to be used?