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

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