excel按照日期区分12星座的公式答:区分公式如下:在C10单元格输入以下公式,然后向下填充公式:=LOOKUP(--TEXT(A10,"mdd"),{101,"摩羯座";120,"水瓶座";219,"双鱼座";321,"白羊座";420,"金牛座";521,"双子座";621,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1023,"天蝎座";1122,"射手座";1222,"摩羯座"})...
excel计算星座的三种公式写法使用LOOKUPVLOOKUP查找函数和其余函数结合...答:excel计算星座公式一:B2单元格输入公式,然后下拉复制公式即可。公式:=LOOKUP(--TEXT(A2,"mdd"),{101,"摩羯座";120,"水瓶座";219,"双鱼座";321,"白羊座";420,"金牛座";521,"双子座";621,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1023,"天蝎座";1122,"射手座";1222,"...