Using the table calculation function in WPS text tutorial

Source: Internet
Author: User

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, enter "=sum (B2:D2,G2)", and then press F9 to get the correct result.

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

11.11 Big Sale for Cloud

Get Unbeatable Offers with up to 90% Off,Oct.24-Nov.13 (UTC+8)

Get It Now >

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.