=IF(A1="a",1,IF(A2="b",2,IF(A3="c",3,IF(A4="d",4,IF(A5="e",5,IF(A6="f",6,IF(A7="g",7,IF(A8="h",8,if(A9="i",9,if(a10="j",10,if(a11="k",11,if(a12="l",12,if(a13="m",13,if(a14="n",14,if(a15="o",15,if(a16="p",16,if(a17="q",17,if(a18="r",18,19)))))))))))))
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/29 02:33:52
![=IF(A1=](/uploads/image/z/6537061-37-1.jpg?t=%3DIF%28A1%3D%22a%22%2C1%2CIF%28A2%3D%22b%22%2C2%2CIF%28A3%3D%22c%22%2C3%2CIF%28A4%3D%22d%22%2C4%2CIF%28A5%3D%22e%22%2C5%2CIF%28A6%3D%22f%22%2C6%2CIF%28A7%3D%22g%22%2C7%2CIF%28A8%3D%22h%22%2C8%2Cif%28A9%3D%22i%22%2C9%2Cif%28a10%3D%22j%22%2C10%2Cif%28a11%3D%22k%22%2C11%2Cif%28a12%3D%22l%22%2C12%2Cif%28a13%3D%22m%22%2C13%2Cif%28a14%3D%22n%22%2C14%2Cif%28a15%3D%22o%22%2C15%2Cif%28a16%3D%22p%22%2C16%2Cif%28a17%3D%22q%22%2C17%2Cif%28a18%3D%22r%22%2C18%2C19%29%29%29%29%29%29%29%29%29%29%29%29%29)
=IF(A1="a",1,IF(A2="b",2,IF(A3="c",3,IF(A4="d",4,IF(A5="e",5,IF(A6="f",6,IF(A7="g",7,IF(A8="h",8,if(A9="i",9,if(a10="j",10,if(a11="k",11,if(a12="l",12,if(a13="m",13,if(a14="n",14,if(a15="o",15,if(a16="p",16,if(a17="q",17,if(a18="r",18,19)))))))))))))
=IF(A1="a",1,IF(A2="b",2,IF(A3="c",3,IF(A4="d",4,IF(A5="e",5,IF(A6="f",6,IF(A7="g",7,IF(A8="h",8,if(A9="i",9,if(a10="j",10,if(a11="k",11,if(a12="l",12,if(a13="m",13,if(a14="n",14,if(a15="o",15,if(a16="p",16,if(a17="q",17,if(a18="r",18,19)))))))))))))))))),我一个一个检查了,A8之前都正常,输入A9开始就提示公式错误,我就不懂了,都一样的呀,
=IF(A1="a",1,IF(A2="b",2,IF(A3="c",3,IF(A4="d",4,IF(A5="e",5,IF(A6="f",6,IF(A7="g",7,IF(A8="h",8,if(A9="i",9,if(a10="j",10,if(a11="k",11,if(a12="l",12,if(a13="m",13,if(a14="n",14,if(a15="o",15,if(a16="p",16,if(a17="q",17,if(a18="r",18,19)))))))))))))
因为镶套只能是“7”层否则就会出错.
你用的什么版本的,03版以前的IF语句只可以嵌套7层。WPS 9.1.0.4468版本哦,我用的是EXCEL,老版7层,现在的支持64层,你这个WPS可能也只能支持7层,你再看看,不过,这也只是你想要的一种方法,一般用不到这么多层,真有这么多层的话,就用其它更简捷的方法了,当然随之而来的是要增加一些辅助行列。好的,十分感谢,顺祝新年吉祥!新年快乐!...
全部展开
你用的什么版本的,03版以前的IF语句只可以嵌套7层。
收起
因为镶套只能是“7”层否则就会出错。那针对以上的情况有办法解决么?因为涉及的层数大约18-20层,谢谢!一个单元格也可以实现!
=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"...
全部展开
因为镶套只能是“7”层否则就会出错。
收起