Microsoft Word add formula
We’ll discuss how to add formulas to tables in Word 2010.
Microsoft Word allows you to use mathematical formulas in table cells that you can use to add numbers, average numbers, or find the largest or smallest number in a table cell that you specify.
There is a list of formulas and you can choose from as many formulas as you need. This chapter will teach you how to use formulas in word lists.
Following are the simple steps to add formulas in table cells available in Word documents.
Step 1 − Consider the total number of rows in the table below. Click on the cell that should contain the row sum.
Step 2 – Now click on the “Layout” tab and then the “Formula” button; this will bring up a formula dialog which will suggest a default formula, in our case =SUM(LEFT). You can use the Number Format list box to select a number format to display the results, or use the Formula list box to change the formula.
Step 3 − Now click OK to apply the formula and you will see that the left cell has been added and the sum has been put into the total cell we want. You can also repeat the process to get the sum of the other two rows.
The formula dialog provides the following important functions that can be used as formulas in cells.
1: Average ( )
Average of a list of cells
2: count ( )
the number of items in the cell list
3: Maximum ( )
Maximum value in cell list
4: Minimum value ( )
Minimum value in cell list
5: Product ( )
Multiplication of cell lists
6: Sum( )
Sum of list of cells
We assume you are familiar with how to create spreadsheet programs; you can build your word cell formulas. Word formulas use the reference system to refer to individual table cells. Each column is identified by a letter, with the first column starting with A, the second with B, and so on. The letter is followed by the line number. So the first cell in the first row is A1, the third cell in the fourth row is C4, and so on.
Here are useful points to help you build word cell formulas.
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 single cells, e.g. A3, B4, C5
4: ABOVE, which refers 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, refers to all cells in the row to the left of the current cell
7: RIGHT, refers to all cells in the row to the right of the current cell
You can also use simple math operators +, -, /, , % to construct simple math expressions, such as B3+B510 .