|
|
|
date: Mon, 28 Jul 2008 12:38:05 -0700,
group: microsoft.public.word.tables
back
Re: Formula and Bookmark
Hi macropod,
Thanks for the formula. I just tried that formula, and it did nothing. The
cell stays blank. I wonder whether I bookmarked correctly.
Basically, I highlighted Table 1. Then I went to Insert>Bookmark, and I
typed in a name Table1 and clicked Add. I did the same for Table 2. Then I
see brackets ([ ]) at the beginning and ending at each table. Did I do the
bookmarks correctly?
Thanks.
"macropod" wrote:
> Hi,
>
> Try coding the field as:
> {=SUM(Table1 C5)+ SUM(Table2 C7)}
>
> --
> Cheers
> macropod
> [MVP - Microsoft Word]
>
>
> "Please Help" wrote in message news:8C80B55C-4FA4-4050-B53F-53DF7B4DF51A@microsoft.com...
> > Hello all,
> >
> > I have 3 tables in my Word file. In Table 3, there is only one row with one
> > cell, and in that cell, I want to have a formula to add the numbers from C5
> > and C7 in Table 1 and Table 2, respectively. I tried the formula
> > {=sum(Table1 C5 + Table 2 C7)} in the cell in Table 3.
> >
> > Prior to inserting that formula, I created the bookmarks "Table1" and
> > "Table2" by highlighting respective table and go to Insert>Bookmark.
> >
> > I am completely new to the writing a formula in Word and creating a
> > bookmark. Please help with detail steps.
> >
> > Thanks.
>
date: Mon, 28 Jul 2008 15:06:15 -0700
author: Please Help
Re: Formula and Bookmark
Hi,
Provided you created the field braces (ie '{ }') via Ctrl-F9, and the table bookmarks & cell references are correct, everything
should work fine. Do note, though, that changing the source cell values does not of itself cause the formula to recalculate - you'll
need to update the field by selecting it and pressing F9, doing a print preview or printing the document.
For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
--
Cheers
macropod
[MVP - Microsoft Word]
"Please Help" wrote in message news:A129B2B8-AFA7-440E-B4F6-8CF5FD783DB2@microsoft.com...
> Hi macropod,
>
> Thanks for the formula. I just tried that formula, and it did nothing. The
> cell stays blank. I wonder whether I bookmarked correctly.
>
> Basically, I highlighted Table 1. Then I went to Insert>Bookmark, and I
> typed in a name Table1 and clicked Add. I did the same for Table 2. Then I
> see brackets ([ ]) at the beginning and ending at each table. Did I do the
> bookmarks correctly?
>
> Thanks.
>
> "macropod" wrote:
>
>> Hi,
>>
>> Try coding the field as:
>> {=SUM(Table1 C5)+ SUM(Table2 C7)}
>>
>> --
>> Cheers
>> macropod
>> [MVP - Microsoft Word]
>>
>>
>> "Please Help" wrote in message news:8C80B55C-4FA4-4050-B53F-53DF7B4DF51A@microsoft.com...
>> > Hello all,
>> >
>> > I have 3 tables in my Word file. In Table 3, there is only one row with one
>> > cell, and in that cell, I want to have a formula to add the numbers from C5
>> > and C7 in Table 1 and Table 2, respectively. I tried the formula
>> > {=sum(Table1 C5 + Table 2 C7)} in the cell in Table 3.
>> >
>> > Prior to inserting that formula, I created the bookmarks "Table1" and
>> > "Table2" by highlighting respective table and go to Insert>Bookmark.
>> >
>> > I am completely new to the writing a formula in Word and creating a
>> > bookmark. Please help with detail steps.
>> >
>> > Thanks.
>>
date: Tue, 29 Jul 2008 08:59:12 +1000
author: macropod lid
Re: Formula and Bookmark
Hi macropod,
Thanks for your continuing help and the links. It works now.
"macropod" wrote:
> Hi,
>
> Provided you created the field braces (ie '{ }') via Ctrl-F9, and the table bookmarks & cell references are correct, everything
> should work fine. Do note, though, that changing the source cell values does not of itself cause the formula to recalculate - you'll
> need to update the field by selecting it and pressing F9, doing a print preview or printing the document.
>
> For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
> http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
> or
> http://www.gmayor.com/downloads.htm#Third_party
>
> --
> Cheers
> macropod
> [MVP - Microsoft Word]
>
>
> "Please Help" wrote in message news:A129B2B8-AFA7-440E-B4F6-8CF5FD783DB2@microsoft.com...
> > Hi macropod,
> >
> > Thanks for the formula. I just tried that formula, and it did nothing. The
> > cell stays blank. I wonder whether I bookmarked correctly.
> >
> > Basically, I highlighted Table 1. Then I went to Insert>Bookmark, and I
> > typed in a name Table1 and clicked Add. I did the same for Table 2. Then I
> > see brackets ([ ]) at the beginning and ending at each table. Did I do the
> > bookmarks correctly?
> >
> > Thanks.
> >
> > "macropod" wrote:
> >
> >> Hi,
> >>
> >> Try coding the field as:
> >> {=SUM(Table1 C5)+ SUM(Table2 C7)}
> >>
> >> --
> >> Cheers
> >> macropod
> >> [MVP - Microsoft Word]
> >>
> >>
> >> "Please Help" wrote in message news:8C80B55C-4FA4-4050-B53F-53DF7B4DF51A@microsoft.com...
> >> > Hello all,
> >> >
> >> > I have 3 tables in my Word file. In Table 3, there is only one row with one
> >> > cell, and in that cell, I want to have a formula to add the numbers from C5
> >> > and C7 in Table 1 and Table 2, respectively. I tried the formula
> >> > {=sum(Table1 C5 + Table 2 C7)} in the cell in Table 3.
> >> >
> >> > Prior to inserting that formula, I created the bookmarks "Table1" and
> >> > "Table2" by highlighting respective table and go to Insert>Bookmark.
> >> >
> >> > I am completely new to the writing a formula in Word and creating a
> >> > bookmark. Please help with detail steps.
> >> >
> >> > Thanks.
> >>
>
>
date: Mon, 28 Jul 2008 17:04:00 -0700
author: Please Help
|
|
