EXCEL公式,公式A=IF(LEN(G309)=15,IF(OR(RIGHT(G309,1)="0",RIGHT(G309,1)="2",RIGHT(G309,1)="4",RIGHT(G309,1)="6",RIGHT(G309,1)="8"),"F","M"),IF(LEN(G309)=18,IF(OR(MID(G309,17,1)="0",MID(G309,17,1)="2",MID(G309,17,1)="4",MID(G309,17,1)="6",MID(G309,1
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/04 07:55:40
![EXCEL公式,公式A=IF(LEN(G309)=15,IF(OR(RIGHT(G309,1)=](/uploads/image/z/8894956-4-6.jpg?t=EXCEL%E5%85%AC%E5%BC%8F%2C%E5%85%AC%E5%BC%8FA%3DIF%28LEN%28G309%29%3D15%2CIF%28OR%28RIGHT%28G309%2C1%29%3D%220%22%2CRIGHT%28G309%2C1%29%3D%222%22%2CRIGHT%28G309%2C1%29%3D%224%22%2CRIGHT%28G309%2C1%29%3D%226%22%2CRIGHT%28G309%2C1%29%3D%228%22%29%2C%22F%22%2C%22M%22%29%2CIF%28LEN%28G309%29%3D18%2CIF%28OR%28MID%28G309%2C17%2C1%29%3D%220%22%2CMID%28G309%2C17%2C1%29%3D%222%22%2CMID%28G309%2C17%2C1%29%3D%224%22%2CMID%28G309%2C17%2C1%29%3D%226%22%2CMID%28G309%2C1)
EXCEL公式,公式A=IF(LEN(G309)=15,IF(OR(RIGHT(G309,1)="0",RIGHT(G309,1)="2",RIGHT(G309,1)="4",RIGHT(G309,1)="6",RIGHT(G309,1)="8"),"F","M"),IF(LEN(G309)=18,IF(OR(MID(G309,17,1)="0",MID(G309,17,1)="2",MID(G309,17,1)="4",MID(G309,17,1)="6",MID(G309,1
EXCEL公式,
公式A=IF(LEN(G309)=15,IF(OR(RIGHT(G309,1)="0",RIGHT(G309,1)="2",RIGHT(G309,1)="4",RIGHT(G309,1)="6",RIGHT(G309,1)="8"),"F","M"),IF(LEN(G309)=18,IF(OR(MID(G309,17,1)="0",MID(G309,17,1)="2",MID(G309,17,1)="4",MID(G309,17,1)="6",MID(G309,17,1)="8"),"F","M"),""))
公式B=IF(LEN(G309)=15,19&MID(G309,7,2)&"-"&MID(G309,9,2)&"-"&MID(G309,11,2),IF(LEN(G309)=18,MID(G309,7,4)&"-"&MID(G309,11,2)&"-"&MID(G309,13,2),""))
=IF(D309="","",INT((TODAY()-D309)/365.25))
EXCEL公式,公式A=IF(LEN(G309)=15,IF(OR(RIGHT(G309,1)="0",RIGHT(G309,1)="2",RIGHT(G309,1)="4",RIGHT(G309,1)="6",RIGHT(G309,1)="8"),"F","M"),IF(LEN(G309)=18,IF(OR(MID(G309,17,1)="0",MID(G309,17,1)="2",MID(G309,17,1)="4",MID(G309,17,1)="6",MID(G309,1
第一个公式判断身份证号码是男是女,如果最后一个是偶数,返回F,奇数返回M.(这个公式编的不怎么样,提取最后一位+2在求余就可以判断奇偶,何必要这么一个个判断)
第二个公式提取出生年月日,如果是15位的号码,提取哪里哪里,18位的提取哪里哪里.
第三个公式如果D309是逗号?计算年龄?
第一个公式那个if15,18完全是多余,
可改为=IF(MOD(RIGHT(G309,1),2)=0,"F","M")