http://zhidao.baidu.com/question/558698432.html?push=keyword#answer-1403854870
=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*"),"搜搜","")))))))))))))))))))))
if语句 太多了，之前能用，现在突然不能用了，重新做了一遍，发现if语句不能超过7层，有什么办法能够改变呢
=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*"),"搜搜","")))))))))))))))))))))
if语句 太多了，之前能用，现在突然不能用了，重新做了一遍，发现if语句不能超过7层，有什么办法能够改变呢
