在EXCEL中,用IF ,怎么样表示答:=IF(A1>=90,"优",IF(A1>=80,"良",IF(A1>=70,"中",IF(A1>=60,"及格","不及格")))
...例如;想处理一组数据 如果分数小于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),"良",))...