excel筛选各列数据得对应值答:=IF(AND(OR(COUNTIFS(A1,"*王*")>0,COUNTIFS(A1,"*陈*")>0),B1>0,OR(COUNTIFS(C1,"*赵*")>0,COUNTIFS(C1,"*李*")>0),D1<0,E1=100),"优秀","")在F1中输入以上公式即可实现。
excel表格函数问题,如下图中,怎么设置后面自动弹出NG/OK(根据前面数据...答:=IF(OR(MAX(G3:K3)>F3*1,MIN(G3:K3)<D3*1),"NG","OK")或 =IF(COUNTIFS(G3:K3,"<="&F3,G3:K3,">="&D3)=5,"OK","NG")或 =IF(COUNTIFS(G3:K3,"<="&F3,G3:K3,">="&D3)=COUNT(G3:K3),"OK","NG")...