Reader Level:
Articles

Mathematical Formula in Word 2013

By Satya Prakash on October 23, 2012
This article describes the use of mathematical formulas in a Word table.
  • 0
  • 0
  • 9903

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.

Step 1

Suppose a table in your Word document contains employee's details. And you want to use a different mathematical formula of employee detail.

employee-detail-in-word2013.jpg

Step 2

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.

formula-dialog-box-in-word2013.jpg

Step 3

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.

formula-average-in-word201`3.jpg

Step 4

Here I have used =Average(LEFT) and then click on OK button.

get-average-in-word2013.jpg

Cell Formulas

The Formula dialog box contains some important functions to be used as a formula in a cell.

Formula Description
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

COMMENT USING

Trending up