EXCEL:如果A1=DD10,DD30,DD60,DD90,DDT,DDG时,B1都显示是,当A1=DD或者DDH时,B1显示否
=if(or(a1="DD10",a1="DD30",a1="DD60",a1="DD90",a1="DDT",a1="DDG"),"是",if(or(a1="DD",A1="DDH"),"否",""))
或者
=IF(OR(A1={"DD10","DD30","DD60","DD90","DDT","DDG"}),"是",IF(OR(A1={"DD","DDH"}),"否",""))