If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formulas
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. |
#2
|
|||
|
|||
Formulas
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 "Gillman" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|