用EXCEL求全年级前20%的人数为A等级,再求全年级(除去前面所求的20%的...答:假定A1-A1000为学生成绩,B列为等级ABCDE =if(rank(a$1:a$1000,a1)<=1000*0.45,if(rank(a$1:a$1000,a1)<=1000*0.2,"A","B"),if(rank(a$1:a$1000,a1)> 1000*0.45,if(rank(a$1:a$1000,a1)>=1000*0.9,if(rank(a$1:a$1000,a1)>=1000*0.75,"C","D")),"E"))...
用EXCEL算出学生成绩的ABCDE五等,比例分别是20%;20%;25%;34%;1% 假如...答:0.6,0.8},{"E","D","C","B","A"})向右拉到M2 N2输入=COUNTIF(H2:M2,"A")&"A"&COUNTIF(H2:M2,"B")&"B"&COUNTIF(H2:M2,"C")&"C"&COUNTIF(H2:M2,"D")&"D"&COUNTIF(H2:M2,"E")&"E"然后H-N列下拉到底 H-M列是每科的等级 N列就是你要的结果 希望采纳!
...C,E,G,I,K,M列分别是语,数,外,政,史,地,生的成绩,答:x比较笨的方法:=COUNTIF(A2:N2,"A")&"A"&COUNTIF(A2:N2,"B")&"B"&COUNTIF(A2:N2,"C")&"C"&COUNTIF(A2:N2,"D")&"D"&COUNTIF(A2:N2,"E")&"E"