WPS Mobile Edition teaches you the year-end bonus tax algorithm

Source: Internet
Author: User

Year to year, the year-end award has become a topic of concern for everyone, micro-blog on the city's year-end awards are also fresh out. In a word to sum up his 2012 work: God horse can be a cloud, but the year-end award is in any case still can not think of it as a cloud. And for those who get a big year-end bonus, they're concerned about another question, how does this money count as a personal income tax?

Next follow Mo to see together, how to use WPS Mobile version give me quick calculate year-end income tax.

The formula for the year-end bonus is: Full X-Calculating quickly deduction, while the year-end award of personal income tax is as follows:

On the tablet running WPS Mobile version of software, open the Enterprise Employees annual Performance Bonus sheet, if the year-end award has not been calculated, you can refer to a MO explained the "If Function statistics Year-End Award" method, and then calculate the Enterprise Employees year-end award.

After the year-end award, then Mo can be the WPS mobile version of the built-in if function to draw the year-end bonus income tax. To do this, double-click the F3 cell of the WPS mobile form, and then click the "T" letter on the left side of the definition keyboard. After opening the WPS Mobile version of the table with the special input method, click the "F (X)" button, the function list appears.

Into the WPS mobile version of "Common Functions", select the "IF" function, and then according to the year-end bonus tax formula input function can be. Assuming that in the table of this example, the employee's annual bonus is no more than 108000 yuan, then the calculation of the annual income tax rate for the employees will include 3%, 10% and 20% three cases, while the calculating quickly deduction also has 0 yuan, 105 yuan and 5,553 kinds of cases.

Then input =if (E3/12>=4500,e3*0.2-555,if (e3/12>=1500,e3*0.1-105,e3*0.03-0)) function can be confirmed after the WPS mobile version can be derived F3 cell "Yang Lin" The employee's year-end income tax is 450 yuan.

Next, hand pointing to the table F4 cell, and then in the WPS Mobile version of the Fill menu, select "Drag Fill", and then drag down with your fingers, WPS Mobile version will automatically come up with all the employees in the form of the year-end income tax.

Mo reminds us that the greater the span of year-end awards, the more the year-end income tax rate, the more complex function settings. If the year-end award is over 108000 yuan, students can refer to the personal Income tax tax form to apply the IF function.

For most office workers, the biggest event of the last one months before the Spring Festival is the year-end award. For friends who often touch tables, the WPS Mobile version has 300 built-in functions and formulas that help them easily compute the various data. But if you want to know how the year-end award of personal income tax should be calculated, you may wish to take a look at Ah Mo in this article to share a little experience.

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.