=IF(Q9="","",IF(AND(Q9>=80,COUNTIF(D9
9,">64")=COUNT(D9
9),OR(D9>=80,I9>=80)),"GIỎI",IF(OR(AND(Q9>=80,COUNTIF(D9
9,">34")=COUNT(D9
9),OR(D9>=80,I9>=80),COUNT(D9
9)-COUNTIF(D9
9,">64")=1,COUNT(D9
9)-COUNTIF(D9
9,">49")=1),AND(Q9>=65,COUNTIF(D9
9,">49")=COUNT(D9
9),OR(D9>=65,I9>=65))),"KHÁ",IF(OR(AND(Q9>64,COUNTIF(D9
9,">19")=COUNT(D9
9),OR(D9>64,I9>64),COUNT(D9
9)-COUNTIF(D9
9,">49")=1,COUNT(D9
9)-COUNTIF(D9
9,">34")=1),AND(Q9>=80,OR(D9>=80,I9>=80),COUNT(D9
9)-COUNTIF(D9
9,">64")=1,COUNT(D9
9)-COUNTIF(D9
9,">34")=1),AND(Q9>=50,COUNTIF(D9
9,">34")=COUNT(D9
9),OR(D9>=50,I9>=50))),"TB",IF(OR(AND(Q9>=80,OR(D9>=80,I9>=80),COUNT(D9
9)-COUNTIF(D9
9,">=5")=2,COUNTIF(D9
9,">19")=COUNT(D9
9)),AND(Q9>64,OR(D9>64,I9>64),COUNT(D9
9)-COUNTIF(D9
9,">=50")=1,COUNT(D9
9)-COUNTIF(D9
9,">19")=1),AND(Q9>34,COUNTIF(D9
9,">19")=COUNT(D9
9))),"YẾU","KÉM")))))