IF 函数嵌套判定,排除非数字单元格?答:输入 =IF(OR(COUNTIF(C2:F2,"<500")=4,COUNTIF(C2:F2,"<500")+COUNTIF(C2:F2,"ND")=4),"合格",IF(COUNTIF(C2:F2,">1500")>0,"不合格","疑似"))
Excel会用这些“IFS”结尾的多条件函数答:(注:传统的IF嵌套公式为:“=IF(E2>=12,"优秀",IF(E2>=8,"良好",IF(E2>=5,"合格","不合格")))”,IFS是不是比这个嵌套更清晰明了?)2、COUNTIFS:多条件计数 语法:COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)中文语法:COUNTIFS(条件...