EXCEL中COUNTIF和OR函数能嵌套使用吗countifor嵌套答:OR嵌套COUNTIF假设查找A列是否有A和B两种数据,如果有则显示1,没有则返回空值=IF(OR(COUNTIF(A:A,\"A\"),COUNTIF(A:A,\"B\")),1,\"\")COUNTIF嵌套OR当A1>1或A2>1时查找A列\"A\"数据的个数,如果A1,A2都不大于1则查找A列\"B\"数据的个数=COUNTIF(A:A,IF(OR(A1>1,A2>1)...
excel中if/or/and函数嵌套答:,"优秀",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"),"差","及格"))...