Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
fatdave
 
Posts: n/a
Default multiply and add numbers together

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

Table two.
I would like total all the row's in table one.

Table three.
multiply table two by 17.5%

Table four
add table three to table two

And yes this is a invoive.
  #2   Report Post  
Posted to microsoft.public.word.tables
Cindy M -WordMVP-
 
Posts: n/a
Default multiply and add numbers together

Hi ?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 :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 05:07 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"