Posted to microsoft.public.word.tables
|
|
multiplication formula
Well, you can use either { = C1*E1 } or { = PRODUCT(C1,E1) }
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"ll" wrote in message
news
I did try putting in where the formula should be: =PRODUCT(C1*E1), but
that
didn't work either - could tell me what I'm doing wrong?
"Suzanne S. Barnhill" wrote:
Formulas using (ABOVE) and (LEFT) stop whenever they encounter a blank
cell
or one containing text. For this to work, you'll have to use specific
cell
references.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"ll" wrote in message
...
I am trying to multiply 2 numbers across in a table. I don't know why
I'm
having so much trouble. I have a table with 7 cells across. Cell 1 is
text,
cell 2 is text, cell 3 is a number, cell 4 is text, cell 5 is a number,
cell
6 is text and cell 7 should be the multiplication answer. In cell 7, I
have
the formula: =PRODUCT(LEFT), which should calculate all the numbers
across
and skip any text. It doesn't work. It will work if I omit 1 column
therefore having the 2 columns with the numbers next to each other.
Any
help
would be appreciated. Thanks, ll
|