B2=IF((MOD(SUM((0&MID(A1,{1,2,3},1))*1),10)=0)+ISNUMBER(FIND(0,A1)),A1,LEFT(REPT("*",RIGHT(A1))&MID(A1,1,1)&REPT("*",RIGHT(A1))&MID(A1,2,1)&REPT("*",RIGHT(A1))&MID(A1,3,1)&REPT("*",RIGHT(A1)),(RIGHT(A1)+1)*(LEN(A1)+1)-1))
另解=IF(ISERR(FIND(0,A1))*MOD(SUM(-(0&MID(A1,{1,2,3},1))),10),TEXT(A1,REPT(REPT("!*",RIGHT(A1))&0,LEN(A1)))&REPT("*",RIGHT(A1)),A1)
另解=IF(ISERR(FIND(0,A1))*MOD(SUM(-(0&MID(A1,{1,2,3},1))),10),TEXT(A1,MID(REPT(0&REPT("!*",RIGHT(A1)),LEN(A1)+1),2,99)),A1)
留言
張貼留言