作业帮 > 数学 > 作业

=IF(A1="a",1,IF(A2="b",2,IF(A3="c",3,IF(A4="d",4,IF(A5="e",5

来源：学生作业帮 编辑：神马作文网作业帮 分类：数学作业 时间：2024/11/19 01:57:46
=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=
因为镶套只能是“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",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",IF(A1=21,"U",IF(A1=22,"V",IF(A1=23,"W",IF(A1=24,"X",""))))))))&IF(A1=25,"Y",IF(A1=26,"Z","")) 这是早些时候在百度搜到的答案望能有所帮助。
再问： 非常感谢，祝新年快乐！
=IF(A2>90,A ,IF(A2>80,B ,C )) IF(A3="","",A3), 关于 if(!a)x--;else if(b);if(c)x=3;else x=4; int a=0,b=1,c=0,d=20; if(a) d-=10 ;else if(b) {if(!c) d=15;e excel中的if函数,=if（a1<>0,1,0)+if（a2<>0,1,0)+if（a3&l =IF(IF(D6 =IF(SUM(A1:A5)>0,SUM(A1:A5) IF(A3=A2,D3+E2, excel中：如何实现=if(a2=d2,b2=e2,if(a3=d3,b3=d3,if(a4=d4,b4=e4,if( #includemain(){ int a=1,b=2,c=3,d=0;if(a==1)if(b!=2)if(c==3) 公式=IF(A1 =IF(A1