How to perform calculation in Ms Word table
Here are the steps on how to insert calculations in an MS Word table, accompanied by visual aids:
1. Position the Cursor:
- Click within the cell where you want the calculation result to appear.
2. Access the Formula Menu:
- Navigate to the Layout tab under Table Tools.
- Locate the Data group and click on the Formula button (it has an “fx” symbol).
3. Formula Dialog Box:
- The Formula dialog box will open.
- Review the formula preset: Word often suggests a formula based on the cell’s position. If it’s correct, proceed to step 6.
- Edit or create a new formula: If needed, modify the formula or type a new one in the Formula box.
4. Common Formulas:
- SUM(ABOVE): Adds the numbers in the column above the current cell.
- SUM(LEFT): Adds the numbers in the row to the left of the current cell.
- AVERAGE(ABOVE): Calculates the average of the numbers in the column above.
- PRODUCT(LEFT): Multiplies the numbers in the row to the left.
- COUNT(ABOVE): Counts the number of cells containing numbers in the column above.
5. Customize Formula (Optional):
- Change function: Click Paste Function to select a different function.
- Reference specific cells: Type cell references directly within parentheses (e.g., =SUM(A1,B2)).
6. Apply Formula:
- Click OK to insert the formula and display the result in the cell.
7. Update Results (Manually):
- Right-click the cell with the formula and select Update Field.
- Alternatively, press F9.
Key Points:
- Formulas in Word tables are not as dynamic as Excel spreadsheets. They update when the document opens or when manually refreshed.
- Use bookmarks for more complex calculations or referencing cells from different tables.
- Format the result as desired using the Number Format dropdown in the Formula dialog box.