Word table Data Arithmetic techniques

We often use Word to make tables, and sometimes the data in the table is to be calculated, and the ability of the Word table data can not be compared with Excel. However, the common multiplication plus and minus, adjacent data accumulation, the amount of digital automatically into uppercase, Word can be automatically completed in the table. Here's a simple example:

? First, figure 1 is a table of the purchase contract, the red number in the table is the result of the data operation in the table, equation 2 shows.

Figure 1 Word table data operation case diagram 2 Word table formula and display format

Two, Word form formula case analysis

1. The unit price in the table is the sum of "fuselage" and "bag Rat", and the formula can be {=sum (left)}.

Operation Method: First set the cursor in the table needs to enter the formula in the cell, (200?3 version) hit the main Menu "table", select the "Formula" submenu, Interface 3. The Formula dialog box automatically displays an example, and this example is coincidentally correct, meaning to add the left. Similar to the high version method, the formula for version 2010 is on the right side of the Layout tab.

Figure 3 The formula for the unit price cell automatically

2. The "Amount" in the table is "unit price" multiplied by "quantity", the formula is {=abs (F2) *abs (G2) \# "￥###,0.00"},4 manual entry. The function "ABS ()" can be directly in the "Paste Function" selection (5), the function of F2 or g2 similar to the cell address of Excel, F2 refers to the 2nd row of column F (the value of the unit price), G2 refers to the 2nd row of column G (the number of values), followed by the number format, in the Formula dialog box

Figure 4 Case diagram of Word table data multiplication 5 Formula tab

3. There is only one item in the table, the lowercase amount is only 5, the formula is {=abs (H2) \# "￥###,0.00"}

? 4. Capitalization of the total amount in the table can be converted automatically, 6. The formula calls the value of the H2 cell, and the "CHINESENUM2" format turns it into an uppercase number.

How to do: the cursor points to the formula, right-click, select "Switch field code", the complete record of the line. Note that it must be entered accurately within curly braces. Other formulas can be changed in the same way

5. If the value of the table formula call cell is changed, the associated formula value will not be updated automatically as Excel does. You must right-click on the formula and select Update field on the menu to perform the formula's operation.

Word table Data Arithmetic techniques