MS Word Calculations

Microsoft Excel 2003 (full)
March 3, 2010 at 06:04:41
Specs: Windows XP, 1.0Gb
I have set up a table in Word with columns headers of "Hours", "Rate" and "Total". Is there a way where Word will multiply "Hours" by "Rate" and put the answer in "Total." Also, can a I sum the line totals for a grand total?

Thank you.


See More: MS Word Calculations

Report •


#1
March 3, 2010 at 06:38:41
Hi,

Use the field formulas

Assuming that you are using Word 2003, place the cursor in the table cell for the first hours x rate calculation
From the menu bar select Insert and Field...
Select =(Formula) from the field names: list
On the right click the Formula... button
Replace the default formula with something like this

=A2*B2
where A2 and B2 are table cell references.
(You can add number formatting later)
If you have some values in a column using the above formula, when you insert a formula field below them, Word will offer a default formula =SUM(ABOVE)

Number formating can be added by selecting the field and right-click and select 'Edit field' and click the formula button and enter a number format (there is a drop-down list for standard formats or enter your own).

If you select a field and right-click and select 'Toggle Field Codes' the number format will appear after the formula as something like this \#"00.00"


Regards


Report •

#2
March 3, 2010 at 10:48:56
Thank you for your quick response. I was able to do the needed calculations in Word.

Report •

Related Solutions


Ask Question