根据身份证号自动计算生肖

生肖的计算逻辑是根据出生年份（7～10位）对 12 求余数判断生肖；生份证号的 7～12 位为该身份证对应成员的出生年份。

1. IF 函数计算

通过 IF 函数将各种情况都罗列出来，符合情况的则自动计算出生肖

下述代码可直接复制到公式编辑器内，注意替换身份证号字段。

{"text":"IF(EQ(LEN(​身份证号​),18),IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),0),\"猴\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),1),\"鸡\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),2),\"狗\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),3),\"猪\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),4),\"鼠\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),5),\"牛\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),6),\"虎\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),7),\"兔\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),8),\"龙\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),9),\"蛇\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),10),\"马\",\"羊\"))))))))))),\"\")","marks":[{"from":{"line":0,"ch":10,"sticky":null},"to":{"line":0,"ch":16,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":42,"sticky":null},"to":{"line":0,"ch":48,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":86,"sticky":null},"to":{"line":0,"ch":92,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":130,"sticky":null},"to":{"line":0,"ch":136,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":174,"sticky":null},"to":{"line":0,"ch":180,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":218,"sticky":null},"to":{"line":0,"ch":224,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":262,"sticky":null},"to":{"line":0,"ch":268,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":306,"sticky":null},"to":{"line":0,"ch":312,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":350,"sticky":null},"to":{"line":0,"ch":356,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":394,"sticky":null},"to":{"line":0,"ch":400,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":438,"sticky":null},"to":{"line":0,"ch":444,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":482,"sticky":null},"to":{"line":0,"ch":488,"sticky":null},"value":"textField_ksfyitkm","invalid":false}],"isCmData":true}