excel里面,1-20个数字,选1出现A,选2出现B,以此类推.我用IF函数只能嵌套7层.

有两个办法,第一个 是直接换用07版本的 可以嵌套64层
第二是在每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,"H",""))))))))&IF(A1=9,"I",IF(A1=10,"J",IF(A1=11,"K",IF(A1=12,"L",IF(A1=13,"M",IF(A1=14,"N",IF(A1=15,"O",IF(A1=16,"P",""))))))))&IF(A1=17,"Q",IF(A1=18,"R",IF(A1=19,"S",IF(A1=20,"T"))))
就可以了 ,试试吧