A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formulas



 
 
Thread Tools Display Modes
  #1  
Old June 16th, 2004, 03:55 PM
Gillman
external usenet poster
 
Posts: n/a
Default 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  
Old June 17th, 2004, 10:23 AM
Doug Robbins - Word MVP
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.