How to calculate my MBA results?

Skeptical

New Member
Joined
May 26, 2015
Messages
23
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
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Take a look at the HTML Maker link in my sig. It will let you post screen shots so everyone has a better idea of what you're after. External links are fine, but you greatly limit your exposure since many members can't/won't download files from untrusted sources.
 
Upvote 0
FYI - Please don't post the same question multiple times. It just causes everyone to do extra work on your behalf. I have deleted your duplicate threads.
 
Upvote 0
Smitty

This thread & all the posts in it are in the 'Moderated' queues so the OP probably posted again because this one didn't show up to him.
I've left it all as Moderated till you have seen this then you can remove it. :)
 
Upvote 0
FYI - Please don't post the same question multiple times. It just causes everyone to do extra work on your behalf. I have deleted your duplicate threads.
This thread & all the posts in it are in the 'Moderated' queues so the OP probably posted again because this one didn't show up to him.
I've left it all as Moderated till you have seen this then you can remove it.
I have approved all of them. I am guessing that they re-posted the question because they didn't see it because it was Moderated (though they should have been notified when submitting it that it was being Moderated and awaiting approval).
 
Upvote 0
Hi Smitty,

Apologies..My intention is not posting multiple times, but I didn't see it posted and I tried to post it multiple times. At first, I thought they changed the posting functionality.

About posting the screen-shot, It is too big to post as I have 58 columns. I don't know how to accommodate so many columns here. Even from the windows snipping tool we cannot see the entire screen to cut it.

And the reason for the delayed reply is I thought it was not at all posted and I am trying to post it today. Later I have seen the MrExcel post link surprisingly.

I don't see any better idea that this. Please let me know if you still need the screenshot. Thank you so much.
Skeptical
 
Upvote 0
About posting the screen-shot, It is too big to post as I have 58 columns.
Could you make up a smaller dummy file with, say, 15 columns that can still demonstrate the issue you have?

Alternatively, with the HTML maker Smitty mentioned, or others in Section B of the Forum Use Guidelines, you may be able to hide a lot of the columns if they are not vital to demonstrating your issue, then the screen shot won't be as wide.
 
Upvote 0
Hi Peter,

Here is the Screenshot. I have presented the marks for Finance and Marketing specializations. But we have columns for HR as well. In the Col BE I need the result whether Pass or Fail. Downloading the Google drive link will pretty much make you understand easily. I couldn't insert the image as well as I can't see the same after insertion. That's why I have given a link for the same(Screenshot).

https://drive.google.com/open?id=0B-uTVzgsjvZRaXZFc0FXdF94WEU

Hint: Those guys who opted for MH, will study half of the Marketing and HR subjects, obviously.

Please ask me if you need anything.
Skeptical
 
Last edited:
Upvote 0
Here is the actual sample. I did some quick learning on HTML maker which makes the reader's life easier. Thanks for making me understand about how to use this. Thank all.

Excel 2012
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1StudentBranchF1F1F1F2F2F2F3F3F3F4F4F4F5F5F5F6F6F6M1M1M1M2M2M2M3M3M3M4M4M4M5M5M5
2IntExtTotalIntExtTotalIntExtTotalIntExtTotalIntExtTotalIntExtTotalIntExtTotalIntExtTotalIntExtTotalIntExtTotalIntExtTotal
3Stud-1MF416110215557038165400043569916415720244400
4Stud-2MH000000243559403676705212200
5Stud-3F74331074568113333164436410756359140175700000
6Stud-4MH0000004159100552479752510000
7Stud-5MF757414967431103131620005712697531106687314100
8Stud-6MF1518337655131301949000424082705812829709900
9Stud-7MF73691425563118211536000563490585811647206700
10Stud-8MF3744813563981468820005712697531106687314100
11Stud-9H00000000000
12Stud-10M00000037731105714712774101233760632184
13Stud-11FH4277119316394485210000000000
14Stud-12M0000006624907320936647113562076264773
15Stud-13M000000453782415495413778256792751287

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,344
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top