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没事,到底是哪里出了问题?
