Inline numeric calculation in multiple cells
 
 
 

You can perform numeric calculations and percentage-based calculations in the Component Editor and Attribute Spread Sheet in multiple cells at once.

To perform a calculation

  1. Select the cells to operate on.
  2. In the active cell, enter the operation prefixes and values.
  3. Press Enter.

All selected cells get a new value specified by the operation.

Examples

To add a value to selected cells

  1. Select the cells to operate on.
  2. Enter +=4.0 into the active cell.

The selected cells increase by 4.0.

To subtract a percentage from selected cells

  1. Select the cells to operate on.
  2. Enter -=50% into the active cell.

The selected cells decrease by half their current value.

NoteSome values are subject to limitations and may not change to the desired value because they are bounded by other factors.

Related topics