Percent change data spreading method

The Percent Change method multiplies the current cell values by a specified percentage. The product of that multiplication can then replace, be added to, or be subtracted from the existing cell values.

For example, consider the following view that contains a range of values in increments of 10.

View that contains a range of values in increments of 10.

When you apply the Percent Change method to these cells and specify a % Change value of 10, the system multiplies each cell value by 10% (or .10). If you select the Add update action, the product of multiplication is added to the existing cell values. The result is that each cell value is incremented by 10%.

View that contains a range of values that have been increased by 10%.

Data entry shortcut code

To increase the value of each cell by 10% to the right and down, type this code:

P%+>|10