## USING POSITIONAL ARGUMENTS IN MS 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.

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.

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.

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.

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.

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.

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.

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.

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

You must be logged in to post a comment.