- 分步
- 合成写
公式:=IF(OR(AND(IF(MOD(MID(A508,17,1),2)=1,”男”,”女”)=”女”,AND(DATEDIF(—TEXT(MID(A508,7,8),”0000-00-00”),TODAY(),”y”)>18,DATEDIF(—TEXT(MID(A508,7,8),”0000-00-00”),TODAY(),”y”)<55)),AND(IF(MOD(MID(A508,17,1),2)=1,"男","女")="男",AND(DATEDIF(--TEXT(MID(A508,7,8),"0000-00-00"),TODAY(),"y")>18,DATEDIF(—TEXT(MID(A508,7,8),”0000-00-00”),TODAY(),”y”)<60))),”符合”,”不符合”)