01.Blogs :
clintz  

Word Tip: Calculations in Word tables

Ever needed to put tables in your documents?  Worse, you needed to make computations on them too!  Well you can actually can put computations on your tables in Word.

 

In the last column of the table (or wherever you need to perform the calculation) you need to put the formula.  To do this, go to Table | Formula, put the formula as you would normally do in Excel (e.g. =SUM or =A1+B1).  When using the table, you access the rows and columns as you would normally do in Excel (i.e. the first column on the first row is A1, the second column is B1 and so on).  So, if you had a table having one rows and four columns and you wanted to add up the entire row, just put the formula as: =A1+B1+C1+D1.

 

If you change the values in one of the columns you do not need to enter the formula again, all you have to do is go the columns where the formula is, right click on it and select Update field.  The field will be recomputed for you.

posted on Thursday, November 24, 2005 9:11 PM by clintz


 
03.UPDATE CALENDAR :
<November 2005>
SunMonTueWedThuFriSat
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

05.MY LINKS :

07.Subscriptions :

Subscriptions


© Copyright 2005 Microsoft Corporation. All Rights Reserved.
Terms of Use | Privacy Statement | Code of Conduct | Hosted by MaximumASP for Microsoft
WHO-BAR