统一社会信用代码判断

wengchuxx

请高人帮助一下，C1单元格中的公式是数组，嵌套到B2单元格的公式中去就不再是数组了，该怎么办？

wengchuxx

就是想把C1中公式嵌套到B2中去，只用一个公式就判断统一社会信用代码到底对不对，可能嵌套进去后的结果总是错的。

chenyun1234

数组公式的前提是：编辑好公式，最后三键合一，就有大挂号，



再次强调：不是手工输入的大挂号

我走我流

=IF(VLOOKUP(31-MOD(SUM((VLOOKUP(T(IF({1},MID(B1,ROW($1:$17),1))),{"0",0;"1",1;"2",2;"3",3;"4",4;"5",5;"6",6;"7",7;"8",8;"9",9;"A",10;"B",11;"C",12;"D",13;"E",14;"F",15;"G",16;"H",17;"J",18;"K",19;"L",20;"M",21;"N",22;"P",23;"Q",24;"R",25;"T",26;"U",27;"W",28;"X",29;"Y",30},2,0))*(MOD(3^(ROW($1:$17)-1),31))),31),{0,"0";1,"1";2,"2";3,"3";4,"4";5,"5";6,"6";7,"7";8,"8";9,"9";10,"A";11,"B";12,"C";13,"D";14,"E";15,"F";16,"G";17,"H";18,"J";19,"K";20,"L";21,"M";22,"N";23,"P";24,"Q";25,"R";26,"T";27,"U";28,"W";29,"X";30,"Y"},2,0)=RIGHT(B1),"正确","错误")
把C1:C17用T(IF({1},..))转化成内存数组，，就可以用了，不过公式也太长了点

wengchuxx

感谢4楼，可以了。