Table calculation in WPS text

Some netizens have already got the WPS version of the new engine, and are pleasantly surprised to find that the form in the text can be easily calculated.

Or, after looking at a simple table-counting button on a common work bar, you will find that the table calculation function is too weak to calculate the sum, average, maximum, and minimum values. In fact, the WPS text has been fully prepared for more complex computations, just not shown in the interface. As the following table, is made with the new version of the WPS text, when the basic data changes, select the full table, and press the shortcut key F9, you can quickly update the results of the calculation.

Here's a description of the formulas in the table:

1, the product: In the common toolbar in the "Quick calculation" button does not quadrature operations, but we can manually enter the formula. In the table above, position the cursor in the cell where the overtime pay is John, press CTRL+F9 to insert the field, enter "=e2*f2" in the curly braces, and then click F9, which shows "100". Alternatively, if multiple cell Mercer multiply, you can also use the Quadrature function (product), such as John Overtime can be changed to "=product (E2:F2)".

2, not continuous sum: If John's "Total" item, is the basic salary, the living allowance, the hardship subsidy and the overtime pay and so on 4 items of sum, but if uses the commonly used toolbar the "Sum" button, then will "overtime standard" and "the Overtime Day" also add, does not conform to the actual situation. What do we do? We position the cursor in the John "Total" item, press CTRL+F9, insert a field, and enter "=sum (B2:D2,G2)" in which to get the correct result after the F9.

3, Graphics mode: If you think that the above manual input more trouble, you can also take a graphical model to calculate. Position the cursor in the cell where you want to generate the results, and then select fields from the Insert menu to bring up the Fields Setup Panel.

You can generate canonical functions and formulas in the field codes column by selecting formulas under domain name, and selecting the appropriate number format, Paste function, and table range in the auxiliary item on the right.