Formulas in Word 2003

[cannonwill]

I am creating a fillable form in Word 2003 and using some simple calulation
formulas. I want to simplify them so that they are easy to modify for
different users.

I have a table and in one cell of each row is information and related
numbers (activity values and points earned) The simplest way I have found is
to create a field and name each value with a 'bookmark' and then add the
bookmarks for the totals (=bookmark1+bookmark2+bookmark3 etc.)

I want to use these totals in another calculation and I am not able to do it
the same because the field is a formula and once it is a formula you can not
give the field a bookmark name.

I also need to use these subtotals in a final calculation to show a
percentage at the end.

My problem is in the other calculations (subtotals and totals) I have to use
each individual bookmark name in the formula and can't use subtotal number
that are already available. My formula gets very long and chance for error
increases.

I have created an excellent example for review which may help understand the
problem. In the interim I am posting the finial formula I am using for the
final percentage and this may help as well. I am hoping there is an easy
solution out there somewhere. My web searches have been time consuming and
have returned no valuable results (I even tried adding the old Tools
Calculate function to my Tools menu and have not been ablve to figure it our
either). Here is my final formula:

=((M1P1+M1P2+M1P3+M1P4+M1P5+M1P6+M1P7+M1P8+M2P1+M2P2+M2P3+M2P4+M2P5+M2P6+M2P7+M2P8)/(M1A1+M1A2+M1A3+M1A4+M1A5+M1A6+M1A7+M1A8+M2A1+M2A2+M2A3+M2A4+M2A5+M2A6+M2A7+M2A8))*100

 

[Stefan Blom]

You can use a table and then insert formula fields to perform the
calculations. You can refer to the cells as in Excel (for example, B1 means
the first cell in the second column).