Support

How to Use Formulas to Make Calculations in Table in Writer 2013

There are three methods to use formulas for calculation purposes in tables using Writer 2013. Follow this guide to use formulas.

Method 1

Step 1 Automatically make calculations by the Formula icon.

Step 2 In the Table Tools tab, click the Formula icon formula in table and open the Formula dialog box:

use formula in table in writer

Figure 1 The Formula dialog box

Step 3 In the Formula enter box, modify or enter the formula.

Step 4 In the Number format enter box, choose or customize the number format.

Step 5 In the Paste function drop-down list, choose the required function. The selected function will automatically paste to the Formula enter box.

Step 6 In the Table area drop-down list, choose the required area. The selected area will automatically update the corresponding parameter of the function in the Formula enter box.

Step 7 Click OK to close the dialogue box. The calculation result will then be shown in the cell.

Method 2

Step 1 In the Insert tab, click the Fields icon field in table of writer and open the Fields dialog box.

Step 2 You can enter the corresponding formula in the Field Codes enter box. See the following figure:

insert field in table of writer

Figure 2 The Fields dialog box

Step 3 When finished, right-click and select the Toggle Field Codes option in the drop-down menu to yield results.

Method 3

Step 1 Place the insertion point in the cell where you want the calculation results to be displayed, and then press <Ctrl+F9> to insert the field markup { }.

Step 2 Enter the formula consisted by =, function, number and cell name.

Step 3 Right-click and select the Toggle Field Codes option in the drop-down menu. The formula calculation result will then be displayed.

Note: Do not use the keyboard to insert the field markup.