用定义名称来实现:插入-名称-定义,名称为abc,值中输入下列公式:
=IF(Sheet1!$A$1>100,"a",IF(Sheet1!$A$1>90,"b",IF(Sheet1!$A$1>80,"c",IF(Sheet1!$A$1>70,"d",IF(Sheet1!$A$1>60,"e",IF(Sheet1!$A$1>50,"f",IF(Sheet1!$A$1>40,"g",IF(Sheet1!$A$1>30,"h","no"))))))))
定义好名称后,再在工作表中输入=IF(abc<>"no",abc,IF(A1>20,"I",IF(A1>10,"j","")))
这样就可嵌套8层以上。
温馨提示:答案为网友推荐,仅供参考