Excel中怎样实现满足A或B或C中的任意一个,则显示X?答:公式如下,这里分别用="A"来代指某种条件,根据需要来换,都不满足则显示"ELSE"B1=IF(OR(A1="A",A1="B",A1="C"),"X",IF(OR(A1="D",A1="E",A1="F"),"Y",IF(OR(A1="G",A1="H",A1="I"),"Z","ELSE")))
如果一个单元格包含“a”或“b”或“c”中任意一个,即输出“正确”,否...答:这个有好多种写法:=if((a1="a")*(a1="b")*(a1="c"),"正确","错误")=if(a1="a","正确",if(a1="b","正确",if(a1="c","正确","错误")))=IF(OR(A1={"a","b","c"}),"正确","错误")=if(or((a1="a"),(a1="b"),(a1="c")),"正确","错误")...