Info
Cách tính học lực "IF(S9="""","""",IF(AND(S9>=8,MIN(E9:R9)>6.4,OR(E9>=8,J9>=8)),`HUONG DAN+DIEN THONG TIN`!$E$17,IF(OR(AND(S9>=8,MIN(E9:R9)>3.4,OR(E9>=8,J9>=8),COUNT(E9:R9)-COUNTIF(E9:R9,"">6.4"")=1,COUNTIF(E9:R9,""=6.5,MIN(E9:R9)>4.9,OR(E9>=6.5,J9>=6.5))),`HUONG DAN+DIEN THONG TIN`!$E$18,IF(OR(AND(S9>6.4,MIN(E9:R9)>1.9,OR(E9>6.4,J9>6.4),COUNT(E9:R9)-COUNTIF(E9:R9,"">=5"")=1,COUNTIF(E9:R9,""=8,OR(E9>=8,J9>=8),COUNT(E9:R9)-COUNTIF(E9:R9,"">=6.5"")=1,COUNTIF(E9:R9,""=5,MIN(E9:R9)>3.4,OR(E9>=5,J9>=5))),`HUONG DAN+DIEN THONG TIN`!$E$19,IF(OR(AND(S9>=8,OR(E9>=8,J9>=8),COUNT(E9:R9)-COUNTIF(E9:R9,"">=5"")=2,MIN(E9:R9)>=2),AND(S9>6.4,OR(E9>6.4,J9>6.4),COUNT(E9:R9)-COUNTIF(E9:R9,"">=5"")=1,COUNTIF(E9:R9,""4.9,OR(E9>4.9,J9>4.9),COUNT(E9:R9)-COUNTIF(E9:R9,"">=3.5"")=1,COUNTIF(E9:R9,""3.4,MIN(E9:R9)>1.9)),`HUONG DAN+DIEN THONG TIN`!$E$20,`HUONG DAN+DIEN THONG TIN`!$E$21)))))" Đang dở BB V/TCách tính TB môn "IF(OR(E9="""",J9=""""),"""",IF(`GVCN - DSACH HS`!G9=""A"",ROUND((SUM(E9:R9)+SUM(E9:G9))/(COUNT(E9:R9)+COUNT(E9:G9)),1),IF(`GVCN - DSACH HS`!G9=""C"",ROUND((SUM(E9:R9)+SUM(J9:L9))/(COUNT(E9:R9)+COUNT(J9:L9)),1),IF(`GVCN - DSACH HS`!G9=""TN"",ROUND((SUM(E9:R9)+SUM(E9:H9))/(COUNT(E9:R9)+COUNT(E9:H9)),1),IF(`GVCN - DSACH HS`!G9=""XH"",ROUND((SUM(E9:R9)+SUM(J9:M9))/(COUNT(E9:R9)+COUNT(J9:M9)),1),IF(`GVCN - DSACH HS`!G9=""CB"",ROUND((SUM(E9:R9)+E9+J9)/(COUNT(E9:R9)+COUNT(E9)+COUNT(J9)),1),""""))))))" "IF(OR(D4="""",H4=""""),"""",IF(AND(DSHS!H$1=""TN"",LEFT(DSHS!F$1)=""1""),ROUND((SUM(D4:Q4)+SUM(D4:G4))/(COUNT(D4:Q4)+COUNT(D4:G4)),1),IF(AND(DSHS!H$1=""XH"",LEFT(DSHS!F$1)=""1""),ROUND((SUM(D4:Q4)+SUM(H4:K4))/(COUNT(D4:Q4)+COUNT(H4:K4)),1),IF(OR(AND(DSHS!H$1=""CB"",LEFT(DSHS!F$1)=""1""),AND(DSHS!H$1="""",OR(LEFT(DSHS!F$1)=""6"",LEFT(DSHS!F$1)=""7"",LEFT(DSHS!F$1)=""8"",LEFT(DSHS!F$1)=""9""))),ROUND((SUM(D4:Q4)+D4+H4)/(COUNT(D4:Q4)+COUNT(D4)+COUNT(H4)),1),""""))))"...
