Microsoft KB Archive/69601

Subtracting, Dividing, or Multiplying Cells of a Table

PSS ID Number: Q69601 Article last modified on 12-20-1993

1.00 1.10 1.10a 2.00 2.00a 2.00a-CD 2.00b 2.00c WINDOWS

Summary: In Word for Windows 1.0 and 2.0, it is possible to divide cells of a table in an Expression field. The syntax for this is: {=sum([r1c1])/sum([r2c1])} To subtract: {=sum([r1c1])-sum([r2c1])} Page 36 of the “Microsoft Word for Windows User’s Reference” lists the multiplication syntax as follows: {=product([r1c1],[r2c1])} Another method for multiplying cells is as follows: {=sum([r1c1])sum([r2c1])} To multiply a cell by a constant value, use the following syntax: {=sum([r1c1])4} To multiply a range of cells, use the following syntax: {=product([r1c1:r1c5])}

More Information: The Expression field must be inside the table. The following error will result if the expression or formula is not in a table: !THE EXPRESSION NOT IN TABLE The curly brackets {} in the formulas above were created with the CTRL+F9 key combination.

Additional reference words: w4wfield 2.0 2.00 calculate w4wtable division multiplication math subtraction ============================================================================= Copyright Microsoft Corporation 1993.