如果一个单元格包含“a”或“b”或“c”中任意一个,即输出“正确”,否...答:=if(a1="a","正确",if(a1="b","正确",if(a1="c","正确","错误")))=IF(OR(A1={"a","b","c"}),"正确","错误")=if(or((a1="a"),(a1="b"),(a1="c")),"正确","错误")
EXCEL中某单元格包含数值A或B或C,则相应在另一单元显示a或b或c答:B1公式:=IF(IFERROR(FIND("160",A1),0),1,IF(IFERROR(FIND("80",A1),0),2,IF(IFERROR(FIND("200",A1),0),3,"")))