IF函数嵌套判断。公式=IF(A2>=90,"一等奖",IF(A2>=80,"二等奖",IF(A2>=75,"三等奖","")))
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/30adcbef76094b360d2aec74b1cc7cd98c109deb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
LOOKUP数组判断。公式=IFERROR(LOOKUP(A2,{75,80,90},{"三等奖","二等奖","一等奖"}),"")。特别注意,用lookup函数时,数值要升序排序。分数数组升序排列,{75,80,90},当然,奖项名称要对应排序{"三等奖","二等奖","一等奖"}),而不是{"一等奖","二等奖","三等奖"})。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7e3e6709c93d70cfd0425d94eadcd100bba12beb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述