=IF(ISERROR(FIND(A1,B1&C1&D1&e1&f1&g1)),"错"判册,"对")
这个公式还是欠考拦野虑了 用下面的公式
=IF(ISERROR(VLOOKUP(A1,B1:G1,1)),"错"简冲喊,"对")
=IF(OR(A1=B1,A1=C1,A1=D1,A1=E1,A1=F1,A1=G1),"对","错"汪慎)
或
=IF(COUNTIF(B1:G1,A1),"对"燃搜,"错困段敬")
=IF(OR(A1=B1,A1=C1,A1=D1,A1=E1,A1=F1,A1=G1),"对","错")
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024