web analytics

USING POSITIONAL ARGUMENTS IN MS WORD 2013

Microsoft Word 2013

The positional arguments in MS Word helps you to refer to the specific cell range according to the position of the current i.e. selected cell. The applied positional argument determines the direction of the cell’s ranging. The entered positional arguments always calculate the range beginning with the cells that are adjacent to the current cell. You can combine two positional arguments to calculate the cells that are in the same row and column with the current cell.

01 - formula dialogue box

When typing the formula in Formula textbox, you may enter different positional arguments depending on the cells that you want to be calculated. There are four positional arguments:

  • ABOVE
  • BELOW
  • LEFT
  • RIGHT

Different types of arguments have different meaning and they all have to be entered between the brackets of the function like: =SUM(ABOVE); =AVERAGE(LEFT); =MAX(RIGHT); =MIN(BELOW) etc.

The ABOVE argument, calculates the numbers in the cells that are above the formula cell and that belong to the same column as the formula cell.

01 - formula dialogue box

If you add the “=SUM(ABOVE)” formula to particular cell through the Formula icon from the TABLE-TOOLS, LAYOUT tab, this will sum all the numbers from the cells above.

02 - argument above

If the cell with 9000 number is empty and you add formula “=SUM(ABOVE)” you will get the sum of all cells that are above the formula cell and that are in the same column with the formula cell: 2000 + 4000 + 3000 = 9000.

03 - argument below

Adding the “=PRODUCT(BELOW)” formula in the cell with value 216 while is empty, gives the product from the multiplied cells that are below the formula cell and that are in the same column with the formula cell: 2 x 4 x 3 x 9 = 216.

04 - argument left

If the cell with number 5000 is empty and you add the “=AVERAGE(LEFT)” formula to this cell, you will get the number 5000, because the average from the cells left from the formula cell is 5000, (8000 + 4000 + 3000)  / 3 = 5000.

05 - argument right

If you add the formula “=SUM(RIGHT)” in the cell with number 10000 while is empty, the cell will sum every cell that is right from the formula cell. 4000 + 3000 + 3000 = 10000.

Great thing is that you can combine two arguments in one formula as: =SUM(LEFT,ABOVE), =SUM(LEFT,BELOW), =AVERAGE(RIGHT,ABOVE),  =AVERAGE(RIGHT,BELOW), etc.

06 - argument left - above

Adding the formula “=SUM(LEFT, ABOVE)” to the bottom right cell while is empty, gives you the number of 20500 which is the sum of the cells above and left from the formula cell: 10000 + 4000 + 3000 + 2000 + 500 + 1000 = 20500.

07 - argument right = below

In the top left cell from the table add the formula “=SUM(RIGHT,BELOW)” while the cell is empty and you will get the number 32000. The formula cell is the sum of the cells right and below the formula cell: 3000 + 6000 + 2000 + 4000 + 7000 + 10000 = 32000.

You can use the same logic for the other positional arguments combinations, but remember that when combining two arguments you should first enter the LEFT or the RIGHT argument and then the ABOVE or BELOW argument. Also, is very important that you can combine together LEFT and RIGHT arguments as “=SUM(LEFT,RIGHT)” or BELOW as first and ABOVE as second argument like “=SUM(BELOW,ABOVE)”.

 

Leave a Reply