一、成绩等级公式
基础用法：=IF(B2<60,"不合格",IF(B2<75,"及格",IF(B2<90,"良好","优秀")))
进阶用法：=VLOOKUP(B2,{0,"不合格";60,"合格";75,"良好";90,"优秀"},2)
=LOOKUP(B2,{0,60,75,90},{"不合格";"合格";"良好";"优秀"})
=CHOOSE(MATCH(B2,{0,60,75,90},1),"不合格","合格","良好","优秀")
日期：2024-11-10
移动：http://ktsh.xhstdz.com/mobile/quote/69231.html
一、成绩等级公式
基础用法：=IF(B2<60,"不合格",IF(B2<75,"及格",IF(B2<90,"良好","优秀")))
进阶用法：=VLOOKUP(B2,{0,"不合格";60,"合格";75,"良好";90,"优秀"},2)
=LOOKUP(B2,{0,60,75,90},{"不合格";"合格";"良好";"优秀"})
=CHOOSE(MATCH(B2,{0,60,75,90},1),"不合格","合格","良好","优秀")
二、成绩排名
从大到小 =LARGE($B$2:$B$13,{1;2;3;4;5;6;7;8;9;10})
从小到大 =SMALL($B$2:$B$13,{1;2;3;4;5;6;7;8;9;10})
排名 =RANK(B2,$B$2:$B$13)
列出成绩最高人的姓名 =INDEX(A:A,MAX((MAX(B2:B14)=B2:B14)*ROW(B2:B14)))