85问答库 > 在Excle中如何用if函数进行奖学金等级分类？下面这个…1-3名为一等奖，4-6名为二等奖，7-1

在Excle中如何用if函数进行奖学金等级分类？下面这个…1-3名为一等奖，4-6名为二等奖，7-1

2024-11-01 11:29:08

推荐回答（2个）

回答1：

=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为名次时，根据实际修改

回答2：

假设A列为名次，B列为奖学金等级，则B1公式如下
=IF(A1<=3,"一等奖",IF(A1<=6,"二等奖", IF(A1<=13,"三等奖",IF(A1>13,"四等奖"))))