WPS Table Tutorial: WPS 2012 Combination Formula a key to help you calculate a tax

WPS table can be data calculation, analysis and collation, when the use of some more complex formulas, before many people will find ready-made formula to use, or even make a template for repeated use. For example, the calculation of personal income tax and the extraction of sex from the ID card, date of birth, is a fixed formula, will be downloaded from the Internet other people's files, copy a longer formula to their own form to use.

WPS's "Combinatorial formula" function for everyone to think of the solution, the commonly used formula integrated in the WPS form software, users can directly invoke the formula to calculate, and do not have to go "hard" query "memory Formula", greatly improve the efficiency.

September 1 This year, the introduction of a new method of personal income tax, as an example, using the "combination formula" to see how much they can pay less yuan.

First, make the ET table in the following figure (Figure 1):

Figure 1

Select cell C2, click the Insert Function button in the Formula tab to open the Insert Function dialog box (Figure 2), click "Calculate personal income tax (before 2011-09-01)", and enter the August salary in "pre-tax Payroll income" all Cell "C2" (Enter values to calculate the results directly, In order to make a clear comparison of the use of reference cell data, click the Insert Formula button, calculated to adjust the personal income tax should be paid by the personal income tax, is not very simple?

Figure 2

In the same way, the personal income tax payable after September 1, 2011 is calculated in D2. By entering the formula "=c2-d2" in the E2 cell, you can quickly figure out how much less money is paid (Fig. 3).

Figure 3

Come and try it, I don't need to calculate, the starting point below the passing.

You can also click C2 or D2 cell to see the formula for tax calculation "=round ((b2* (1-23%)-2000) * {0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45}-{ 0,25,125,375,1375,3375,6375,10375,15375},0), 2) "and" =round (MAX (b2* (1-23%)-3500) * {0.03,0.1,0.2,0.25,0.3,0.35,0.45 }-{0,105,555,1005,2755,5505,13505},0), 2) "is not very complicated?"

Et table to add a common combination formula: The calculation of personal income tax, from the date of birth of ID card, gender, multiple conditions, to find other forms of data, and so on, through these commonly used combinations of formulas, we can lightly loose one click, "Pick" the complex formula behind the "fruit."

WPS Office 2012 Person version download address: http://www.wps.cn/