Hi =?Utf-8?B?ZmF0ZGF2ZQ==?=,
Ok, I have 4 table one one page.
Table one
I would like to multiply 2 of the cels to get a total on each row
Depending on what the table contains, and where the cells are
located relative to one another, you might be able to use the field
expression: { = PRODUCT(left) }
If this won't work because the columns aren't adjacent, then you
need to explicitly put in the formula for each row. For example:
{ = D2 * E2 }
{ = D3 * E3 }
etc.
Word does NOT support relative cell references, like Excel has.
Although you can fake them, to a certain extent, using complex field
combinations (see the Numbering section on my website if this
interests you).
Table two.
I would like total all the row's in table one.
Select the entire table. Insert/Bookmark and assign it a name. Now
you should be able to use a formula like the following to total
column f:
{ = SUM(Table1 f:f) }
Table three.
multiply table two by 17.5%
Similar approach as above. Assign the table a bookmark, then use
that in the calculation. Note, however, that you must use a
function, such as SUM, in order to do this. If, for example, you
want to multiply just cell D7 by 17.5%:
{ = SUM(Table2 D7:d7) * .175 }
Table four
add table three to table two
Same approach.
And yes this is a invoive.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail
