最终公式:
IF(AND(COUNT(SPLIT(输入护照号码,""))==9,COUNT(UNION(SPLIT(CONCATENATE(LEFT(输入护照号码,1),"MT"),"")))==2,COUNT(UNION(SPLIT(CONCATENATE(MID(输入护照号码,2,1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ"),"")))==26,COUNT(UNION(SPLIT(CONCATENATE(RIGHT(输入护照号码,7),"1234567890"),"")))==10),"通过","有误")
效果测试:
https://tnvew1vqtq.jiandaoyun.com/f/60b86e5ed38911000826b84c
![1622700926365068.png image.png](/upload/wenda/20210603/1622700926365068.png)
![1622700955142758.png image.png](/upload/wenda/20210603/1622700955142758.png)