The following two methods:
Method 1: Use quick calculation
In order to help players who have not passed the level yet, let us learn about the specific puzzle solving methods. First, open WPS text and create or open a table. The style of the table is as shown in the figure below.
2. Select the data to be calculated.
3. Click "Quick Calculation" in the "Table Tools" tab and select the calculation method. Here we take average as an example.
4. The effect is as shown in the figure below.
Tips: To make the calculation appear below or on the right, you can do this.
(1) If you want to display it in the lower area, you can first select a column of data and use quick calculation, and then select other columns of data and then use quick calculation.
(2) If you want to display it in the right area, you can first select a row of data and use quick calculation, and then select other rows of data and then use quick calculation.
Method 2: Formula
In order to help players who have not passed the level yet, let us learn about the specific puzzle solving methods. First, open WPS text and create or open a table. The style of the table is as shown in the figure below.
2. Position the cursor in the calculated area, then select the "Table Tools" card and click "Formula".
3. Open the "Formula" dialog box, enter the formula (left sum: =SUM(LEFT)) in the "Formula" column, and then click "OK".
illustrate:
Right sum: =SUM(RIGHT)
Above sum:=SUM(ABOVE)
The sum below: =SUM(BELOW)
4. Select the data you just calculated and copy it.
5. Paste in the area that requires the same calculation, and then press the F9 key. The effect is as shown below.
6. You can use a method similar to the above to calculate the average. Results as shown below.
1. First open the WPS form on your computer and create a new blank document, as shown in the figure below.
2. Then randomly enter a few numbers into the table cells, and then perform the sum calculation on these numbers, as shown in the figure below.
3. First enter the = sign in cell F1, then click on cell A1, plus sign, cell B1, plus sign, cell C1, plus sign, cell D1, plus sign, and cell E1. , thus forming an addition formula in the upper input box, as shown in the figure below.
4. Next click the [Enter] button, and the result will be displayed in cell F1, as shown in the figure below.
5. The calculation method of subtraction, multiplication and division is the same as that of addition formula. You only need to change the plus sign to other format symbols, as shown in the figure below.
6. After entering the formula, click [Enter] to complete the calculation of addition, subtraction, multiplication and division formulas, as shown in the figure below.
Some netizens have already gotten the wps text beta version of the new engine, and were pleasantly surprised to find that the tables in the text can already perform simple calculations.
Or, after looking at the simple table calculation buttons on the commonly used workbar, you will feel that the table calculation function is too weak and can only calculate sum, average, maximum and minimum values. In fact, WPS text is fully prepared for more complex calculations, but it has not yet been displayed in the interface. The table below is made using the new version of WPS text. When the basic data changes, select all tables and press the shortcut key F9 to quickly update the calculation results.
Below we will explain the formulas in the table one by one:
1. Product: There is no product 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 curly brackets and then press F9 again, which will display “100”. In addition, if multiple cells are multiplied together, the product function (PRODUCT) can also be used. For example, Zhang San's overtime pay can be changed to "=PRODUCT(E2:F2)".
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. If you use the “sum” button on the common toolbar, then "Overtime pay standards" and "overtime days" will also be added, which is not consistent with the actual situation. How to do it? We position the cursor in Zhang San's "Total" item, press Ctrl F9, insert a field, and enter "=SUM(B2:D2,G2)" in it. After pressing F9, we can get the correct result.
3. Graphical mode: If you feel that the above manual input is 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 "Formula" under "Domain Name", select the appropriate number format, paste function and table range in the "Auxiliary" item on the right to generate standardized functions and formulas in the "Field Code" column.
You can refer to the following operations:
First open the WPS form on your computer and create a new blank document, as shown in the figure below.
2. Then randomly enter a few numbers into the table cells, and then perform the sum calculation on these numbers, as shown in the figure below.
3. First enter the = sign in cell F1, then click on cell A1, plus sign, cell B1, plus sign, cell C1, plus sign, cell D1, plus sign, and cell E1. , thus forming an addition formula in the upper input box, as shown in the figure below.
4. Next click the [Enter] button, and the result will be displayed in cell F1, as shown in the figure below.
5. The calculation method of subtraction, multiplication and division is the same as that of addition formula. You only need to change the plus sign to other format symbols, as shown in the figure below.
6. After entering the formula, click [Enter] to complete the calculation of addition, subtraction, multiplication and division formulas, as shown in the figure below.
The above is the detailed content of Is there any wps tool that can directly calculate numbers?. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
