早教吧作业答案频道 -->其他-->
EXCEL这个函数有什么问题=LEFT(D2,7)&"axis"&IF(MID(D2,6,2)="A1","1-19",IF(AND(MID(D2,6,2)="A2",RIGHT(D2,1)="A"),"20-38",IF(AND(MID(D2,6,2)="A2",RIGHT(D2,1)="B"),"1-19",IF(AND(MID(D2,6,2)="A3",RIGHT(D2,1)="A"),"39-57",IF(AND(MID(D2,6,2)="A3",
题目详情
EXCEL 这个函数有什么问题
=LEFT(D2,7)&" axis"&IF(MID(D2,6,2)="A1","1-19",IF(AND(MID(D2,6,2)="A2",RIGHT(D2,1)="A"),"20-38",IF(AND(MID(D2,6,2)="A2",RIGHT(D2,1)="B"),"1-19",IF(AND(MID(D2,6,2)="A3",RIGHT(D2,1)="A"),"39-57",IF(AND(MID(D2,6,2)="A3",RIGHT(D2,1)="B"),"20-38",IF(AND(MID(D2,6,2)="A3",RIGHT(D2,1)="C"),"1-19",IF(MID(D2,6,2)="B1","1-17",IF(AND(MID(D2,6,2)="B2",RIGHT(D2,1)="A"),"1-17",IF(AND(MID(D2,6,2)="B2",RIGHT(D2,1)="B"),"18-34",IF(AND(MID(D2,6,2)="B3",RIGHT(D2,1)="A"),"1-17",IF(AND(MID(D2,6,2)="B3",RIGHT(D2,1)="B"),"18-34",IF(AND(MID(D2,6,2)="B3",RIGHT(D2,1)="C"),"35-51",IF(AND(MID(D2,6,2)="C1","1-13",IF(AND(MID(D2,6,2)="C2",RIGHT(D2,1)="A"),"14-26",IF(AND(MID(D2,6,2)="C2",RIGHT(D2,1)="B"),"1-13",IF(AND(MID(D2,6,2)="C3",RIGHT(D2,1)="A"),"27-39",IF(AND(MID(D2,6,2)="C3",RIGHT(D2,1)="B"),"14-26",IF(AND(MID(D2,6,2)="C3",RIGHT(D2,1)="C"),"1-13","NOTHINK"))
这个函数有什么问题吗?怎么老是在B2开始就提示错误,B1没事,到底是哪里出了问题?
=LEFT(D2,7)&" axis"&IF(MID(D2,6,2)="A1","1-19",IF(AND(MID(D2,6,2)="A2",RIGHT(D2,1)="A"),"20-38",IF(AND(MID(D2,6,2)="A2",RIGHT(D2,1)="B"),"1-19",IF(AND(MID(D2,6,2)="A3",RIGHT(D2,1)="A"),"39-57",IF(AND(MID(D2,6,2)="A3",RIGHT(D2,1)="B"),"20-38",IF(AND(MID(D2,6,2)="A3",RIGHT(D2,1)="C"),"1-19",IF(MID(D2,6,2)="B1","1-17",IF(AND(MID(D2,6,2)="B2",RIGHT(D2,1)="A"),"1-17",IF(AND(MID(D2,6,2)="B2",RIGHT(D2,1)="B"),"18-34",IF(AND(MID(D2,6,2)="B3",RIGHT(D2,1)="A"),"1-17",IF(AND(MID(D2,6,2)="B3",RIGHT(D2,1)="B"),"18-34",IF(AND(MID(D2,6,2)="B3",RIGHT(D2,1)="C"),"35-51",IF(AND(MID(D2,6,2)="C1","1-13",IF(AND(MID(D2,6,2)="C2",RIGHT(D2,1)="A"),"14-26",IF(AND(MID(D2,6,2)="C2",RIGHT(D2,1)="B"),"1-13",IF(AND(MID(D2,6,2)="C3",RIGHT(D2,1)="A"),"27-39",IF(AND(MID(D2,6,2)="C3",RIGHT(D2,1)="B"),"14-26",IF(AND(MID(D2,6,2)="C3",RIGHT(D2,1)="C"),"1-13","NOTHINK"))
这个函数有什么问题吗?怎么老是在B2开始就提示错误,B1没事,到底是哪里出了问题?
▼优质解答
答案和解析
应该是嵌套层数超过七层引发的错误
看了EXCEL这个函数有什么问题=...的网友还看了以下：
excel中if语句条件嵌套超过了7层,不知道怎么写了,=if(F3>120,0.5,if(F3> 2020-05-17 …
EXCEL关于IF公式的问题,统计录取否,统计规则如下：考生只要有一门成绩不及格就不录取,否则就录 2020-05-17 …
IF函数题求助如果高等数学、大学英语成绩均大于或等于75在备注栏内给出信息“有资格”,否则给出信息 2020-06-18 …
Mathematica怎么画不出d[3.3]的图?程序如下：Table[{M = Solve[(x 2020-06-27 …
i=0;if(a1==1){i=i+1;}if(a2==3){i=i+1;}if(a3==3){i 2020-07-09 …
IF符合条件公式返回结果求助=IF(D2>120%,0.38%,IF(120%>=D2>110%, 2020-07-09 …
=IF(C20.7,D2*0.7)；=IF(C2>0.8,D2*0.8)；=IF(C2>0.9,D2 2020-10-31 …
EXCEL这个函数有什么问题=LEFT(D2,7)&"axis"&IF(MID(D2,6,2)="A 2020-10-31 …
excel中公示的问题.=IF(AND(COUNTIF(Sheet1!$A$2:$A$232,LEF 2020-11-01 …
请看问题补充,D2列有三个条件选择,最后一个条件的值是个IF公式,嵌套出了问题,试了多次,找不出原因 2020-12-14 …