How do I calculate data in a Word table?

As we all know, Excel is the master of data calculation and analysis, our daily life when we use Word, there is a need to calculate the data in the Word table, we think of using an Excel spreadsheet to process, and then fill the data into the corresponding cells, but we also understand that If you use an Excel spreadsheet to calculate this data one by one, once the data needs to be modified, we need to rework the data, which obviously adds a lot of work and slows the progress. So, if we can compute the table cell data directly in the Word document, we can save the hassle.

In fact, the WORD software itself provides a number of functions for basic operations, which are implemented through the "domain". Here we'll learn how to do table cell data in Word software by explaining the naming rules for Word table cells, the basics of formulas, and so on.

　1. Naming rules for WORD table cells

The name of a Word table cell is the same as the naming convention for Excel spreadsheet cells, is a combination of the column ordinal and the row ordinal of the cell, the column ordinal is in English and the letter of the column is uppercase and lowercase, and the row ordinal number is in numbers, the column number is the first, and the line number is after. The cells in column 3rd, line 3rd, are named C3. Cells can be referenced in the form of A1, A2, B1, and B2.

　　2, the basic knowledge of the table calculation formula in WORD

2.1, the formula of two forms of expression

The first manifestation of the ① formula is: "= Select function (parameter)", consisting of three parts, the specific meaning is as follows: "=": Indicates what the cell is equal to what Content selection function: A function parameter that represents what operation the data is selected for:

* Refer to specific cells as parameters

A when a discrete cell in a formula is referenced as a parameter, the cell names must be separated by commas, such as "=sum (A1,A2,C3,D5)", that is, the sum of the values of the A1,a2,c3,d5 four cells.

b When a cell that refers to a contiguous range is used as an argument, the first cell name and the end cell name must be separated by a colon, such as "=sum (A1:C3)", that is, the sum of the values of the A1,A2,A3,B1,B2,B3,C1,C2,C3 nine cells.

c When a cell that refers to a contiguous region is exactly the entire row or column, you can use 1:1 to represent the first row, 2:2 for the second row, a:a for the first column, and so on. Example: The formula {=sum (2:3)} represents the sum of all the data in the first to second two rows (Word automatically presses 0 when there is a blank cell), and the column's reference is consistent with the line's method, where it is no longer an example.

* With left, right, ABOVE English words as parameters

If the selected parameters are left, right, and ABOVE, then the data in the contiguous cell of the cell that contains the formula field is evaluated, respectively. such as "=sum (ABOVE)", which is the sum of the data in the cell above the formula field.

② because the functions available in Word for operations are very limited, if you need to-(subtraction), * (multiplication),/(division), ^ (power), and so on, the user can directly in the Formula dialog box or field area "{}" enter "= expression", so that can be easily-, *, /, ^ operations. Another manifestation of the formula is: "= expression", consisting of two parts. The specific meaning is as follows:

' = ': Indicates what the cell is equal to

Expression: An expression is a combination of numbers, arithmetic operators, numeric grouping symbols (parentheses), free variables, and constraint variables, which are derived from a meaningful permutation of values.

* If the expression is "=3*5", it means a product of 3 times 5.

* If the expression is "= (B2+B4) *2", then the sum of the data in the table B2 and B4 cells is multiplied by 2.

2.2, the input formula should pay attention to the matters

There are a number of ways to enter formulas, and here are just two input methods, one is to enter the formula using the Formula command in the Table Tools layout panel, the other is to enter the field code method directly.

When you use the Direct Insert field code, there must be a space between both ends of the brace "{}" and the content inside it. ' {} ' must be inserted with the CTRL+F9 key combination, not directly with the keyboard, and enter a formula consisting of "= Selected function (cell name and symbol)" or "= expression" in curly braces. All types of characters used in the entire formula should be entered in the English state, that is, half-width symbols, but not case-sensitive.

2.3, update the domain method

When the user modifies the data in some cells, the calculated results are not synchronized immediately, and in general, the results are updated in the following two ways.

(1) Position the mouse cursor over the domain area that you want to update, right-click, and select Update Field command.

(2) Select the entire table or entire Word document and press F9 to update it quickly.

2.4, modify the formula method

If the user accidentally enters the error and updates the field when entering the formula using a direct Insert field code, the "{}" in the domain area will appear as "Error syntax!" , the user simply clicks on the field to be modified, click the right mouse button, select the "Switch field code" command, at this point, the domain identification "{}" area also shows the user input formula, the user must enter the correct formula.

If the user enters a formula using the Formula dialog box, when you enter the formula and accidentally enter the error and click OK, then the user only need to select the domain area, and then click the "Table Tools" layout Panel formula command, in the pop-up Formula dialog box to remove the wrong formula, re-enter the correct formula can be.

　　3. Examples of how to calculate the data in the table and the steps

Method One: Direct input field code method

The specific method of operation is as follows:

1 position the cursor in the cell that holds the result of the calculation.

2) Press CTRL+F9 key combination? Insert Field identification "", where you enter a formula consisting of the = function (cell name or English character), such as the input formula "{=sum (B2:D2)}", which is the sum of the data in the B2,c2,d2 cell.

3 Click the right mouse button on the domain area, select "Update Field" or press F9 to display the results calculated by the formula. 4 Repeat the 1~3 step to calculate the other cells.

Method Two: Calculate the data in a table using the Formula command in the Table Tools layout panel

1 Place the mouse cursor in the cell where the result is stored, and then select the formula command under the Layout tab of the Table tool to pop up the formula dialog box.

2 in the Pop-up Formula dialog box, the user can enter the formula you want in the Formula text box, and select the data display format in the number format Drop-down list box, and then click OK.

3 Select and copy the calculated values, and then select the cells you want to add the same formula at once, right-click, select Paste, and paste the data into the corresponding cells.

4 Repeat the 1~3 step until you have set all the cells that you want to add the formula to.

5 Select the entire table and press the F9 key to update the field.