Forum Discussion

Malsawmkima's avatar
Malsawmkima
Copper Contributor
Apr 10, 2021

Preparation of student result

In column X, I want values return as Passed, Simple Passed, Promoted or Failed. Pass criterion (Pass in all subjects) - column C to column G must have scores greater than or equal to 26, column I to ...
excel
Formulas and Functions
office 365
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Apr 10, 2021

Hi Malsawmkima 

As long as I understood your requirement, below formula can be used to achieve desired results:

 

=IF(COUNTIFS(C7:G7,">25")+COUNTIFS(I7:M7,">6")>9,"Passed",IF(COUNTIFS(C7:G7,">25")+COUNTIFS(I7:M7,">6")=9,"Simple Passed",IF(COUNTIFS(C7:G7,">25")+COUNTIFS(I7:M7,">6")=8,"Promoted","Failed")))

For your reference same formula is also updated in the attached revised file.

Please let me know if it works for you

 

Thanks

Tauqeer

  • Malsawmkima's avatar
    Malsawmkima
    Copper Contributor
    Apr 10, 2021

    tauqeeracma 

     

    Thank you for your reply. unfortunately, it didn't work. Perhaps i didn't make it clear. The pass mark for the external exam for each subject is 26 (column c to g) while for internal exam is 7 (column i to m). So, a student must attain pass mark in all subjects both for the external and internal exams to be Passed.

    If a student fails in only one subject overall (either in the external i.e. from column c to g or internal exam i.e. from column i to m), he is to be considered Simple Passed.

    If a student fails in two subjects in the external exam or two subjects in the internal exam or one each from the external and internal exam, but secures a grand total of 165 marks and also securing at least 16 marks in the external exam in each subject and at least 4 marks in the internal exam in each subject will be promoted.

    if above conditions are not met, then, Failed.

     

Resources