G3单元格输入公式,往下拉即可
=IF(AND(SUM(COUNTIF(D3:F3,"S"),COUNTIF(D3:F3,"S+"),COUNTIF(D3:F3,"O"))=3,OR(AND(B3="L2-L4",C2>=2,COUNTIF(D3:F3,"O")>=1),AND(B3="L2-L4",C2>=3),AND(B3="M2-M4",C2>=1.5,F3="O"),AND(B3="M2-M4",C2>=2,COUNTIF(D3:F3,"O")>=1),AND(B3="M2-M4",C2>=3),AND(B3="N1-N4",C2>=1,F3="O"),AND(B3="N1-N4",C2>=2),AND(B3="A1&above",C2>=2,COUNTIF(D3:F3,"O")>=2),AND(B3="A1&above",C2>=3,COUNTIF(D3:F3,"O")>=1))),"yes","no")