Question

如何用excel表格计算学生成绩后30%的及格率和优秀率，急求解！

Answer 1

假设B列是学百生度成绩，60分及格知，90分优秀道
及格率=IF(ROUND(COUNT(B:B)*0.3,)-COUNTIF(B:B,"并谨<60")>0,(ROUND(COUNT(B:B)*0.3,)-COUNTIF(B:B,"<大茄60"))/ROUND(COUNT(B:B)*0.3,),1)
优绝仿基秀率
=IF(ROUND(COUNT(B:B)*0.3,)-COUNTIF(B:B,"<90")>0,(ROUND(COUNT(B:B)*0.3,)-COUNTIF(B:B,"<90"))/ROUND(COUNT(B:B)*0.3,),0)

Answer 2

假设B列从第2行开始是学生成绩，则
及格率
=TEXT(SUMPRODUCT(N(SMALL(B:B,ROW(INDIRECT("1:"&ROUND((COUNTA(B:B)-1)*30%,0))))>源粗尘59))/(ROUND((COUNTA(B:B)-1)*30%,0)),"雹禅#%")
优秀率
=TEXT(SUMPRODUCT(N(SMALL(B:B,ROW(INDIRECT("1:"凳知&ROUND((COUNTA(B:B)-1)*30%,0))))>89))/(ROUND((COUNTA(B:B)-1)*30%,0)),"#%")

Answer 3

假设B列是学生成绩，60分及格，90分优秀
及耐裤格率=IF(ROUND(COUNT(B:B)*0.3,)-COUNTIF(B:B,"<60")>0,(ROUND(COUNT(B:B)*0.3,)-COUNTIF(B:B,"高埋<60"))/ROUND(COUNT(B:B)*0.3,),1)
优昌念简秀率
=IF(ROUND(COUNT(B:B)*0.3,)-COUNTIF(B:B,"<90")>0,(ROUND(COUNT(B:B)*0.3,)-COUNTIF(B:B,"<90"))/ROUND(COUNT(B:B)*0.3,),0)

Answer 4

30%的及格率和优秀率？
楼主的意思是所有学生只能有30%及格，30%的学生是优秀，是这个意思吗？如果是的话，楼扮腔主可以先用排列把所有的学生哗缺兄按从高分到低分排列，然后算出所有学生的30%是多少人，接着从高乱袭到低选出30%的学生作为及格学生，优秀学生以此类推。

Answer 5

亲！
加我562867732，尽量帮你解决