Generally, only some simple tables can be made in Word. If some complex formula operations are included, we often choose to use Excel tables to complete them. In fact, we can also use some simple formula operations in Word tables, such as summing in Word tables, average value insertion fields, and so on.
Use "Table" → "Formula"
① Place the insertion point in the cell where the calculation results are stored. Click Table ->Formula... to open the Formula dialog box.
② You can modify or enter a formula in the Formula box; In the Paste Function combo box, you can select the desired function, and the selected function will be automatically pasted into the Formula box; In the "Number Format" box, you can select or customize the number format. In this example, it is defined as "0.0", which means to reserve a decimal place after the decimal point.
③ After setting, click OK. The dialog box closes and the calculated result appears in the cell.
Insert → Field... → Formula
You can maintain the default domain name option by clicking Insert ->Domain..., and then click Formula... on the right. The Formula dialog box also appears.
Enter the field code directly
Place the insertion point in the cell where you want to store the results, press CTRL+F9 to insert the field ID "{}" (note: it cannot be entered directly with the keyboard), enter a formula consisting of "=", function, value and cell name, and then right-click it, and select "Switch Field Code" to display the results calculated by the formula.
Using the AutoSum button
For simple summation of row and column data, the Auto Sum button on the Table and Border toolbar can be used for fast calculation.
Tips
① The name of a cell in a Word table is a combination of the serial number of the column and row where the cell is located. The column number precedes the line number. For example, the cell name of the second row of the third column is c2. The case of letters is common, and the use method is the same as that in Excel.
② In the summation formula, "LEFT" or "ABOVE" will appear by default, which means to calculate the data in the left continuous cell of the cell where the formula field is located and the above continuous cell, respectively.
③ After changing the values of some cells, the results of some fields may not be updated at the same time. You can select the entire table and press F9 to update the results of all formula fields in the table.
④ Formula fields are not only used in tables, but also can be used in text, headers, footers, and even text boxes.
