Question

EXCEL多重判断问题，请高手指点！！！

单元格A1,B1。
A1有14种可以选填的内容（A,AA,AAA,AAAA,B,BB,BBB,BBBB,C,CC,CCC,CCCC，D,DD）
如何定义B1,若A1中填写了上述14种选项之一时，返回值为空（""）,否则返回值为假（"错误"）。

Answer 1

=if(count(find(a1,{"A","AA","AAA","AAAA","B","BB","BBB","BBBB","C","CC","CCC","CCCC"，"D","DD"})),"","错误")