How to calculate my MBA results?

[Skeptical]

Hi everybody at MrExcel,

We are from a university. We have SIX specializations,

Specializations------Codes

Finance ----- F,
Marketing ----M,
HR ----H,
Finance with Marketing ----FM
Finance with HR----FH
HR with Marketing------HM

We have six subjects in each combination i.e.

Combination---Subjects

F--------F1,F2,F3,F4,F5,F6
H------------H1,H2,H3,H4,H5,H6
M------M1,M2,M3,M4,M5,M6
FM----------F1,F2,F3,M1,M2,M3
HM----------H1,H2,H3,M1,M2,M3
FH------------F1,F2,F3,H1,H2,H3

Total marks 150*6 subjects=900

Result Conditions:
In each subject, student should score>=75 marks in Total for a Pass
The marks in External should be >= 40 marks
The marks in Internal should be >= 25 marks
Awarding of Class: 50% - 60% is Second Class 60% - 70% is First class >= 70% is FCD (First Class with Distinction) <tbody> </tbody>

<tbody>
</tbody>

I have Results column and Class column, What formula should be used there to get my results calculated?
I have tried with so many IFs but that is so inefficient, I request humbly everybody please help me on this.

I have attached a sample workbook here .

Thank you very much
Skeptical

 

[Peter_SSs]

Peter,

This is working fine. I made it to work for 6 subjects and taken care of that R1 part. I tried with different marks combinations. Its working like a Gun. Thank you so much, Peter. At last you have achieved it. You're the man.
Skeptical

Good news! Sounds like we have the Pass/Fail sorted, so now ..

Once we get the Pass/Fail sorted, you will need to clarify further about the Grade with examples & explanation of the examples.

 

[Skeptical]

Thanks Peter, I have calculated the Grades. If I encounter anything we will see that later. Good for now.

 

[Peter_SSs]

Thanks Peter, I have calculated the Grades. If I encounter anything we will see that later. Good for now.

OK. Great.