Word Table Formula

 How to Add Formula to a Table In Microsoft Word 2010

Microsoft Word allows you to use a mathematical formula in table cells that can be used to add numbers, find the average of numbers, or find the largest or smallest number in the table cells you specify. Is. There is a long list of formulas that can be used as needed. This Lecture will teach you how to use formulas in word tables.

Add a Formula:

The following are simple steps to add a formula to a table cell available in a Word document.

Step (1): Consider the following table where we will have total rows. Click on a cell that should contain a combination of rows. Payroll

Step (2): Now click on the Layout tab and then click on the Formula button which will show a Formula dialog box which will suggest a default formula, which in our case is = SUM (LEFT). You can select the number format using the number format list box to display the result or you can change the formula using the formula list box. Formula dialog box

Step (3): Now click on OK to apply the formula and you will see that the left cell has been added and its sum is inserted in the total cell where we wanted to place it. You can repeat this process to combine the other two rows. The sum of the results

 

Cell Formulas:

The Formula dialog box provides the following key functions for use as a formula in a cell.

Description of the formula

AVERAGE () Sales list average.

COUNT () Number of items in the cell list

MAX () Largest value in sales list

MIN () The smallest value in the sales list

PRODUCT () Multiply the list of cells

SUM () A list of sales lists

If you are familiar with the spreadsheet program, you can create your own Word Cell formula. Word formulas use a reference system to refer to individual table cells. Each column is identified by a letter, beginning with A for the first column, B for the second column, and so on. The letter is followed by a line number. Such, a first cell in the first row is A1, the third cell in the fourth row is C4, and so on.

Here are some helpful tips to help you create word cell formulas.

SN Cell References and Description

1 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 the cells in the column above the current cell

5 Below, referring to all the cells in the column below the current cell

6 LEFT, referring to all the cells in a row to the left of the current cell

7 Right, referring to all the cells in a row to the right of the current cell

You can also create simple math impressions, such as B3 + B5 * 10 using simple math operators +, -, /, *,%.