excel表格星座计算公式输入生日计算出星座

excel计算星座的三种公式写法使用LOOKUPVLOOKUP查找函数和其余函数结合计算星座

excel计算星座公式一：B2单元格输入公式，然后下拉复制公式即可。公式：=LOOKUP(--TEXT(A2,"mdd"),{101,"摩羯座";120,"水瓶座";219,"双鱼座";321,"白羊座";420,"金牛座";521,"双子座";621,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1023,"天蝎座";1122,"射手座";1222,"...

excel如何根据身份证号码计算生成出生肖和星座函数公式

输入公式：【=VLOOKUP(VALUE("1900-"&TEXT(MID(B2,LEN(B2)/2+2,4),"#-##")),{1,"摩羯座";20,"水瓶座";50,"双鱼座";81,"白羊座";111,"金牛座";142,"双子座";174,"巨蟹座";205,"狮子座";236,"处女座";267,"天秤座";298,"天蝎座";...

excel表格星座计算公式(输入生日计算出星座)

{"1/21","2/20","3/21","4/21","5/22","6/22","7/23","8/22","9/24","10/24","11/23","12/23"},{"水瓶","双鱼","牧羊","金牛","双子","巨蟹","狮子","处女","天秤","天蝎","射手","摩羯"}&"座")。比如下面公式 =IF(ISNA(VLOOKUP(B5,sheet1!$B$2:$E...

电子表格身份证号码计算生成星座和星座电子表格功能不求人

公式：[=vlookup(值(‘ 1900-‘文本(mid (a2，len (a2)/22，4)，’ #-# # ‘))，{1，’摩羯座’；20、水瓶座；50，“双鱼座”；81，“白羊座”；111，“金牛座”；142，“双子座”；174，“癌症”；205，“狮子座”；236，“处女座”；267，“天秤座”；298，“天蝎座”；328，...

excel按照日期区分12星座的公式

在C10单元格输入以下公式，然后向下填充公式：=LOOKUP(--TEXT(A10,"mdd"),{101,"摩羯座";120,"水瓶座";219,"双鱼座";321,"白羊座";420,"金牛座";521,"双子座";621,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1023,"天蝎座";1122,"射手座";1222,"摩羯座"})详见附图：...