Microsoft Word also provides a feature for using mathematical formulas in table cells, that can be used to find average of numbers, or find the largest and smallest number or add a number in a table cell you specify. There are several mathematical formulas available in Microsoft Word.
This article describes the use of mathematical formulas in a Word table.
Add a Formula
There are some simple steps to add a formula in a table cell in a Word document.
Suppose a table in your Word document contains employee's details. And you want to use a different mathematical formula of employee detail.
Click in a cell that contains formula output. And go to Layout Tab and then click the Formula button that will display a Formula dialog box.
The Formula dialog box by default contains the formula =Sum(LEFT). You can change it using the Formula List Box and change the format using the Number Format List Box.
Here I have used =Average(LEFT) and then click on OK button.
The Formula dialog box contains some important functions to be used as a formula in a cell.
|SUM( ) ||The sum of a list of cells|
|PRODUCT( ) ||The multiplication of a list of cells|
|AVERAGE( ) ||The average of a list of cells.|
|COUNT( ) ||The number of items in a list of cells|
|MIN( ) ||The smallest value in a list of cells|
|MAX( ) ||The largest value in a list of cells|
If you are familiar with the Excel spreadsheet program, you can make your Word cell formula. Word formulas use a address system to refer to 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.
|SN ||Cell References and Description|
|1 ||ABOVE, referring to all cells in the column above the current cell.|
|2 ||BELOW, referring to all cells in the column below the current cell.|
|3 ||LEFT, referring to all cells in the row to the left of the current cell|
|4 ||RIGHT, referring to all cells in the row to the right of the current cell|
|5 ||A single cell reference, such as C4 or F7|
|6 ||A range of cells, such as A4:A9 or C5:C13|
|7 ||A series of individual cells, such as A3,B4,C5|