:Skillfully use WPS to calculate the old version of personal income tax-Table skills免费ppt模版下载-道格办公

Skillfully use WPS to calculate the old version of personal income tax

  • Image and text skills

Personal income tax has always been a topic of great concern to everyone.

Many people are very curious about the old version of the personal income tax rate table.

The following will explain in detail how to use WPS to calculate the old version of personal income tax.

Taking this tax form as an example, assume that Mr. Wang’s monthly income is 15,000 yuan.

 微信截图_20190612154929.png

分界线.png

■We place the cursor at F6 and click Insert Function - Common Formulas - Calculate Personal Income Tax (before 2018/10/1).

Enter F4 in "Pre-tax salary income".

Because the statutory payment ratio for three insurances and one fund is 23%, and the statutory exemption amount is 3,500, we do not need to make changes here.

Click OK to calculate Mr. Wang's old personal income tax.

 GIF.gif

Have you learned this little trick?

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/qiao-yong-WPS-ji-suan-jiu-ban-ge-ren-suo-de-shui.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion