...85分”及格“,60分以下“不及格”,怎么引用IF函数? 谢谢,急找答案...答:假设数据存放在A1单元格中:=IF(A1>85,"优秀",IF(A1>=60,"及格","不及格")) 如果楼主想先判断A1中是否有数值则可以改一下公式:=IF(A1,IF(A1>85,"优秀",IF(A1>=60,"及格","不及格")),"") 本回答由提问者推荐 举报| 答案纠错 | 评论(2) 11 4 metoome123 采纳率:55% 来自团队:EXCEL帮帮...
...想处理一组数据 如果分数小于60就备注为不及格答:=IF(A1="","",LOOKUP(A1,{60,70,80,90,100;"及格","良","优-","优+","棒极了"}))用这个方便,if有局限性,最多7层,如果要判断很多呢?if就不行了,还要配合其他函数才行,看上去罗嗦了,=IF(AND(A1>=60,A1<70),"及格",IF(AND(A1>=70,A1<80),"良",))...