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 ...

XIA.xlsx26 KB

excel

Formulas and Functions

office 365

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

XIA_Revised.xlsx26 KB