假定四个数在A1：A4=if(sum(countif(a1:a4,{"B","C","D"})),1,0)
假设数据在A22,A23,A24,A25,则IF(OR((A22:A25)={"B","C","D"}),1,0)
假设数据在A列,则公式为=IF(SUM(COUNTIF(A:A,{"B","C","D"})),1,)
