根据身份证号自动计算省份

身份证的最前面两位数字编码代表省份，只要知道每个省份对应的编码即可提取出省份信息。

1. IF 函数计算

采用 IF 函数将每一种情况都罗列出来进行计算。

下述代码可直接复制到公式编辑器内，注意替换身份证号字段。

{"text":"IF(EQ(LEN(​身份证号​),18),IF(EQ(VALUE(MID(​身份证号​,1,2)),11),"北京市",IF(EQ(VALUE(MID(​身份证号​,1,2)),12),"天津市",IF(EQ(VALUE(MID(​身份证号​,1,2)),13),"河北省",IF(EQ(VALUE(MID(​身份证号​,1,2)),14),"山西省",IF(EQ(VALUE(MID(​身份证号​,1,2)),15),"内蒙古自治区",IF(EQ(VALUE(MID(​身份证号​,1,2)),21),"辽宁省",IF(EQ(VALUE(MID(​身份证号​,1,2)),22),"吉林省",IF(EQ(VALUE(MID(​身份证号​,1,2)),23),"黑龙江省",IF(EQ(VALUE(MID(​身份证号​,1,2)),31),"上海市",IF(EQ(VALUE(MID(​身份证号​,1,2)),32),"江苏省",IF(EQ(VALUE(MID(​身份证号​,1,2)),33),"浙江省",IF(EQ(VALUE(MID(​身份证号​,1,2)),34),"安徽省",IF(EQ(VALUE(MID(​身份证号​,1,2)),35),"福建省",IF(EQ(VALUE(MID(​身份证号​,1,2)),36),"江西省",IF(EQ(VALUE(MID(​身份证号​,1,2)),37),"山东省",IF(EQ(VALUE(MID(​身份证号​,1,2)),41),"河南省",IF(EQ(VALUE(MID(​身份证号​,1,2)),42),"湖北省",IF(EQ(VALUE(MID(​身份证号​,1,2)),43),"湖南省",IF(EQ(VALUE(MID(​身份证号​,1,2)),44),"广东省",IF(EQ(VALUE(MID(​身份证号​,1,2)),45),"广西壮族自治区",IF(EQ(VALUE(MID(​身份证号​,1,2)),46),"海南省",IF(EQ(VALUE(MID(​身份证号​,1,2)),50),"重庆市",IF(EQ(VALUE(MID(​身份证号​,1,2)),51),"四川省",IF(EQ(VALUE(MID(​身份证号​,1,2)),52),"贵州省",IF(EQ(VALUE(MID(​身份证号​,1,2)),53),"云南省",IF(EQ(VALUE(MID(​身份证号​,1,2)),54),"西藏自治区",IF(EQ(VALUE(MID(​身份证号​,1,2)),61),"陕西省",IF(EQ(VALUE(MID(​身份证号​,1,2)),62),"甘肃省",IF(EQ(VALUE(MID(​身份证号​,1,2)),63),"青海省",IF(EQ(VALUE(MID(​身份证号​,1,2)),64),"宁夏回族自治区",IF(EQ(VALUE(MID(​身份证号​,1,2)),65),"新疆维吾尔自治区",IF(EQ(VALUE(MID(​身份证号​,1,2)),83),"台湾",IF(EQ(VALUE(MID(​身份证号​,1,2)),81),"香港特别行政区",IF(EQ(VALUE(MID(​身份证号​,1,2)),82),"澳门特别行政区","")))))))))))))))))))))))))))))))))),"")","marks":[{"from":{"line":0,"ch":10,"sticky":null},"to":{"line":0,"ch":16,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":38,"sticky":null},"to":{"line":0,"ch":44,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":77,"sticky":null},"to":{"line":0,"ch":83,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":116,"sticky":null},"to":{"line":0,"ch":122,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":155,"sticky":null},"to":{"line":0,"ch":161,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":194,"sticky":null},"to":{"line":0,"ch":200,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":236,"sticky":null},"to":{"line":0,"ch":242,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":275,"sticky":null},"to":{"line":0,"ch":281,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":314,"sticky":null},"to":{"line":0,"ch":320,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":393,"sticky":null},"to":{"line":0,"ch":399,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":432,"sticky":null},"to":{"line":0,"ch":438,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":354,"sticky":null},"to":{"line":0,"ch":360,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":471,"sticky":null},"to":{"line":0,"ch":477,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":549,"sticky":null},"to":{"line":0,"ch":555,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":510,"sticky":null},"to":{"line":0,"ch":516,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":588,"sticky":null},"to":{"line":0,"ch":594,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":627,"sticky":null},"to":{"line":0,"ch":633,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":666,"sticky":null},"to":{"line":0,"ch":672,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":705,"sticky":null},"to":{"line":0,"ch":711,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":744,"sticky":null},"to":{"line":0,"ch":750,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":826,"sticky":null},"to":{"line":0,"ch":832,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":865,"sticky":null},"to":{"line":0,"ch":871,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":783,"sticky":null},"to":{"line":0,"ch":789,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":943,"sticky":null},"to":{"line":0,"ch":949,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":1021,"sticky":null},"to":{"line":0,"ch":1027,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":1101,"sticky":null},"to":{"line":0,"ch":1107,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":1062,"sticky":null},"to":{"line":0,"ch":1068,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":1140,"sticky":null},"to":{"line":0,"ch":1146,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":1222,"sticky":null},"to":{"line":0,"ch":1228,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":1304,"sticky":null},"to":{"line":0,"ch":1310,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":1347,"sticky":null},"to":{"line":0,"ch":1353,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":1266,"sticky":null},"to":{"line":0,"ch":1272,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":1179,"sticky":null},"to":{"line":0,"ch":1185,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":982,"sticky":null},"to":{"line":0,"ch":988,"sticky":null},"value":"textField_l200ci6g","invalid":false},{"from":{"line":0,"ch":904,"sticky":null},"to":{"line":0,"ch":910,"sticky":null},"value":"textField_l200ci6g","invalid":false}],"isCmData":true}