Excel中的IF()最多可以嵌套几层?如何突破?答:"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层以上。
EXCEL如何突破IF条件七层嵌套限制?答:何止是麻烦,假如再增加两个条件,if的嵌套最大可以为7层,上面的公式已经用到了极限。虽然说可以用一些旁门左道来“突破”这个限制,但也只是一种堆沙式的游戏,如上例,可以采用以下方式:=IF(A1=1,a,IF(A1=2,b,IF(A1=3,c,IF(A1=4,d,IF(A1=5,e,IF(A1=6,f,IF(A1=7,g,)...
Excel中的IF()最多可以嵌套几层?如何突破?答:"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层以上。