if(or(and(A1="是",B1="完成"),and(A1="否",inarray(B1,ARRAY("未完不考核","未完考核","未完延期考核"))>0)),true,false)
参考公式实现下拉框参数联动-https://help.fanruan.com/finereport/doc-view-3634.html
WorkBook1.zip
参考