在EXCEL公式中,IF函数最多可以判断7个,现在我需要判断的数据有50个...答: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","")))&IF(A1=8,...
求急救!请问Excel表中,IF函数公式只能嵌入7个公式,要是我有大于7个条件...答:=LOOKUP(A1,10*{0,1,2,3,4,5,6,7,8,9,10,11,12},{3,5,7,8,10,11,12,14,15,16,17,18,20})
EXCEL IF嵌套超过7层,如何求算,或者有其他公式可解?答:=IF(F3<80%,0,LOOKUP(F3,{0.8,0.85,0.9,0.95,1,1.0001,1.05,0.1,1.2},{-0.4,-0.3,-0.2,-0.1,0,0.1,0.2,0.4,0.5})+F3)