Excel公式

多个IF

=IF(ISNUMBER(SEARCH("lz",E7)),"lz",
IF(ISNUMBER(SEARCH("zch",E7)),"zch",
IF(OR(ISNUMBER(SEARCH("医",E7)),ISNUMBER(SEARCH("药",E7))),"医疗",
IF(OR(ISNUMBER(SEARCH("车",E7)),ISNUMBER(SEARCH("路",E7))),"车",
IF(ISNUMBER(SEARCH("kk",E7)),"kk",
IF(OR(ISNUMBER(SEARCH("菜",E7)),ISNUMBER(SEARCH("超市",E7)),ISNUMBER(SEARCH("饭",E7))),"家庭日常","家庭日常"))))

此公式是excel里面用来分组的公式，用多个if和or组成。

转载于:https://www.cnblogs.com/wardensky/p/6141126.html