WPS Table calculates the zodiac quickly according to birth date

Source: Internet
Author: User

As shown in the chart above, how do you quickly get the zodiac sign in the already known date?

In the table, you can use the function formula to quickly complete this task, specifically, see the following operation animation!

In the above action animation, the formula used in cell C2 is: =mid ("Monkey chicken dog pig cow tiger rabbit snake horse Sheep", MOD (B2), 12) +1,1, then fill the formula by the drop-fill method, so that you can quickly and batch to find the specific date of the zodiac.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.