Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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 :-) |