How to Add a Formula to a Microsoft Word Table

How to Add Formulas to a Table in Microsoft Word

This tutorial describes how to add formulas to a Ms Word table. In reports, proposals, and similar documents, tables provide a structured way to display data. If you have Excel data, you can embed it in your Word document. But otherwise, you can create a table directly in Word and include the formula or formulas quickly.

Maybe you have a product, sales or location table. You can easily enter calculations for total product cost, average number of sales, or number of locations. With the data in your table, it only takes a few clicks to add a formula.

How to Add Formulas to a Table in Microsoft Word

How to add a formula to a table in Microsoft Word: Select table cell >> Open tab Layout >> Select Formula >> Enter the formula which is desired.

After you insert or draw a table in Microsoft Word and fill it with data, select the cell where you want to add the formula.

Then, go to the Layout tab that appears. Move to the right side of the ribbon and click “Formula” in the Data section.

How to Add a Formula to a Table in Microsoft Word-3

When the Formula window opens, it’s time to start entering the formula you want.

Similar to Excel, Word tries to detect what you are trying to do. So, you might see a general formula, like SUM or AVERAGE and it’s ready to go.

How to Add a Formula to a Table in Microsoft Word-4

If this is what you want, click “OK”, and the formula will be applied. The result will appear in the cell.

To use different formulas, functions, or groups of cells, you can use the Formulas window to set them all up.

Insert Formulas to Tables in Word

Start your formula with an equal sign, then type a formula, such as AVERAGE, COUNT, or PRODUCT.

In the brackets, add the cell position that you want to use for the formula. Use the ABOVE, BELOW, LEFT, and RIGHT positions. You can also combine positions, depending on the cell location in relation to the formula. For example, you can use LEFT, RIGHT for cells on left and right or LEFT, ABOVE for cells on left and above cells.

How to Add a Formula to a Table in Microsoft Word-5

Also read: 5 Ways to Insert Math Symbols in Word

Number Format

Choose a format for the result such as currency, percent, integer, or decimal. If you don’t choose a format, your results will match the default cell format.

How to Add a Formula to a Table in Microsoft Word-6

Paste Function (Paste)

To speed up the process, you can select a function from the Paste function drop-down list. This places the function in the Formula box, where you can simply add its position. You will find almost 20 common functions in the list.

How to Add a Formula to a Table in Microsoft Word-7

When you are done, click “OK” to apply the formula to the cells. You should see the results instantly.

Example of SUM Rumus Formula

In this first example, we want to see the maximum quantity for our product. We enter SUM (ABOVE) and click “OK” in each cell where we want the number. Then, we look at the largest number for the cell above the formula.

How to Add a Formula to a Table in Microsoft Word-1

AVERAGE Formula Example

In this second example, we want the average cost and selling price for our product. we enter AVERAGE (ABOVE) and click “OK” to see the formula result.

How to Add a Formula to a Table in Microsoft Word-2

Update Formulas in Word

Microsoft Word will update your formula every time you open your document. But you can also update the formula manually as you continue working on the document. Here’s how to do it:

Select the result of the formula. Make sure you actually select the result, not the cell. Then, right click and select “Update Field” from the menu.

When you add data to a table in Microsoft Word using simple calculations, keep these tips in mind!

That’s the tutorial on how to add formulas to tables in Word. Hopefully this tutorial is useful for those of you who need it. Thank you for visiting and don’t forget to share it with your friends too.

Leave a Reply

Your email address will not be published.