在M2中输入=LOOKUP(J2,{0,24,36,48,60},{"不合格","合格","良好","优秀","优异"})假设N为奖金,N2=IF(J2=MAX(J2:J10),25000,LOOKUP(J2,{0,24,36,48,60},{0,2,6,10,20}*1000))
套用工式很简单的！
