Simoneexce口是团宗威婷终l中从身份证中提取性别来自???急求
的有关信息介绍如下：问题补充说明：下面这2公式语法没错，怎么提不出啊??=IF(OR(LEN(B2)={15,18}),IF(MOD(RIGHT(LEET(B2,17)),2),"男","女"),"")和=IF(MOD(RIGHT(LEET(B2,17)),2)=1,"男","女")
公式错了，改为:
=IF(OR(LEN(B360问答2)={15,1粒营笑封英介8}),IF(MOD(RIG探合教居充做HT(LEFT(B2,17)),2),"男","女"),"")
或
=IF(MOD(乙说世八哥经介革多属RIGHT(LEFT(B2,17)),2)=1,"男","女")
