excel 问题:当等级为A或B时显示“招” 当等级为C或D时显示“考虑” 当...答:比如 =LOOKUP(A1,{"A";"B";"C";"D";"E";"F"},{"招";"招";"考虑";"考虑";"淘汰";"淘汰"})比如 =IF(CODE(A1)<65,"",IF(CODE(A1)<67,"招",IF(CODE(A1)<69,"考虑",IF(CODE(A1)<71,"淘汰","")))比如 =CHOOSE(CODE(A1)-64,"招","招","考虑","考虑","淘汰",...
excel表格中如果包含A,B的都显示为X,如果包含C,D 则显示为, 这样的公 ...答:=IF(ISNUMBER(FIND("A",B2)),"朋友",IF(OR(ISNUMBER(FIND({"B","C"},B2))),"客户",""))
在excel中怎么实现以A、B、C、D四个字母为递减等级分类,原则是有D不...答:=IF(ISNUMBER(SEARCH("d",A1)),"d",IF(ISNUMBER(SEARCH("c",A1)),"c",IF(ISNUMBER(SEARCH("b",A1)),"b",IF(ISNUMBER(SEARCH("a",A1)),"a","")))如果BBCCD不在一个单元格内,先将其用CONCATENATE()或&合并。可将上面公式中的A1改成:=CONCATENATE(A1,B1,C1,D1,E1)...