或许，这世间一切的好往往都是求之不得的吧。有心栽花花不发，无心插柳柳成荫；有心栽柳柳不成荫，无意种花花却繁华。

Sunday, April 10, 2016

身份证 excel 提取性别

公式错了，改为：
=IF(OR(LEN(B2)={15,18}),IF(MOD(RIGHT(LEFT(B2,17)),2),"男","女"),"")
或
=IF(MOD(RIGHT(LEFT(B2,17)),2)=1,"男","女")
时间：
反应： 
标签：

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)