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 •

March 3, 2010 at 06:38:41

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

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"


Report •

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