最终公式:
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