Formulas

[Gillman]

I am creating a Service Contract for my company that has a price list and equipment schedule. Due to the sizing problems in Excel, I chose Word.

My question is: I cannot get the formulas in the tables to work after saving document as a template. Needs to be similar to Excel. I need to formula to calculate quantitiy of unit with unit cost to equal total cost. The figures for this are in a row. Then I need the total cost figures to be summed up in the grand total cell. The figures for this are in a column. I want this form/template to be interactive to type in price, quantity and to add up for grand total. Any help is greatly appreciated.

 

[Doug Robbins - Word MVP]

See

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

I am creating a Service Contract for my company that has a price list and

equipment schedule. Due to the sizing problems in Excel, I chose Word.

My question is: I cannot get the formulas in the tables to work after

saving document as a template. Needs to be similar to Excel. I need to
formula to calculate quantitiy of unit with unit cost to equal total cost.
The figures for this are in a row. Then I need the total cost figures to be
summed up in the grand total cell. The figures for this are in a column. I
want this form/template to be interactive to type in price, quantity and to
add up for grand total. Any help is greatly appreciated.