We introduce the formulas in the table one by one:

​ ​ 1. Quadrature: There is no quadrature operation in the "Quick Calculation" button in the common toolbar, but we can enter the formula manually. In the above table, position the cursor in the cell where Zhang San’s overtime pay is located, press Ctrl+F9 to insert the field, enter “=E2*F2” in the braces and then press F9 again, which will display “100”. In addition, if multiple cells are multiplied together, you can also use the quadrature function (PRODUCT). For example, Zhang San's overtime pay can be changed to "=PRODUCT(E2:F2)".

table formula

2. Discontinuous sum: For example, Zhang San’s “Total” item is the sum of four items including basic salary, living allowance, hardship allowance and overtime pay. However, if you use the “Sum” button on the common toolbar, it will Adding "overtime pay standards" and "number of overtime days" is not consistent with the actual situation. What should we do? We position the cursor in Zhang San's "Total" item, press Ctrl+F9, insert a field, and enter "=SUM(B2:D2,G2)" in it. Press F9 to get the correct result.

​ ​ 3. Graphical mode: If you find the above manual input to be troublesome, you can also use graphic mode to perform calculations. Position the cursor on the cell where you want to generate results, and then select "Field" from the "Insert" menu to bring up the "Field" settings panel.

​​Select "Formulas" under "Domain Name", select the appropriate number format, paste function and table range in the "Auxiliary" item on the right, and you can generate standardized functions and formulas in the "Field Code" column.

The above is an introduction to the simple formula operations that can be performed after inserting a table into WPS text. Formulas in the table include quadrature, discontinuous sum, and graph modes. These basic calculations can help users save unnecessary trouble to a certain extent. I hope the above tips are helpful to you.