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 in tables



 
 
Thread Tools Display Modes
  #1  
Old February 16th, 2010, 04:49 AM posted to microsoft.public.word.tables
John Gee[_2_]
external usenet poster
 
Posts: 12
Default Formulas in tables

I looked in help, no luck, searched this forum, no luck. Simple qestion. How
do i put a formula in a word 2007 table. All i want to do is 1) multiply one
cell value times another cell value, and 2) total the two columns.

Thanks.
  #2  
Old February 16th, 2010, 05:13 AM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Formulas in tables

Formula fields haven't changed, so if you knew how to write one in an
earlier version, you can do it the same way in Word 2007. That is, if you
can construct an = field by hand, you can still do so. Or if you were using
Insert | Field, then you can still use Insert | Text | Quick Parts | Field.
If you depended on Table | Formula, then you will find the Formula button at
the right end of the contextual Table Tools | Layout tab of the Ribbon.
Table cells are still referenced in the same way as before; for more on
that, see
http://office.microsoft.com/en-us/wo...CH060831631033
or pp. 20ff of
http://office.microsoft.com/download...AM103824421033

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"John Gee" wrote in message
...
I looked in help, no luck, searched this forum, no luck. Simple qestion.
How
do i put a formula in a word 2007 table. All i want to do is 1) multiply
one
cell value times another cell value, and 2) total the two columns.

Thanks.


  #3  
Old February 16th, 2010, 05:33 AM posted to microsoft.public.word.tables
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default Formulas in tables

Hi John,

Further to Suzanne's post, to see how to do a wide range of calculations in Word, check out my Word Field Maths Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party


--
Cheers
macropod
[Microsoft MVP - Word]


"John Gee" wrote in message ...
I looked in help, no luck, searched this forum, no luck. Simple qestion. How
do i put a formula in a word 2007 table. All i want to do is 1) multiply one
cell value times another cell value, and 2) total the two columns.

Thanks.

  #4  
Old February 16th, 2010, 05:55 PM posted to microsoft.public.word.tables
John Gee[_2_]
external usenet poster
 
Posts: 12
Default Formulas in tables

thanks for the two answers. I'll sort through the info and see what I can get
out of it. I know the Formula Button is of no help as it gives a default sum
formula and no options.

"John Gee" wrote:

I looked in help, no luck, searched this forum, no luck. Simple qestion. How
do i put a formula in a word 2007 table. All i want to do is 1) multiply one
cell value times another cell value, and 2) total the two columns.

Thanks.

  #5  
Old February 16th, 2010, 06:40 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Formulas in tables

I'm not seeing that at all. If I click the Formula button, I get a dialog
that shows a blank beginning with = for the formula, a dropdown for the
number format and a dropdown for the function. Even if SUM(ABOVE) or
SUM(LEFT) is filled in by default, you can delete that and choose a
different function.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"John Gee" wrote in message
...
thanks for the two answers. I'll sort through the info and see what I can
get
out of it. I know the Formula Button is of no help as it gives a default
sum
formula and no options.

"John Gee" wrote:

I looked in help, no luck, searched this forum, no luck. Simple qestion.
How
do i put a formula in a word 2007 table. All i want to do is 1) multiply
one
cell value times another cell value, and 2) total the two columns.

Thanks.



 




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 09:32 PM.


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