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组成。

posted @ 2016-12-07 14:46  wardensky  阅读(336)  评论(0)  编辑  收藏  举报