WPS表格如何通过身份证号提取性别？

[[{"txt": "WPS\u8868\u683c\u662f\u6211\u4eec\u7ecf\u5e38\u4f7f\u7528\u7684\u529e\u516c\u8f6f\u4ef6\uff0c\u7ed9\u6211\u4eec\u5e26\u6765\u4e86\u5f88\u5927\u7684\u65b9\u4fbf\uff0c\u73b0\u5728\u6211\u4eec\u4e00\u8d77\u770b\u770b\u5982\u4f55\u4f7f\u7528WPS\u8868\u683c\u901a\u8fc7\u8eab\u4efd\u8bc1\u53f7\u5feb\u901f\u63d0\u53d6\u6027\u522b\uff1f"}, {"img": ["https://exp-picture.cdn.bcebos.com/18aebc5f0c14c27bf230bb3c2a46b7b1eff9390b.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u4e00\uff1a\u901a\u8fc7\u516c\u5f0f\u63d0\u53d6"]}, {"txt": "\u6253\u5f00\u9700\u8981\u63d0\u53d6\u6027\u522b\u7684WPS\u8868\u683c\uff0c\u5e26\u6709\u8eab\u4efd\u8bc1\u53f7\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/7efc527c34b33c411a08eef4887de137c8762e0b.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8f93\u5165=IF(MOD(MID(B3,17,1),2)=1,\u201d\u7537\u201d,\u201d\u5973\u201d)\uff0c\u5373\u8eab\u4efd\u8bc1\u7b2c17\u4f4d\u9664\u4ee52\u53d6\u4f59\u7b49\u4e8e1\uff0c\u8bf4\u660e\u7b2c17\u4f4d\u4f4d\u5947\u6570\uff0c\u5219\u4e3a\u7537\u6027\uff0c\u5426\u5219\u4e3a\u5076\u6570\uff0c\u5373\u4e3a\u5973\u6027\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e076d77622bc7dc5ffd516ea5e460596b914290b.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u70b9\u51fb\u56de\u8f66\uff0c\u5c31\u53ef\u4ee5\u770b\u5230\u6027\u522b\u4e86 \uff0c\u9f20\u6807\u79fb\u81f3\u5de6\u4e0b\u89d2\uff0c\u51fa\u73b0\u586b\u5145\u5341\u5b57\u67c4\u65f6\uff0c\u62d6\u52a8\u4e0b\u62c9\u81f3\u6700\u540e\u4e00\u7ec4\u6570\u636e\uff0c\u5c31\u5168\u90e8\u5f15\u7528\u516c\u5f0f\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/b442d6d246fe474ef8310e0ab0ef354f51b81f0b.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/a99a494afa32939c6845e2075719ce2c5a1b150b.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u4e8c\u3001\u4f7f\u7528\u547d\u4ee4\u5de5\u5177\u680f"]}, {"txt": "\u6253\u5f00\u9700\u8981\u63d0\u53d6\u6027\u522b\u7684WPS\u8868\u683c\uff0c\u5e26\u6709\u8eab\u4efd\u8bc1\u53f7\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/a1780d1fceecd3d926c7cf71679959430501080b.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u5de5\u5177\u680f\u70b9\u51fb\u201c\u516c\u5f0f-\u63d2\u5165\u51fd\u6570\u201d\uff0c\u5f39\u51fa\u201c\u63d2\u5165\u51fd\u6570\u201d\u5bf9\u8bdd\u6846\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/5c2a1ad149299a8863a1d55067eeadbcbf2f7f0b.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u63d2\u5165\u51fd\u6570\u5bf9\u8bdd\u6846\uff0c\u6211\u4eec\u9009\u62e9\u201c\u5e38\u7528\u516c\u5f0f\u201d\u4e0b\u7684\u201c\u63d0\u53d6\u8eab\u4efd\u8bc1\u6027\u522b\u201d\uff0c\u9009\u62e9\u8eab\u4efd\u8bc1\u53f7\u6240\u5728\u7684\u5355\u5143\u683c\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/de9bfa3b3b8602212ae5aee3d8bbf82065fb720b.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u70b9\u51fb\u201c\u786e\u5b9a\u201d\u5c31\u53ef\u4ee5\u4e86\uff0c\u5f80\u4e0b\u62d6\u52a8\u5168\u90e8\u5f15\u7528\u516c\u5f0f\u5c31\u53ef\u4ee5\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/05e24be983aee8d72898de5a6b781431deb6660b.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}]]