星座公式excel

在Excel中，你可以使用公式來計算星座。通常，星座的劃分是基於出生日期的月份和日期。以下是一個簡單的公式示例，用於根據出生日期確定星座：

假設A1單元格包含出生日期（例如1990-01-15），你可以使用以下公式來確定星座：

=IF(AND(MONTH(A1)=1,DAY(A1)>=20),"水瓶座",
 IF(AND(MONTH(A1)=2,DAY(A1)<=18),"水瓶座",
 IF(AND(MONTH(A1)=2,DAY(A1)>=19),"雙魚座",
 IF(AND(MONTH(A1)=3,DAY(A1)<=20),"雙魚座",
 IF(AND(MONTH(A1)=3,DAY(A1)>=21),"牡羊座",
 IF(AND(MONTH(A1)=4,DAY(A1)<=19),"牡羊座",
 IF(AND(MONTH(A1)=4,DAY(A1)>=20),"金牛座",
 IF(AND(MONTH(A1)=5,DAY(A1)<=20),"金牛座",
 IF(AND(MONTH(A1)=5,DAY(A1)>=21),"雙子座",
 IF(AND(MONTH(A1)=6,DAY(A1)<=21),"雙子座",
 IF(AND(MONTH(A1)=6,DAY(A1)>=22),"巨蟹座",
 IF(AND(MONTH(A1)=7,DAY(A1)<=22),"巨蟹座",
 IF(AND(MONTH(A1)=7,DAY(A1)>=23),"獅子座",
 IF(AND(MONTH(A1)=8,DAY(A1)<=22),"獅子座",
 IF(AND(MONTH(A1)=8,DAY(A1)>=23),"處女座",
 IF(AND(MONTH(A1)=9,DAY(A1)<=22),"處女座",
 IF(AND(MONTH(A1)=9,DAY(A1)>=23),"天秤座",
 IF(AND(MONTH(A1)=10,DAY(A1)<=22),"天秤座",
 IF(AND(MONTH(A1)=10,DAY(A1)>=23),"天蠍座",
 IF(AND(MONTH(A1)=11,DAY(A1)<=21),"天蠍座",
 IF(AND(MONTH(A1)=11,DAY(A1)>=22),"射手座",
 IF(AND(MONTH(A1)=12,DAY(A1)<=21),"射手座",
 IF(AND(MONTH(A1)=12,DAY(A1)>=22),"摩羯座",
 IF(AND(MONTH(A1)=1,DAY(A1)<=19),"摩羯座",""))))))))))))))))))))))))

這個公式通過嵌套的IF和AND函式來判斷出生日期所屬的星座。每個IF函式檢查月份和日期是否在某個星座的範圍內，如果是，則返回相應的星座名稱。

你可以將這個公式複製到其他單元格中，以便為多個出生日期計算星座。