问题描述:
excel中从身份证中提取性别?
下面这2公式语法没错,怎么提不出啊?=IF(OR(LEN(B2)={15,18}),IF(MOD(RIGHT(LEET(B2,17)),2),"男","女"),"")和=IF(MOD(RIGHT(LEET(B2,17)),2)=1,"男","女")
下面这2公式语法没错,怎么提不出啊?=IF(OR(LEN(B2)={15,18}),IF(MOD(RIGHT(LEET(B2,17)),2),"男","女"),"")和=IF(MOD(RIGHT(LEET(B2,17)),2)=1,"男","女")
问题解答:
我来补答展开全文阅读