第1个回答 2022-05-06
=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")
第5个回答 2022-05-06
L3=IF(OR(MAX(G3:K3)>F3,MIN(G3:K3)<D3),"NG","OK")