(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
(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
(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
>
>
>
(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
>
>
>
(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
>
>
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