Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Mike Mike is offline
external usenet poster
 
Posts: 229
Default Word 2007 Table Calculations

I created a simple table inventory form (in Word2000) that sums columns and
gives me a multiplication product result at the end of each row (i.e. column
headings: item #, Qty, Descr, Cost, Total) (and the old formula is
"=product(B2,D2)." For the life of me I cannot find out how to make the
thing work in a Word 2007 document. (Note: This table is in the middle of
another form that does not lend itself to Excel). Any suggestions on how to
get this thing to work
  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2007 Table Calculations

Use { = B2 * D2 }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Mike" wrote in message
...
I created a simple table inventory form (in Word2000) that sums columns and
gives me a multiplication product result at the end of each row (i.e.
column
headings: item #, Qty, Descr, Cost, Total) (and the old formula is
"=product(B2,D2)." For the life of me I cannot find out how to make the
thing work in a Word 2007 document. (Note: This table is in the middle of
another form that does not lend itself to Excel). Any suggestions on how
to
get this thing to work



  #3   Report Post  
Posted to microsoft.public.word.tables
Mike Mike is offline
external usenet poster
 
Posts: 229
Default Word 2007 Table Calculations

Thank you, that helped, but once I protect the document as a form, and fill
in the variable fields, I cannot get the result field to calculate.

"Doug Robbins - Word MVP" wrote:

Use { = B2 * D2 }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Mike" wrote in message
...
I created a simple table inventory form (in Word2000) that sums columns and
gives me a multiplication product result at the end of each row (i.e.
column
headings: item #, Qty, Descr, Cost, Total) (and the old formula is
"=product(B2,D2)." For the life of me I cannot find out how to make the
thing work in a Word 2007 document. (Note: This table is in the middle of
another form that does not lend itself to Excel). Any suggestions on how
to
get this thing to work




  #4   Report Post  
Posted to microsoft.public.word.tables
Mike Mike is offline
external usenet poster
 
Posts: 229
Default Word 2007 Table Calculations

Thank you, that helped, but once I protect the document as a form, and fill
in the variable fields, I cannot get the result field to calculate.


"Doug Robbins - Word MVP" wrote:

Use { = B2 * D2 }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Mike" wrote in message
...
I created a simple table inventory form (in Word2000) that sums columns and
gives me a multiplication product result at the end of each row (i.e.
column
headings: item #, Qty, Descr, Cost, Total) (and the old formula is
"=product(B2,D2)." For the life of me I cannot find out how to make the
thing work in a Word 2007 document. (Note: This table is in the middle of
another form that does not lend itself to Excel). Any suggestions on how
to
get this thing to work




  #5   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2007 Table Calculations

If you are protecting the document for filling in forms, in place of B2 and
D2, use the bookmark names that are assigned to the formfields in those
cells and set the Calculate on Exit property for each of those formfields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Doug Robbins - Word MVP" wrote in message
...
Use { = B2 * D2 }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Mike" wrote in message
...
I created a simple table inventory form (in Word2000) that sums columns
and
gives me a multiplication product result at the end of each row (i.e.
column
headings: item #, Qty, Descr, Cost, Total) (and the old formula is
"=product(B2,D2)." For the life of me I cannot find out how to make the
thing work in a Word 2007 document. (Note: This table is in the middle of
another form that does not lend itself to Excel). Any suggestions on how
to
get this thing to work





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
word 03 table calculations wynand Microsoft Word Help 8 July 29th 08 02:04 PM
Word 2003 table calculations Lenny Microsoft Word Help 1 June 4th 08 11:55 AM
add rows to word 2007 locked table w/ calculations nirie1 Tables 1 April 18th 07 05:52 PM
Calculations in a word table Latham Tables 3 June 28th 06 12:25 PM
How can I add multiple table calculations in word? stheo Tables 4 May 9th 05 01:09 PM


All times are GMT +1. The time now is 03:04 AM.

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"