Fortune Telling Collection - Horoscope - Excel formula for distinguishing 12 constellation by date.
Excel formula for distinguishing 12 constellation by date.
The discriminant formula is as follows:
Enter the following formula in cell C 10, and then fill the formula down:
= lookup (-text (a 10, "MDD"), {1kloc-0/,"Capricorn"; 120, Aquarius; 2 19, "Pisces"; 32 1, "Aries"; 420, Taurus; 52 1, "Gemini"; 62 1, cancer; 723. Leo; 823, "Virgo"; 923, Libra; 1023, Scorpio; 1 122, "Sagittarius"; 1222, "Capricorn")
See attached figure for details:
- Previous article:Excuse me, my five elements are fond of and taboo.
- Next article:165438+1October 10 What constellation was born?
- Related articles
- Which constellations are the least lacking in noble people, one kind and one trustworthy?
- How to draw a cute and beautiful little dance stick figure?
- What is the constellation of 65438+1October 23rd in the 88th lunar year?
- What do you think of constellations _ What do constellations mean?
- Killer is the recommendation of constellation novels.
- Excuse me, what constellation do I belong to in April of 1984?
- What do you mean by dreaming about constellations?
- Where did the constellation originate?
- Which constellations especially like to work and live in an open and ventilated environment? I can't stand it when I close the windows and doors.
- How to open a tutorial at the beginning of today's headline headline shop?