用EXCEL算出学生六科成绩的ABCDE五等答:设学生六科成绩总分在J列从J2到J1001,则学生等级分类在K2到K1001,等级计分在L2到L1001,则请在K2输入公式:=LOOKUP(RANK(J2,$J$2:$J$1001,0),{1,201,401,701,991;"A","B","C","D","E"})请在L2输入公式:=LOOKUP(RANK(J2,$J$2:$J$1001,0),{1,201,401,701,991;10,9,...
用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列就是你要的结果 希望采纳!