한국어
=IF(MONTH(AH2)=1,IF(DAY(AH2)>=20,”물병자리”,”염소자리”),IF(MONTH(AH2)=2,IF(DAY(AH2)>=19,”물고기자리”,”물병자리”),IF(MONTH(AH2)=3,IF(DAY(AH2)>=21,”양자리”,”물고기자리”),IF(MONTH(AH2)=4,IF(DAY(AH2)>=20,”황소자리”,”양자리”),IF(MONTH(AH2)=5,IF(DAY(AH2)>=21,”쌍둥이자리”,”황소자리”),IF(MONTH(AH2)=6,IF(DAY(AH2)>=22,”게자리”,”쌍둥이자리”),””))))))&IF(MONTH(AH2)=7,IF(DAY(AH2)>=23,”사자자리”,”게자리”),IF(MONTH(AH2)=8,IF(DAY(AH2)>=23,”처녀자리”,”사자자리”),IF(MONTH(AH2)=9,IF(DAY(AH2)>=23,”천칭자리”,”처녀자리”),IF(MONTH(AH2)=10,IF(DAY(AH2)>=24,”전갈자리”,”천칭자리”),IF(MONTH(AH2)=11,IF(DAY(AH2)>=23,”사수자리”,”전갈자리”),IF(MONTH(AH2)=12,IF(DAY(AH2)>=22,”염소자리”,”사수자리”),””))))))
영어
=IF(MONTH(AH2)=1,IF(DAY(AH2)>=20,”Aquarius”,”Capricorn”),IF(MONTH(AH2)=2,IF(DAY(AH2)>=19,”Pisces”,”Aquarius”),IF(MONTH(AH2)=3,IF(DAY(AH2)>=21,”Aries”,”Pisces”),IF(MONTH(AH2)=4,IF(DAY(AH2)>=20,”Taurus”,”Aries”),IF(MONTH(AH2)=5,IF(DAY(AH2)>=21,”Gemini”,”Taurus”),IF(MONTH(AH2)=6,IF(DAY(AH2)>=22,”Cancer”,”Gemini”),””))))))&IF(MONTH(AH2)=7,IF(DAY(AH2)>=23,”Leo”,”Cancer”),IF(MONTH(AH2)=8,IF(DAY(AH2)>=23,”Virgo”,”Leo”),IF(MONTH(AH2)=9,IF(DAY(AH2)>=23,”Libra”,”Virgo”),IF(MONTH(AH2)=10,IF(DAY(AH2)>=24,”Scorpio”,”Libra”),IF(MONTH(AH2)=11,IF(DAY(AH2)>=23,”Sagittarius”,”Scorpio”),IF(MONTH(AH2)=12,IF(DAY(AH2)>=22,”Capricorn”,”Sagittarius”),””))))))
일본어
=IF(MONTH(AH2)=1,IF(DAY(AH2)>=20,”水瓶(みずがめ)座”,”山羊(やぎ)座”),IF(MONTH(AH2)=2,IF(DAY(AH2)>=19,”魚(うお)座”,”水瓶(みずがめ)座”),IF(MONTH(AH2)=3,IF(DAY(AH2)>=21,”牡羊(おひつじ)座”,”魚(うお)座”),IF(MONTH(AH2)=4,IF(DAY(AH2)>=20,”牡牛(おうし)座”,”牡羊(おひつじ)座”),IF(MONTH(AH2)=5,IF(DAY(AH2)>=21,”双子(ふたご)座”,”牡牛(おうし)座”),IF(MONTH(AH2)=6,IF(DAY(AH2)>=22,”蟹(かに)座”,”双子(ふたご)座”),””))))))&IF(MONTH(AH2)=7,IF(DAY(AH2)>=23,”獅子(しし)座”,”蟹(かに)座”),IF(MONTH(AH2)=8,IF(DAY(AH2)>=23,”乙女(おとめ)座”,”獅子(しし)座”),IF(MONTH(AH2)=9,IF(DAY(AH2)>=23,”天秤(てんびん)座”,”乙女(おとめ)座”),IF(MONTH(AH2)=10,IF(DAY(AH2)>=24,”蠍(さそり)座”,”天秤(てんびん)座”),IF(MONTH(AH2)=11,IF(DAY(AH2)>=23,”射手(いて)座”,”蠍(さそり)座”),IF(MONTH(AH2)=12,IF(DAY(AH2)>=22,”山羊(やぎ)座”,”射手(いて)座”),””))))))
스페인어
=IF(MONTH(AH2)=1,IF(DAY(AH2)>=20,”Piscis”,”Capricornio”),IF(MONTH(AH2)=2,IF(DAY(AH2)>=19,”Acuario”,”Piscis”),IF(MONTH(AH2)=3,IF(DAY(AH2)>=21,”Aries”,”Acuario”),IF(MONTH(AH2)=4,IF(DAY(AH2)>=20,”Tauro”,”Aries”),IF(MONTH(AH2)=5,IF(DAY(AH2)>=21,”Géminis”,”Tauro”),IF(MONTH(AH2)=6,IF(DAY(AH2)>=22,”Cáncer”,”Géminis”),””))))))&IF(MONTH(AH2)=7,IF(DAY(AH2)>=23,”Leo”,”Cáncer”),IF(MONTH(AH2)=8,IF(DAY(AH2)>=23,”Virgo”,”Leo”),IF(MONTH(AH2)=9,IF(DAY(AH2)>=23,”Libra”,”Virgo”),IF(MONTH(AH2)=10,IF(DAY(AH2)>=24,”Escorpio”,”Libra”),IF(MONTH(AH2)=11,IF(DAY(AH2)>=23,”Sagitario”,”Escorpio”),IF(MONTH(AH2)=12,IF(DAY(AH2)>=22,”Capricornio”,”Sagitario”),””))))))
불어
=IF(MONTH(AH2)=1,IF(DAY(AH2)>=20,”Verseau”,”Capricorne”),IF(MONTH(AH2)=2,IF(DAY(AH2)>=19,”Poisson”,”Verseau”),IF(MONTH(AH2)=3,IF(DAY(AH2)>=21,”Bélier”,”Poisson”),IF(MONTH(AH2)=4,IF(DAY(AH2)>=20,”Taureau”,”Bélier”),IF(MONTH(AH2)=5,IF(DAY(AH2)>=21,”Gémeaux”,”Taureau”),IF(MONTH(AH2)=6,IF(DAY(AH2)>=22,”Cancer”,”Gémeaux”),””))))))&IF(MONTH(AH2)=7,IF(DAY(AH2)>=23,”Lion”,”Cancer”),IF(MONTH(AH2)=8,IF(DAY(AH2)>=23,”Vierge”,”Lion”),IF(MONTH(AH2)=9,IF(DAY(AH2)>=23,”Balance”,”Vierge”),IF(MONTH(AH2)=10,IF(DAY(AH2)>=24,”Scorpion”,”Balance”),IF(MONTH(AH2)=11,IF(DAY(AH2)>=23,”Sagittaire”,”Scorpion”),IF(MONTH(AH2)=12,IF(DAY(AH2)>=22,”Capricorne”,”Sagittaire”),””))))))
독어
=IF(MONTH(AH2)=1,IF(DAY(AH2)>=20,”Wassermann”,”Steinbock”),IF(MONTH(AH2)=2,IF(DAY(AH2)>=19,”Fisch”,”Wassermann”),IF(MONTH(AH2)=3,IF(DAY(AH2)>=21,”Widder”,”Fisch”),IF(MONTH(AH2)=4,IF(DAY(AH2)>=20,”Stier”,”Widder”),IF(MONTH(AH2)=5,IF(DAY(AH2)>=21,”Zwilling”,”Stier”),IF(MONTH(AH2)=6,IF(DAY(AH2)>=22,”Krebs”,”Zwilling”),””))))))&IF(MONTH(AH2)=7,IF(DAY(AH2)>=23,”Löwe”,”Krebs”),IF(MONTH(AH2)=8,IF(DAY(AH2)>=23,”Jungfrau”,”Krebs”),IF(MONTH(AH2)=9,IF(DAY(AH2)>=23,”Waage”,”Jungfrau”),IF(MONTH(AH2)=10,IF(DAY(AH2)>=24,”Skorpion”,”Waage”),IF(MONTH(AH2)=11,IF(DAY(AH2)>=23,”Schütze”,”Skorpion”),IF(MONTH(AH2)=12,IF(DAY(AH2)>=22,”Steinbock”,”Schütze”),””))))))
이탈리아어
=IF(MONTH(AH2)=1,IF(DAY(AH2)>=20,”Aquario”,”Capricorno”),IF(MONTH(AH2)=2,IF(DAY(AH2)>=19,”Pesci”,”Aquario”),IF(MONTH(AH2)=3,IF(DAY(AH2)>=21,”Ariete”,”Pesci”),IF(MONTH(AH2)=4,IF(DAY(AH2)>=20,”Toro”,”Ariete”),IF(MONTH(AH2)=5,IF(DAY(AH2)>=21,”Gemelli”,”Toro”),IF(MONTH(AH2)=6,IF(DAY(AH2)>=22,”Cancro”,”Gemelli”),””))))))&IF(MONTH(AH2)=7,IF(DAY(AH2)>=23,”Leone”,”Cancro”),IF(MONTH(AH2)=8,IF(DAY(AH2)>=23,”Vergine”,”Leone”),IF(MONTH(AH2)=9,IF(DAY(AH2)>=23,”Bilancia”,”Vergine”),IF(MONTH(AH2)=10,IF(DAY(AH2)>=24,”Scorpione”,”Bilancia”),IF(MONTH(AH2)=11,IF(DAY(AH2)>=23,”Sagittario”,”Scorpione”),IF(MONTH(AH2)=12,IF(DAY(AH2)>=22,”Capricorno”,”Sagittario”),””))))))
네덜란드어
=IF(MONTH(DC2)=1,IF(DAY(DC2)>=20,”Aquarius”,”Capricornus”),IF(MONTH(DC2)=2,IF(DAY(DC2)>=19,”Pisces”,”Aquarius”),IF(MONTH(DC2)=3,IF(DAY(DC2)>=21,”Aries”,”Pisces”),IF(MONTH(DC2)=4,IF(DAY(DC2)>=20,”Taurus”,”Aries”),IF(MONTH(DC2)=5,IF(DAY(DC2)>=21,”Gemini”,”Taurus”),IF(MONTH(DC2)=6,IF(DAY(DC2)>=22,”Cancer”,”Gemini”),””))))))&IF(MONTH(DC2)=7,IF(DAY(DC2)>=23,”Leo”,”Cancer”),IF(MONTH(DC2)=8,IF(DAY(DC2)>=23,”Virgo”,”Leo”),IF(MONTH(DC2)=9,IF(DAY(DC2)>=23,”Libra”,”Virgo”),IF(MONTH(DC2)=10,IF(DAY(DC2)>=24,”Scorpius”,”Libra”),IF(MONTH(DC2)=11,IF(DAY(DC2)>=23,”Sagittarius”,”Scorpius”),IF(MONTH(DC2)=12,IF(DAY(DC2)>=22,”Capricornus”,”Sagittarius”),””))))))
러시아어
=IF(MONTH(DC2)=1,IF(DAY(DC2)>=20,”Водолей”,”Козерог”),IF(MONTH(DC2)=2,IF(DAY(DC2)>=19,”Рыбы”,”Водолей”),IF(MONTH(DC2)=3,IF(DAY(DC2)>=21,”Овен”,”Рыбы”),IF(MONTH(DC2)=4,IF(DAY(DC2)>=20,”Телец”,”Овен”),IF(MONTH(DC2)=5,IF(DAY(DC2)>=21,”Близнецы”,”Телец”),IF(MONTH(DC2)=6,IF(DAY(DC2)>=22,”Рак”,”Близнецы”),””))))))&IF(MONTH(DC2)=7,IF(DAY(DC2)>=23,”Лев”,”Рак”),IF(MONTH(DC2)=8,IF(DAY(DC2)>=23,”Дева”,”Лев”),IF(MONTH(DC2)=9,IF(DAY(DC2)>=23,”Весы”,”Дева”),IF(MONTH(DC2)=10,IF(DAY(DC2)>=24,”Скорпион”,”Весы”),IF(MONTH(DC2)=11,IF(DAY(DC2)>=23,”Стрелец”,”Скорпион”),IF(MONTH(DC2)=12,IF(DAY(DC2)>=22,”Козерог”,”Стрелец”),””))))))
중국어
=IF(MONTH(DC2)=1,IF(DAY(DC2)>=20,”水瓶座”,”摩羯座”),IF(MONTH(DC2)=2,IF(DAY(DC2)>=19,”双鱼座”,”水瓶座”),IF(MONTH(DC2)=3,IF(DAY(DC2)>=21,”白羊座”,”双鱼座”),IF(MONTH(DC2)=4,IF(DAY(DC2)>=20,”金牛座”,”白羊座”),IF(MONTH(DC2)=5,IF(DAY(DC2)>=21,”双子座”,”金牛座”),IF(MONTH(DC2)=6,IF(DAY(DC2)>=22,”巨蟹座”,”双子座”),””))))))&IF(MONTH(DC2)=7,IF(DAY(DC2)>=23,”狮子座”,”巨蟹座”),IF(MONTH(DC2)=8,IF(DAY(DC2)>=23,”处女座”,”狮子座”),IF(MONTH(DC2)=9,IF(DAY(DC2)>=23,”天秤座”,”处女座”),IF(MONTH(DC2)=10,IF(DAY(DC2)>=24,”天蝎座”,”天秤座”),IF(MONTH(DC2)=11,IF(DAY(DC2)>=23,”射手座”,”天蝎座”),IF(MONTH(DC2)=12,IF(DAY(DC2)>=22,”摩羯座”,”射手座”),””))))))
대만어
=IF(MONTH(DC2)=1,IF(DAY(DC2)>=20,”水瓶座”,”摩羯座”),IF(MONTH(DC2)=2,IF(DAY(DC2)>=19,”雙魚座”,”水瓶座”),IF(MONTH(DC2)=3,IF(DAY(DC2)>=21,”白羊座”,”雙魚座”),IF(MONTH(DC2)=4,IF(DAY(DC2)>=20,”金牛座”,”白羊座”),IF(MONTH(DC2)=5,IF(DAY(DC2)>=21,”雙子座”,”金牛座”),IF(MONTH(DC2)=6,IF(DAY(DC2)>=22,”巨蟹座”,”雙子座”),””))))))&IF(MONTH(DC2)=7,IF(DAY(DC2)>=23,”獅子座”,”巨蟹座”),IF(MONTH(DC2)=8,IF(DAY(DC2)>=23,”處女座”,”獅子座”),IF(MONTH(DC2)=9,IF(DAY(DC2)>=23,”天秤座”,”處女座”),IF(MONTH(DC2)=10,IF(DAY(DC2)>=24,”天蠍座”,”天秤座”),IF(MONTH(DC2)=11,IF(DAY(DC2)>=23,”射手座”,”天蠍座”),IF(MONTH(DC2)=12,IF(DAY(DC2)>=22,”摩羯座”,”射手座”),””))))))