Multiple Cell Calculation

[Tom]

I have a table with three rows and four columns. There is a formula in
column D of each row, and it simply multiplies columns B*C. Is there any
way, that if you want to add a row by copying an existing row and pasting it
at the bottom, to have it automatically update the formula in column D to
reflect the new row number?

 

[Suzanne S. Barnhill]

No, Word does not have Excel's ability to AutoFill. In such situations, it's
preferable to embed an Excel sheet.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[macropod]

Hi Tom,

Yes, you can! Assuming you're starting from Row1, put the
following field into column D:
{Quote{Set CellNr1 "b{={SEQ CellNr}/2}"}{Set CellNr2 "c{=
{SEQ CellNr \c}/2}"}{={CellNr1}*{CellNr2}}}
If you're column D formulae start from Row2, change
the '/2' in the above to '/2-1'.
Note: the braces (ie {}) are entered as pairs using Ctrl-
F9.

Cheers
PS: Remove NO.SPAM from the above before replying.

 

[macropod]

Forgot the last bit -
After keying the field, copy it down as many rows as you
need. Then press F9 to update it.
Cheers
PS: Remove NO.SPAM from the above before replying.