您的位置首页百科问答

exce口是团宗威婷终l中从身份证中提取性别来自???急求

Simone 发布于 2024-09-19 19:58:35 579 阅读

问题补充说明：下面这2公式语法没错，怎么提不出啊??=IF(OR(LEN(B2)={15,18}),IF(MOD(RIGHT(LEET(B2,17)),2),"男","女"),"")和=IF(MOD(RIGHT(LEET(B2,17)),2)=1,"男","女")

exce口是团宗威婷终l中从身份证中提取性别来自???急求

公式错了，改为:

=IF(OR(LEN(B360问答2)={15,1粒营笑封英介8}),IF(MOD(RIG探合教居充做HT(LEFT(B2,17)),2),"男","女"),"")

或

=IF(MOD(乙说世八哥经介革多属RIGHT(LEFT(B2,17)),2)=1,"男","女")

标签:exce,团宗,威婷终