wps的office,exl表格写公式,当两个单元格同时满足特定条件时,第三个...答:=IF(AND(COUNTIF(A9,{"*开元*"}),B6="粘土"),开元!B33,IF(AND(COUNTIF(A9,{"*开元*"}),B6="纯粘土"),开元!C33,IF(AND(COUNTIF(A9,{"*开元*"}),B6="粗粘土"),开元!D33,IF(AND(COUNTIF(A9,{"*开元*"}),B6="细粘土"),开元!E33,IF(AND(COUNTIF(A9,{"*科灵*"})...