IF or函数如果否的结果里还用if函数公式答:=IF(OR(A2="张三",A2="李四"),"销售员",IF(OR(A2="王五",A2="赵六"),"厂商",IF(OR(A2="刘琦",A2="楼主"),"中间商","其他")))讲解,if函数格式——=if(A2=0,"零","不是零")加入or函数——=if(or(A2=0,A2="零"),"零","不是零")加入嵌套——=if(or(A2=0...
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"),"差","及格"))...