这个公式的IF嵌套超过7层，只有.xlsx格式文档，才支持这个公式。（.et和.xls格式不支持超过7层嵌套。）
新版本的WPS表格可以新建.xlsx格式文档。
你也可以用下面的公式：
=IFERROR(LOOKUP(1,0/FIND({"sogou","xiongbu","shoushen","yanmeibu","bibu","xiaba","tuomao","chuzhou","bahen","jiguang","weizhengxing","zhengxing","hongxuesi","quban","taiji","quchu","simi","miankuo","kouqiang","kouchun","soso"},T4),{"搜狗","胸部","瘦身","眼眉部","鼻部","下巴","脱毛","除皱","疤痕","激光","微整形","整形","红血丝","祛斑","taiji","取出","私密","面阔","口腔","口唇","搜搜"}),"")
前后两个花括号的项目是一一对应的，用英文半角逗号隔开。
你要干什么？这个公式也太长了吧
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024