如何用EXCEL函数化等级分?答:=IF(A1=110,"A★★",lookup(a1,{0,40,50,60,70,75,80,85,90,95,100,105,110},{"J","I","H","G","F","E","D","C","B","A","A★","A★★"}))
excel中怎么把学生成绩转换成等级表示,函数代码要详细,以便自己动手...答:你用一个IF嵌套吧,虽然有点麻烦 这是语文的等级=if(d4<60,3,if(d4<=69,1,if(d4<=79,1,if(d4<=89,6,2)))数学等级=if(h4<60,0,if(h4<=69,3,if(h4<=79,2,if(h4<=89,4,1)))
成绩分等级得问题 excel函数答:那里没成功啊,没看出来啊。=LOOKUP(--C5,{0,60,64,68,72,75,78,82,85,90},{"F","D","C-","C","C+","B-","B","B+","A-","A+"})C5 前加 --