Q:A1单元格中是15位的身份证号码,要在B1中显示性别(这里忽略15位和18位身份证号码的判别) B1=if(mod(right(A1,1),2)>0,"male","female") 请问这个公式有无问题,我试过没发现问题。但在某个网站看到作者所用的是如下公式: B1=if(mid(A1,15,1)/2=trunc(mid(A1,15,1)/2),"female","male") 提取性别(无论是15位还是18位) =IF(LEN(A1)=15,IF(MOD(MID(A1,15,1),2)=1,"男","女"),IF(MOD(MID(A1,17,1),2)=1,"男","女" 如果身份证号的输入已是15或18位,用公式 =IF(MOD(LEFT(RIGHT(A1,(LEN(A1)=18)+1)),2),"男","女" |