In Word, you can do other calculations in table such as average, production and so on. Click the blank cell you want to show the calculated result, then click layout Formula. Write a formula using the function =SUM to add cells. When you first open the formula window, Word defaults to the formula =SUM (ABOVE). If you want to add all cells above the selected cell, you don't need to change anything. To add cells from a different direction, change the formula to =SUM (BELOW), =SUM (LEFT) or =SUM (RIGHT). = Formula Bookmark # Numeric Picture Calculates a number by using a mathematical formula. You can use the Formula command (Table menu) or press CTRL+F9 to insert a field in a table or in regular text.
| |
Learn to do basic calculations in Word tables.When you think calculations you probably think first of Excel and that is as it should be. However, when the calculation is required inside a document, you might prefer to create a table in Word and then, have Word do the math for you. Word has a cut down collection of handy formulas for adding numbers and doing a range of calculations on table data. I'll show you how to write formulas in Word tables to make calculations and and how to create a preformatted table and insert it into a document with one simple keystroke. Calculations in cellsYou can do calculations in a Word table when the cells contain values or numbers. To do this, you need to know the table cell references - in other words the column letter and row number of the cell. There is an old macro called TableCellHelper that you can still find and use that helps you do this. I wrote a post on it here and I have tested the instructions and it all works fine in all verions of Word up to and including Word 2013. Basically the cells are labelled like a worksheet by the column number and row letter. The top left cell is A1, the one to its right is typically B1 and the one below it is A2. Where this numbering system comes crashing to a halt is when you have merged cells. However, with the TableCellHelper macro you can check a table cell if you're unsure - just click on the cell and run the macro. Here are some typical table cell calculations that you might want to try out: Simple addition With one value in cell B2 and another in cell C2 you can total the result into cell D2. Click in cell D2, choose Table Tools > Layout > Formula. Type =B2+C2 in the Formula area. Select the desired format from the Number format list and click Ok. Understanding formulas While you can type =B2+C2 in an Excel cell, you can't do the same thing in a Word table. A table formula must be entered using the Table Tools > Layout > Formula menu command or added as a Word field. To see the field code that underlies a Word formula click on the formula and press Shift+F9. Write your own field code It is possible to write Word formulas by hand if you wish to do so. Click in the cell and press Control + F9 to add the field code braces. Now type the formula into the cell, for example, this calculates the percentage of the value in D2 that the value in C2 represents and formats the result as a percentage: = 100*C2/D2 # '0%' When you're done, press Shift+F9 to see the result. Recalculating formulas Unlike an Excel worksheet, Word formulas don't automatically recalculate so, when you change the value in a table, any formulas which use that value will show an incorrect result unless and until you force a recalculation. The same will be the case if you had a cell showing an Error messages - the error won't disappear until you force a recalculation to be made. To force the recalculation, click in the formula's result or in the error so you have the underlying field code targetted and press F9. Summing a column To total a column of values in a Word table, click in the cell that should contain the answer, choose Table Tools > Layout > Formula and type the formula =sum(above). Referencing cells It is possible to reference a cell in a table outside the table. To do so you must first create a bookmark for the value by selecting the entire field code in the table and choose Insert > Bookmark > Name, type a name and click Add. To refer to the value in your text, click at the point to include the value and choose Insert > Quick Parts > Field and in the Field names list choose Ref and select the bookmark name you created. | |
(c) 2019, Helen Bradley, All Rights Reserved. |
- MS Word Basics
- Editing Documents
- Formatting Text
- Formatting Pages
- Working with Tables
- Advanced Operations
- Word Useful Resources
- Selected Reading
Calculations In Word
In this chapter, we will discuss how to add formula to a table in Word 2010. Microsoft Word allows you to use mathematical formula in table cells which can be used to add numbers, to find the average of numbers, or find the largest or the smallest number in table cells you specify. There is a list of formulae, you can choose from the many based on the requirement. This chapter will teach you how to use formula in word tables.
Add a Formula
Following are the simple steps to add formula in a table cell available in Word document.
How To Add Formula In Word 2016
Step 1 − Consider the following table with the total number of rows. Click in a cell that should contain the sum of the rows.
Step 2 − Now click the Layout tab and then click the Formula button; this will display a Formula Dialog Box which will suggest a default formula, which is =SUM(LEFT) in our case. You can select a number format using Number Format List Box to display the result or you can change the formula using the Formula List Box.
Step 3 − Now click OK to apply the formula and you will see that the left cells have been added and the sum has been put in the total cell where we wanted to have it. You can repeat the procedure to have the sum of other two rows as well.
Cell Formulae
The Formula dialog box provides the following important functions to be used as formula in a cell.
| S.No | Formula & Description |
|---|---|
| 1 | AVERAGE( ) The average of a list of cells |
| 2 | COUNT( ) The number of items in a list of cells |
| 3 | MAX( ) The largest value in a list of cells |
| 4 | MIN( ) The smallest value in a list of cells |
| 5 | PRODUCT( ) The multiplication of a list of cells |
| 6 | SUM( ) The sum of a list of cells |
We assume you are familiar with how to create a spreadsheet program; you can construct your word cell formula. Word formulae uses a reference system to refer to an individual table cells. Each column is identified by a letter, starting with A for the first column, B for the second column, and so on. After the letter comes the row number. Thus, the first cell in the first row is A1, the third cell in the fourth row is C4, and so on.
Following are useful points to help you in constructing a word cell formula.
| S.No | Cell References and Description |
|---|---|
| 1 | A single cell reference, such as B3 or F7 |
| 2 | A range of cells, such as A4:A9 or C5:C13 |
| 3 | A series of individual cells, such as A3, B4, C5 |
| 4 | ABOVE, referring to all cells in the column above the current cell. |
| 5 | BELOW, referring to all cells in the column below the current cell. |
| 6 | LEFT, referring to all cells in the row to the left of the current cell |
| 7 | RIGHT, referring to all cells in the row to the right of the current cell |
You can also construct simple Math expressions, such as B3+B5*10 by using simple mathematical operators +, -, /, *, %.