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

2020-05-05 体育 204阅读
这个公式的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","取出","私密","面阔","口腔","口唇","搜搜"}),"")
前后两个花括号的项目是一一对应的,用英文半角逗号隔开。
声明:你问我答网所有作品(图文、音视频)均由用户自行上传分享,仅供网友学习交流。若您的权利被侵害,请联系fangmu6661024@163.com