关于excel中if,and和vlookup的嵌套逻辑关系答:对于复杂函数,从外而内,一层层的剥。第一层:IF(AND(E3="",E4=""),"",分支2)意思是,如果E3\E4都为空,那么返回空,否则执行分支2 第二层:第一层的“分支2”=IF(AND(NOT(E3=""),E4=""),VLOOKUP(E3,新进员工培训成绩统计表!A4:L21,12,0),分支2-2)意思是:排除了第一种的...
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,"")))...
if函数怎么和vlookup函数嵌套使用?答:公式:=IF(VLOOKUP(B3,全员一览表!B:AD,25,0)=0,"",VLOOKUP(B3,全员一览表!B:AD,25,0))=IF(COUNTIF(key!B:B,H14)>0,"是","")=IF(COUNTIF(key!B:B,H14)=0,"","是")=IF(COUNTIF(key!B:B,H14),"是","")