Forum Discussion
Growth calculation with dynamic arrays
i have created name in name manager "TR", in this TR i have the following % 10%, 5%, 3%, 9%, assume the starting number is 100 in A1 .now the common way 100*(1+10%) in cell B1, then 110*(1+5%) in C1 ..etc, i want to use the following formula A1*(1+TR), this take the % correctly but always refer to A1. any help to solve this
2 Replies
Assuming HansVogelaar 's interpretation of the problem is correct, one could also have
= SCAN(init, 1+AR, PRODUCT)Things start to get difficult if the initial value 'init' is an array or if one interprets the AR as scenarios, each of which is to be escalated over a number of years.
