如何在excel根扰学生名次变成获奖等次答:如果名次在D列,那么在E2单元格输入以下公式,并向下填充公式 =IF(D2<=1,"特等奖",IF(D2<=3,"一等奖",IF(D2<=5,"二等奖",IF(D2<=10,"三等奖","")))或者 =LOOKUP(D2,{1,2,4,6,11},{"特等奖","一等奖","二等奖","三等奖",""})
excel中用函数求等次答:在T3输入公式:=IF(R3>=86.356,"高级三",IF(R3>=81.972,"中级一",IF(R3>=77.588,"中级二",IF(R3>=73.204,"中级三",IF(R3>=68.82,"初级一","")))然后往下复制。