UC知道EXCEL多重判断问题，请高手指点！！！
来源：百度知道 编辑：UC知道 时间：2024/06/15 10:28:22
单元格A1,B1。
A1有14种可以选填的内容（A,AA,AAA,AAAA,B,BB,BBB,BBBB,C,CC,CCC,CCCC，D,DD）
如何定义B1,若A1中填写了上述14种选项之一时，返回值为空（""）,否则返回值为假（"错误"）。
A1有14种可以选填的内容（A,AA,AAA,AAAA,B,BB,BBB,BBBB,C,CC,CCC,CCCC，D,DD）
如何定义B1,若A1中填写了上述14种选项之一时，返回值为空（""）,否则返回值为假（"错误"）。
=IF(ISNA(HLOOKUP(A1,{"A","AA","AAA","AAAA","B","BB","BBB","BBBB","C","CC","CCC","CCCC","D","DD"},1,FALSE)),"错误","")
=if(isna(lookup(a1,{"A","AA","AAA","AAAA","B","BB","BBB","BBBB","C","CC","CCC","CCCC"，"D","DD"})),"错误","")
=if(count(find(a1,{"A","AA","AAA","AAAA","B","BB","BBB","BBBB","C","CC","CCC","CCCC"，"D","DD"})),"","错误")
一，笨办法
=IF(OR(A1="A",A1="AA",A1="AAA",A1="AAAA",A1="B",A1="BB",A1="BBB",A1="BBBB",A1=&