如何设置后列包含多个条件(地区名称),前列显示对应词(地区对应特定分类名称)
A2:=IF(OR(ISNUMBER(FIND("开发区",B2)),ISNUMBER(FIND("产业园",B2))),"产业","")&IF(OR(ISNUMBER(FIND("大兴",B2)),ISNUMBER(FIND("延庆",B2)),ISNUMBER(FIND("密云",B2))),"多点","")&IF(OR(ISNUMBER(FIND("东城",B2)),ISNUMBER(FIND("西城",B2))),"核心区","")&IF(OR(ISN···