Performing Arithmetic Operations on Two Columns

RockWorks | Utilities | Columns | Math | Column & Column

This RockWorks Utilities program is used to add, subtract, multiply, or divide the values in one column in the datasheet to, from, by, or into the values in the corresponding row in another column. 

Menu Options

• Input Columns: 
  • Column A: Select the name of the column in the current datasheet that contains the numeric values to which another column of values will be added or multiplied, from which another column will be subtracted, or into which another column will be divided.
  • Column B: Here, select the name of the datasheet column containing numeric values to be added or multiplied to, subtracted from, or divided into Column A values.
• Output Columns: 
  • Column C: Select the name of the column into which the computed values are to be listed.  Any existing values in this column will be overwritten!
• Operation: Click in the radio button for the arithmetic operation to be performed on the values in the input data columns.
• Decimals: Enter the requested number of decimal places to be represented in the output values.

Step-by-Step Summary

1. Access the RockWorks Utilities program tab.
2. Open the datasheet to be manipulated, if necessary.
3. Click on the Columns menu above the datasheet, and click on the Math | Column & Column menu item.
4. Establish the menu settings, described above. 
5. Click the Process button to continue.

The program will perform the selected operation on the numeric values read from the selected data columns. The results will be listed in the selected output column.

Back to Editing the Datasheet

RockWare home page