Reply
 
Thread Tools Display Modes
  #1   Report Post  
Dave
 
Posts: n/a
Default Formulas in Word Tables

Can multiplication formulas (ae) be placed in a Word
table?
  #2   Report Post  
TF
 
Posts: n/a
Default

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   Report Post  
Dave
 
Posts: n/a
Default

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   Report Post  
 
Posts: n/a
Default

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   Report Post  
Greg Maxey
 
Posts: n/a
Default

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   Report Post  
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
creating forms Fluffypink Microsoft Word Help 4 March 9th 05 04:17 PM
how can you create quickwords in MS Office Word 2003 Christine S Microsoft Word Help 4 February 8th 05 03:01 PM
Basic macros query - where are they assigned to? Bert Coules New Users 15 January 18th 05 12:28 PM
In typing dates in Word, i.e. "January 12" how do you keep the "1. Carol Microsoft Word Help 2 January 12th 05 08:09 PM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM


All times are GMT +1. The time now is 06:58 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"