Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas in Word Tables
Can multiplication formulas (ae) be placed in a Word
table? |
#2
|
|||
|
|||
Dave
See the following FAQ: http://word.mvps.org/FAQs/General/ToolsCalculate.htm -- Terry Farrell - Word MVP http://word.mvps.org/ "Dave" wrote in message ... : Can multiplication formulas (ae) be placed in a Word : table? |
#3
|
|||
|
|||
Thanks Terry. I'll give it a shot.
-----Original Message----- Dave See the following FAQ: http://word.mvps.org/FAQs/General/ToolsCalculate.htm -- Terry Farrell - Word MVP http://word.mvps.org/ "Dave" wrote in message ... : Can multiplication formulas (ae) be placed in a Word : table? . |
#4
|
|||
|
|||
Terry,
After 3 tries I got the ToolsCalculate into the Tools menu. Nothin. (P.S. How do I remove it from the toolbar where it now resides twice?) What I'm trying to do is create a blank purchase requisition form where in one cell you can put the quantity; in the next cell to the right the price per each; and have the next cell to the right give the total. -----Original Message----- Dave See the following FAQ: http://word.mvps.org/FAQs/General/ToolsCalculate.htm -- Terry Farrell - Word MVP http://word.mvps.org/ "Dave" wrote in message ... : Can multiplication formulas (ae) be placed in a Word : table? . |
#5
|
|||
|
|||
Right click the menu and click customize. Drag the Calculate icon off the
menu and drop it in the document. For your form requirement see: You should get a good start here and the linked articles by Dian Chapman: http://word.mvps.org/faqs/customizat...nTheBlanks.htm That link will show you how to set up forms. Your basic calculation is: A1 B1 C1 5 $2.00 {=(a1*b1)} The field code braces { } are entered with CTRL+F9. Toggle the field code to display the result with ALT+F9. When a change is made, you can update the field by selecting the field and pressing F9, or update all fields by pressing CTRL+a (selects all) and pressing F9, toggling to and from print preview (if "Update Fields" is checked in the FilePrintOptions dialog box), or running a macro something like: Sub UpdateFields() Dim oStory As Range For Each oStory In ActiveDocument.StoryRanges oStory.Fields.Update If oStory.StoryType wdMainTextStory Then While Not (oStory.NextStoryRange Is Nothing) Set oStory = oStory.NextStoryRange oStory.Fields.Update Wend End If Next oStory Set oStory = Nothing End Sub -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. wrote: Terry, After 3 tries I got the ToolsCalculate into the Tools menu. Nothin. (P.S. How do I remove it from the toolbar where it now resides twice?) What I'm trying to do is create a blank purchase requisition form where in one cell you can put the quantity; in the next cell to the right the price per each; and have the next cell to the right give the total. -----Original Message----- Dave See the following FAQ: http://word.mvps.org/FAQs/General/ToolsCalculate.htm -- Terry Farrell - Word MVP http://word.mvps.org/ "Dave" wrote in message ... Can multiplication formulas (ae) be placed in a Word table? . |
#6
|
|||
|
|||
Excellent. Thanks very much.
-----Original Message----- Right click the menu and click customize. Drag the Calculate icon off the menu and drop it in the document. For your form requirement see: You should get a good start here and the linked articles by Dian Chapman: http://word.mvps.org/faqs/customizat...linTheBlanks.h tm That link will show you how to set up forms. Your basic calculation is: A1 B1 C1 5 $2.00 {=(a1*b1)} The field code braces { } are entered with CTRL+F9. Toggle the field code to display the result with ALT+F9. When a change is made, you can update the field by selecting the field and pressing F9, or update all fields by pressing CTRL+a (selects all) and pressing F9, toggling to and from print preview (if "Update Fields" is checked in the FilePrintOptions dialog box), or running a macro something like: Sub UpdateFields() Dim oStory As Range For Each oStory In ActiveDocument.StoryRanges oStory.Fields.Update If oStory.StoryType wdMainTextStory Then While Not (oStory.NextStoryRange Is Nothing) Set oStory = oStory.NextStoryRange oStory.Fields.Update Wend End If Next oStory Set oStory = Nothing End Sub -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. wrote: Terry, After 3 tries I got the ToolsCalculate into the Tools menu. Nothin. (P.S. How do I remove it from the toolbar where it now resides twice?) What I'm trying to do is create a blank purchase requisition form where in one cell you can put the quantity; in the next cell to the right the price per each; and have the next cell to the right give the total. -----Original Message----- Dave See the following FAQ: http://word.mvps.org/FAQs/General/ToolsCalculate.htm -- Terry Farrell - Word MVP http://word.mvps.org/ "Dave" wrote in message ... Can multiplication formulas (ae) be placed in a Word table? . . |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating forms | Microsoft Word Help | |||
how can you create quickwords in MS Office Word 2003 | Microsoft Word Help | |||
Basic macros query - where are they assigned to? | New Users | |||
In typing dates in Word, i.e. "January 12" how do you keep the "1. | Microsoft Word Help | |||
word xp crashes after macros are recorded | Microsoft Word Help |