Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Multiply in Word 2007 Table
Is it possible to calculate other than Sum? In my table I'd like to be able
to multiply one cell with another. Does it work like Excel? Do rows/columns have numbers and letters? In one cell is a cost (i.e., 0.332) and the next cell is the qty (i.e., 1130). I'd like the next cell to contain the total cost ($375.16). Is this possible? Thank you. -- MB |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Multiply in Word 2007 Table
Yes and no and yes.
1. If you look at Table | Formula, you'll see that there are numerous functions. You can learn more about these by looking at the Help topic "Field codes: = (Formula) field," which spells out the operators, functions, table references, etc. 2. No, it doesn't work quite like Excel because all cell references are absolute; if you add a row or column, formulas don't update automatically. And the Sum(Above) and Sum(Left) and similar functions stop at the first empty cell, making it necessary to use cell range references if any cells will be empty. 3. Rows and columns have numbers and letters, but it can be difficult to find out what they are, especially if any cells are merged. But see http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm and http://gregmaxey.mvps.org/Table_Cell_Data.htm. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "MB" wrote in message ... Is it possible to calculate other than Sum? In my table I'd like to be able to multiply one cell with another. Does it work like Excel? Do rows/columns have numbers and letters? In one cell is a cost (i.e., 0.332) and the next cell is the qty (i.e., 1130). I'd like the next cell to contain the total cost ($375.16). Is this possible? Thank you. -- MB |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Multiply in Word 2007 Table
Hi MB,
To see how to do a wide range of other calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [Microsoft MVP - Word] "MB" wrote in message ... Is it possible to calculate other than Sum? In my table I'd like to be able to multiply one cell with another. Does it work like Excel? Do rows/columns have numbers and letters? In one cell is a cost (i.e., 0.332) and the next cell is the qty (i.e., 1130). I'd like the next cell to contain the total cost ($375.16). Is this possible? Thank you. -- MB |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to multiply values from drop down boxes in table. | Tables | |||
How do I multiply non-adjacent columns in a Word table? | Tables | |||
How do I multiply a value in Word? | Microsoft Word Help | |||
Can you put a formula to multiply in word ? | Microsoft Word Help | |||
Multiply contents of table cells | Tables |