How to add, subtract, multiply and divide cells in a Word table

Word 365
Most of the people know that Word is for writing texts sometimes containing tables, and Excel is all about tables and calculations for them. But what if you need to create a Word table with formula. Do you need to create a table in Excel and insert it into Word? No, you don't. You can create formulas in Word to perform simple arithmetic calculations, such as addition, subtraction, multiplication, or division.

If you create the table in Excel and paste it into Word document, updates of the table data become difficult because you need to launch embedded Excel for each change. Moreover, the visual appearance of Word and Excel tables is different, and you will need a lot of time on the styling of the Excel table. For some situations, this is not practical because it is faster to insert and change simple formulas in the Word document (see How to reference a cell of a Word table):

Formulas in a table Word 2016

To add a formula into the Word table (see How to calculate formulas in a Word document if you need to use formulas without tables), do the following:

   1.   Position the cursor where you want to paste a formula.

   2.   Under Table Tools, on the Layout tab, in the Data group, click the Formula button:

Formula in Word 2016

   3.   In the Formula dialog box, enter the formula:

Formula dialog box in Word 2016

Unfortunately, Word proposes only simple operations and functions that can work without Excel (see Functions and formulas in Word). However, you still can create many simple formulas instead of using the calculator. Cell references in formulas are similar to Excel: A1, B12, etc.

Note: The Formula dialog box is not your only option, you can press Ctrl+F9 to create a field and type a formula inside the field braces:

Formula in the field Word 2016

See also this tip in French: Comment ajouter, soustraire, multiplier et diviser des cellules dans un tableau Word.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.