Fortune Telling Collection - Zodiac Guide - How to generate constellation _ excel constellation with Excel
How to generate constellation _ excel constellation with Excel
Excel, knowing the ID number, wants to set the corresponding constellation through the date of birth.
The formula is as follows
=IF(LEN(A2)= 18,CHOOSE(MATCH(TRUE,MID(A2, 1 1,2)& amp; "Month"&; MID(A2,13,2) and amp "day" > = {"65438+February 22nd", "165438+1October 22nd", "65438+ 10. "065438+1October 20th"},), "Capricorn", "Sagittarius", "Scorpio", "Libra", "Virgo", "Leo", "Cancer", "Gemini", "Taurus", "Aries" and ". MID(A2, 1 1, 2) and amp "day" > = {"65438+February 22nd", "165438+/October 22nd", "65438+/kloc-0". 065438+1October 20th},), Capricorn, Sagittarius, Scorpio, Libra, Virgo, Leo, Cancer, Gemini, Taurus, Aries and Capricorn.
- Related articles
- The four most indifferent constellations
- Why do many people hate Aries?
- 12 Constellation Hotpot Ordering Convenience _ Twelve Constellation Hotpot
- Emotional control of female students in twelve constellations
- What constellations are Ma Chao and Huang Zhong?
- I hate single constellation women the most.
- 12 constellation exclusive constellation clothing _ 12 constellation exclusive constellation clothing?
- The character of Leo tiger
- Where was the second season of Half-baked Lovers recorded?
- What does Lin Yilun's wife do?