Question

excel中if/or/and函数嵌套

计算每门成绩都在80分以上（包括80分）的为优秀，有一门不及格的为差，其他为及格
57 69 52 76

我只想到这样：=if((IF(OR(C14<60,D14<60,E14<60,F14<60),"不及格”，“及格”),if(AND(C14>80,D14>80,E14>80,F14>80),"优秀","及格")))

不过是错误的。。请高手帮帮忙..搞不清之间怎么配合起来...请用if/or/and这三个函数完成

Answer 1

=IF(AND(C14>=80,D14>=80,E14>=80,F14>=80),"优秀",IF(OR(C14<60,D14<60,E14<60,F14<60),"差","及格"))

=IF(OR(C14<60,D14<60,E14<60,F14<60),"差",IF(AND(C14>=80,D14>=80,E14>=80,F14>=80),"优秀","及格"))

=IF(COUNTIF(C14:F14,">=80")=4,"优秀",IF(COUNTIF(C14:F14,"<60"),"差","及格"))

Answer 2

=IF(AND(A2>=80,B2>=80,C2>=80,D2>=80),"优秀",IF(OR(A2<60,B2<60,C2<60,D2<60),"差","及格")).总if函数当4门都>=80时就为优秀，后面镶契的IF函数就是前面函数的一种结果意思就是“及格或差”的意思了。然后需用ifOr函数把“及格和差”分别表达出来。

Answer 3

=IF(COUNTIF(C14:F14,">=80")=4,"优秀",IF(COUNTIF(C14:F14,"<60")=0,"及格","差"))

=IF(AND(C14>=80,D14>=80,E14>=80,F14>=80),"优秀",IF(AND(C14>=60,D14>=60,E14>=60,F14>=60),"及格","差"))