Excel中,A单元格为a或b时,B单元格为1,否则为2;A单元格为c或d时,B单 ...答:=if(or(A1="a",A1="b"),1,if(or(a1="c",A1="d"),3,2))
excel表格:如何根据一个单元格为A或B或C,对应在单元格生成D或E或F?答:你要的公式:=LOOKUP(A1,{"A","B","C"},{"D","E","F"})或者 =LOOKUP(A1,{"A","D";"B","E";"C","F"})
excel某单元格如果包含a或者包含b,返回“含”,都不包含返回“不含...答:=IF((FIND("a",A1&"ab")=LEN(A1)+1)*(FIND("b",A1&"ab")=LEN(A1)+2),"不含","含");或者:=IF(ISERROR(FIND("a",A1))*ISERROR(FIND("b",A1)),"不含","含")