longlinh88
Thành viên mới

- Tham gia
- 2/9/09
- Bài viết
- 31
- Được thích
- 1
=IF(Q9="","",IF(AND(Q9>=8,OR(D9>=8,H9>=8),MIN(D9
9)>=6.5),"G",IF(OR(AND(Q9>=8,OR(D9>=8,H9>=8),MIN(D9
9)>=3.5,COUNT(D9:Q9)-COUNTIF(D9
9,">=5")=1),AND(Q9>=6.5,OR(D9>=6.5,H9>=6.5),MIN(D9
9)>=5)),"Kh",IF(OR(AND(Q9>=8,OR(D9>=8,H9>=8),MIN(D9
9)>=3.5,COUNT(D9
9)-COUNTIF(D9
9,">=5")>=2),AND(Q9>=8,OR(D9>=8,H9>=8),MIN(D9
9)>=0,COUNT(D9
9)-COUNTIF(D9
9,">=3.5")=1),AND(Q9>=6.5,OR(D9>=6.5,H9>=6.5),MIN(D9
9)>=2,COUNT(D9
9)-COUNTIF(D9
9,">=3.5")=1),AND(Q9>=5,OR(D9>=5,H9>=5),MIN(D9
9)>=3.5)),"Tb",IF(OR(AND(Q9>=8,OR(D9>=8,H9>=8),MIN(D9
9)>=2,COUNT(D9
9)-COUNTIF(D9
9,">=3.5")>=2),AND(Q9>=6.5,OR(D9>=6.5,H9>=6.5),MIN(D9
9)>=2,COUNT(D9
9)-COUNTIF(D9
9,">=3.5")>=2),AND(Q9>=6.5,OR(D9>=6.5,H9>=6.5),MIN(D9
9)>=0,COUNT(D9
9)-COUNTIF(D9
9,">=2")=1),AND(Q9>=3.5,MIN(D9
9)>=2)),"Y","Kem")))))























