Growth percent data spreading method

The Growth percent method takes an initial value as a starting point and sequentially increments all values in a selected range of cells by the specified percentage.

The following view shows the result of applying the Growth percent method to a range of six cells where the initial value is 100 and the growth percentage is 10%. This example uses the Replace data action.

View of the result of applying the Growth percent method to a range of six cells where the initial value is 100 and the growth percentage is 10%.

The initial value of 100 displays in the cell identified by Jan-2018, Argentina. Applying the growth percentage of 10% to 100 gives 110, the value in Feb-2018, Argentina. Applying the growth percentage of 10% to 110 yields 121, the value in Mar-2018, Argentina.