excel公式，在wps里面用的好好的，今天自动升级了，公式就不能用了，说输入的公式存在错误，要输入单引号

Question

excel公式，在wps里面用的好好的，今天自动升级了，公式就不能用了，说输入的公式存在错误，要输入单引号
公式如下：
=IF(COUNTIF(T4,"*sogou*"),"搜狗",IF(COUNTIF(T4,"*xiongbu*"),"胸部",IF(COUNTIF(T4,"*shoushen*"),"瘦身",IF(COUNTIF(T4,"*yanmeibu*"),"眼眉部",IF(COUNTIF(T4,"*bibu*"),"鼻部",IF(COUNTIF(T4,"*xiaba*"),"下巴",IF(COUNTIF(T4,"*tuomao*"),"脱毛",IF(COUNTIF(T4,"*chuzhou*"),"除皱",IF(COUNTIF(T4,"*bahen*"),"疤痕",IF(COUNTIF(T4,"*jiguang*"),"激光",IF(COUNTIF(T4,"*weizhengxing*"),"微整形",IF(COUNTIF(T4,"*zhengxing*"),"整形",IF(COUNTIF(T4,"*hongxuesi*"),"红血丝",IF(COUNTIF(T4,"*quban*"),"祛斑",IF(COUNTIF(T4,"*taiji*"),"taiji",IF(COUNTIF(T4,"*quchu*"),"取出",IF(COUNTIF(T4,"*simi*"),"私密",IF(COUNTIF(T4,"*miankuo*"),"面阔",IF(COUNTIF(T4,"*kouqiang*"),"口腔",IF(COUNTIF(T4,"*kouchun*"),"口唇",IF(COUNTIF(T4,"*soso*"),"搜搜","")))))))))))))))))))))

Answer 1

这个公式的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","取出","私密","面阔","口腔","口唇","搜搜"}),"")

前后两个花括号的项目是一一对应的，用英文半角逗号隔开。

Answer 2

你要干什么？这个公式也太长了吧追问

做数据统计，要知道这个表里面里是什么项目来的，来后翻译成对应的汉字，现在就是说公式不对

追答

我觉得做个数据库对应查找比较方便