This function performs the same calculation over and over again, across a row.
Syntax:
RepeatingCalculation, mathOperation
Parameters:mathOperation – the calculation to be repeated across the row { Growth, Diff, Ratio, Percent }
Examples:
RepeatingCalculation,growth
Calculates the growth across the row, from first column to second, second to third, third to fourth and so on.
Comments:Note that the first column will be blank since the calculations require two numbers to make the calculation.
|