IF嵌套函数问题答:5""——后面的""——多余的,数值不能直接加上空值;就即能加上空值,数值便成了文本,不能用于大小比较。嵌套函数——引用文本因套上双引号。所有符号都要用半角。=IF(AND(DAY(NOW()-DAY(A4))>5),"嵌套函数",IF(E9=1,1,IF(E9=2,2,IF(E9=3,3,IF(E9=4,4,"")))【不知道是不是...
excel中if/or/and函数嵌套答:=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,"优秀",...