=HLOOKUP(A1,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16;"1等奖","1等奖","1等奖","2等奖","2等奖","2等奖","3等奖","3等奖","3等奖","3等奖","3等奖","3等奖","3等奖","4等奖","4等奖","4等奖"},2,0)
当A1为名次时，根据实际修改
假设A列为名次，B列为奖学金等级，则B1公式如下
=IF(A1<=3,"一等奖",IF(A1<=6,"二等奖", IF(A1<=13,"三等奖",IF(A1>13,"四等奖"))))
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024