Word 2010 provides a great feature of using tables along with document content to complement and summarize it in a better way but sometimes in tables we also need to write formula for evaluation of values. Though it does not support huge range of formulas, we can use basic formulas which will be enough for most users. This post elaborates how to create and apply new design over table and how to yield desired result through formula with simple illustrations.
Launch Word 2010 document in which you want to calculate values using formula. For instance, we have included a document containing table. For inserting table, navigate to Insert tab and click Table. Now select the number of rows and columns, as shown in the figure below.
Start populating the cells with desired data.
If you want to give it a better look, select the table and you will notice two tabs on the ribbon; Design & Layout. You can change the design by navigating to Design tab and select suitable Style for the table from group Table Styles.
Click on the style you want to apply it over the table.
From Layout tab, you can customize the generic layout of the table, from Cell Size group, select the size of the cell, from Merge, you can use suitable option to merge cells, from Rows & Columns, you can insert new row or column in the table. From Table group you can insert gridlines, and view properties of the table.
Now we need to calculate the total Price of the products, click the cell Total in the table, and click Formula from Layout tab, as shown in the screenshot below.
Upon click, Formula dialog will appear. Under Formula, =SUM(ABOVE) is automatically inserted, this can evaluate sum of all the above values. From Number Format drop down list select one which includes dollar sign, as we are dealing with currency values, click OK to continue.
Upon click it will show sum of values.
You can also check out previously reviewed guides on How to Add dictionary in Word 2010 & Indexing in Word 2010.
Pingback: How to add in Word 2010? - FlyerTalk Forums