Posted by: blueangel | March 31, 2011

How to Apply Formula in Table in Word Document?

You have listened about applying formulas in table in excel sheet but many of you may not be aware of the fact that Microsoft Word allows you to apply formulas to perform calculations by using a mathematical formula. Command for applying formula is given through table menu. Here you are provided with special instructions for applying formula in table in word file. Basic arithmetic operators that are used to make a formula are discussed below:

  • “+” to sum up values
  • “-“to subtract values
  • “*”to multiply numbers
  • “/” to apply division in table
  • “A” to apply exponential power

Table Reference

Cells in table are referenced as A1, A2, A3 and so on. A letter will represent column A and letter B letter will represent column and so on. Number attached to each alphabet will show row number for instance A6 means first column and sixth row.

A               B              C

A1 B1 C1
A2 B2 C2
A3 B3 C3
A4 B4 C4
A5 B5 C5

You will use commas to separate out reference alphabets cells in formulas and a colon 10 to separate the references of first and last cells in a designated cells in designated range as shown in following example:

To calculate average of cells data, you will write cell reference as:

  • =average (bl: b3) =average (aI:b2)
  • =average (al: c2)   =average (al, a3, c2)

Here is another way to use references in the function:

  • Left: Reference to all cells to left side of selected cell
  • Right: Reference to cells to right side of selected cell
  • Above: Reference to all cells above the selected cell
  • Below: Reference all cells below the selected cell

For instance, formula to calculate sum of the cells above the select cell will be written as: =SUM (ABOVE). Follow the tips shared below to make calculations in the table:

  • Click the cell in which you want to see the result.
  • Click on table menu and then click Formula, “Formula” dialog box will appear.
  • Select a function from the paste function box for instance, SUM to calculate total of numbers.
  • To use contents of table cells, type the cell reference in parenthesis in formula. For instance, to take sum of numbers in Cells A1 and B4, formula will be written as: =SUM (a1:b4)

You can select any other operation from dialog box and click Ok to perform the operation.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: