How to Insert Table Formulas in Microsoft Word for Calculations

Sponsored Links

We can insert formulas in Microsoft Word to perform simple calculations. We can insert table formulas in Word that are addition, subtraction, multiplication, and division of numbers in the table cells. We can insert formulas into the cells where we  intend to show the answers to the mathematical operations performed by the formulas.

How to Insert Table Formulas in Word for Calculations?

  • To insert the table formulas in Word, click on the table cell where you want to display the answer to be formula.
  • Now click on the Layout tab of the Table Tools contextual tab in the Ribbon.
  • Click on the Formula button in the Data group to open the Formula dialog box.
  • Now click into the Formula text box and enter the formula for the required calculation.
  • To format the display of the number, we can use the Number format drop-down.
  • To select a function to add to the formula in the Formula text box, we can use the Paste function drop-down.
  • Click OK button to insert the formula field into the selected cell.

How to Sum a Column or Row of Numbers in a Table in Word?

  • In the word document, click the table cell where you want your result.
  • In the Layout menu click on formula from Table Tools menu.
  • Now from the Formula box, check the text between the parentheses to make sure Word includes the cells you want to sum, and click the OK.
  • For example, if you select the, =SUM(ABOVE) adds the numbers in the column above the cell you’re in.
  • For example, if you select the, =SUM(LEFT) adds the numbers in the row to the left of the cell you’re in.
  • For example, if you select the, =SUM(BELOW) adds the numbers in the column below the cell you’re in.
  • For example, if you select the, =SUM(RIGHT) adds the numbers in the row to the right of the cell you’re in.

How to Include Average & Product in a Table in Word?

  • In the word document, click the table cell where you want your result.
  • In the Layout menu click on formula from Table Tools menu.
  • Now from the Formula box, delete the sum formula, then click the paste function box and select the function you want to check ( Average or Product) check.
  • Now between the parentheses, type the cell numbers to include the formula and click the OK button.
  • Type ABOVE to include the numbers in the column above the cell you’re in.
  • Type LEFT to include the numbers in the row to the left of the cell you’re in.
  • Type BELOW to include the numbers in the column below the cell you’re in.
  • Type RIGHT to include the numbers in the row to the right of the cell you’re in.
  • Coming to the Average calculation, to average numbers in the row to the left of the cell, click AVERAGE and type LEFT:=AVERAGE(LEFT)
  • Coming to the multiplication, to multiply two numbers, click PRODUCT and type the location of the table cells: =PRODUCT(ABOVE)

Leave Comment

Your email address will not be published. Required fields are marked *