Excel数组公式/多条件公式的如何设置的问题?

2020-05-21 教育 104阅读
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")
声明:你问我答网所有作品(图文、音视频)均由用户自行上传分享,仅供网友学习交流。若您的权利被侵害,请联系fangmu6661024@163.com