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,"优秀",...
excel中if函数的多层嵌套答:亲,完全按照你文字描述写的,逻辑性对不对就没做判断了:=IF(AND(K1=0,L1=0),J1,IF(AND(H1>K1,K1>0,L1=0),K1-H1+I1,IF(AND(K1>H1,L1=0),K1+I1,IF(AND(I1>L1,L1>0,K1=0),L1-I1+K1,IF(AND(L1>I1,K1=0),L1+H1,IF(AND(K1>0,L1>0),K1+L1,"")))...
Excel里if嵌套最多7个,超过7个应该如何设置?答:超过7层嵌套可以通过定义名称的办法来解决。不过根据具体情况也可以换用更合适的公式,像你这种情况,可以用下面的公式:=IF(OR(A1<310,A1>2400),"无合适型号",LOOKUP(A1,{310,451,621,801,1201,1601,2001},"N110A0"&{"0006","1006","2206","3206","4206","5206","6206"}))如果条件更多...
excel解释下嵌套的每个公式的含义=IF(AND(ISERROR(FIND?答:使用下列公式之一 =IF(AND(ISERROR(FIND("哥",A1)),ISERROR(FIND("先生",A1))),"女","男")(说明:在单元格A1中找不到"哥"且找不到"先生",结果为女;否则为男。)或 =IF(AND(ISERROR(FIND("姐",A1)),ISERROR(FIND("女士",A1))),"男","女")或 =if(or(isnumber(find({"哥"...