关于IF函数可否再简化

PJ551314

求指点，我想把品类再归大类，可是用IF函数 公式太长了，可否有简便的方法实现呢

=IF(OR(AA7="POLO衫",AA7="T恤",AA7="背心",AA7="衬衫",AA7="衬衣",AA7="针织衫",AA7="短袖",AA7="风衣",AA7="夹克",AA7="连衣裙",AA7="套头衫",AA7="外套",AA7="卫衣",AA7="西服",AA7="裤",AA7="运动套装",AA7="上衣",AA7="羽绒服",AA7="大衣",AA7="毛衫",AA7="裙子",AA7="马甲",AA7="运动衫",AA7="内裤",AA7="内衣",AA7="短裙",AA7="半身裙",AA7="袜",AA7="毛衣",AA7="开衫",AA7="开襟衫",AA7="棉服",AA7="连体衣"),"服装",IF(OR(AA7="腰包",AA7="行李牌",AA7="行李箱",AA7="手提袋",AA7="化妆包",AA7="卡夹",AA7="钱夹",AA7="购物袋",AA7="手袋",AA7="卡片夹",AA7="卡片套",AA7="皮肩带",AA7="卡袋",AA7="皮夹",AA7="双肩背",AA7="公文夹",AA7="斜挎包",AA7="单肩包",AA7="卡包",AA7="双肩包",AA7="手拿包",AA7="斜跨包",AA7="信使包",AA7="商务包",AA7="手提包",AA7="邮差包",AA7="随身包",AA7="钱包",AA7="女包",AA7="蛇头包",AA7="饺子包",AA7="两用包",AA7="水桶包",AA7="双背包",AA7="公文包",AA7="旅行袋",AA7="手机袋",AA7="背包",AA7="挎包",AA7="提包",AA7="链条包",AA7="托特包",AA7="马鞍包",AA7="相机包",AA7="波士顿包",AA7="沙漏包",AA7="钥匙包",AA7="比格包",AA7="竹节包",AA7="锁头包",AA7="贝壳包",AA7="手柄包",AA7="笑脸包"),"箱包",IF(OR(AA7="领带",AA7="帽",AA7="皮带",AA7="钥匙扣",AA7="围巾",AA7="丝巾",AA7="腰带",AA7="袖扣",AA7="挂饰",AA7="披肩",AA7="领结"),"服饰",IF(OR(AA7="鞋",AA7="长靴",AA7="雨靴",AA7="靴"),"鞋履",IF(OR(AA7="耳钉",AA7="手链",AA7="胸针",AA7="发夹",AA7="耳夹",AA7="戒指",AA7="耳饰",AA7="手镯",AA7="项链",AA7="耳环",AA7="手环",AA7="发饰"),"首饰",IF(AA7="太阳镜","眼镜",IF(OR(AA7="手机壳",AA7="耳机"),"数码产品",IF(OR(AA7="笔芯",AA7="笔袋",AA7="墨水",AA7="名片夹",AA7="笔"),"文具","生活家居"))))))))

朱志强

可以做个对照表,然后用查找函数查找

mountain119

你可以把OR(AA2=XXX,AA2=YYY）这种写成OR(AA2={"XXX","YYY"})这样的，不过因为东西太多了，建议还是做个辅助表，用查找的方式去匹配

cyh3230

能写出连环套的, 也是牛人

PJ551314

谢谢大神 建一个辅助助更方便，问题已解决

你是那块小饼干

看的眼花  能写出来也是个牛人