WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Word 2007 Table Calculations

 
   Home -> Office -> Tables RSS
Next:  Unreadable tables  
Author Message
Mike

External


Since: Mar 10, 2006
Posts: 2166



(Msg. 1) Posted: Thu Oct 09, 2008 11:52 am
Post subject: Word 2007 Table Calculations
Archived from groups: microsoft>public>word>tables (more info?)

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
Back to top
Login to vote
Doug Robbins - Word MVP

External


Since: Jul 14, 2006
Posts: 5494



(Msg. 2) Posted: Fri Oct 10, 2008 3:05 am
Post subject: Re: Word 2007 Table Calculations [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" <Mike.TakeThisOut@discussions.microsoft.com> wrote in message
news:2078E2C4-9F18-4F1A-919C-9B08E0697A2D@microsoft.com...
>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
Back to top
Login to vote
Mike

External


Since: Mar 10, 2006
Posts: 2166



(Msg. 3) Posted: Fri Oct 10, 2008 8:11 am
Post subject: Re: Word 2007 Table Calculations [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" <Mike DeleteThis @discussions.microsoft.com> wrote in message
> news:2078E2C4-9F18-4F1A-919C-9B08E0697A2D@microsoft.com...
> >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
>
>
>
Back to top
Login to vote
Mike

External


Since: Mar 10, 2006
Posts: 2166



(Msg. 4) Posted: Fri Oct 10, 2008 1:05 pm
Post subject: Re: Word 2007 Table Calculations [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" <Mike.RemoveThis@discussions.microsoft.com> wrote in message
> news:2078E2C4-9F18-4F1A-919C-9B08E0697A2D@microsoft.com...
> >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
>
>
>
Back to top
Login to vote
Doug Robbins - Word MVP

External


Since: Jul 14, 2006
Posts: 5494



(Msg. 5) Posted: Sat Oct 11, 2008 3:05 am
Post subject: Re: Word 2007 Table Calculations [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" <dkr.DeleteThis@REMOVECAPSmvps.org> wrote in message
news:uHjefikKJHA.3936@TK2MSFTNGP04.phx.gbl...
> 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" <Mike.DeleteThis@discussions.microsoft.com> wrote in message
> news:2078E2C4-9F18-4F1A-919C-9B08E0697A2D@microsoft.com...
>>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
>
>
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Tables All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET