nnsea 发表于 2023-1-11 22:34:07

根据身份证号码自动计算星座


=LOOKUP(--MID(A2,11,4),{101,"摩羯座";121,"水瓶座";219,"双鱼座";321,"白羊座";421,"金牛座";522,"双子座";622,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1024,"天蝎座";1123,"射手座";1222,"摩羯座"})
页: [1]
查看完整版本: 根据身份证号码自动计算星座