brrq.net
当前位置:首页 >> ExCEl表格中如何将分数转化为对应定级 >>

ExCEl表格中如何将分数转化为对应定级

比如,你要在A2-H8单元格输入具体分值,则,在D2单元格输入公式: =LOOKUP(A$2,{60,70,80,85,90,95,100},{"D","C2","C1","B2","B1","A2","A1"}) 然后右拉。

网站首页 | 网站地图
All rights reserved Powered by www.brrq.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com