A1のセルに入力したマイナンバーを確認する
=IF(IF(MOD(MID(A1,1,1)*6+MID(A1,2,1)*5+MID(A1,3,1)*4+MID(A1,4,1)*3+MID(A1,5,1)*2+MID(A1,6,1)*7+MID(A1,7,1)*6+MID(A1,8,1)*5+MID(A1,9,1)*4+MID(A1,10,1)*3+MID(A1,11,1)*2,11)<1,0,11-MOD(MID(A1,1,1)*6+MID(A1,2,1)*5+MID(A1,3,1)*4+MID(A1,4,1)*3+MID(A1,5,1)*2+MID(A1,6,1)*7+MID(A1,7,1)*6+MID(A1,8,1)*5+MID(A1,9,1)*4+MID(A1,10,1)*3+MID(A1,11,1)*2,11))=INT(MID(A1,12,1)),"OK","!!!!!NG!!!!!")