Forum Discussion
Solved
Dynamic Growth rate
i have the following growth rate 10%, 5%, 3%,9% i create name range for them TR in cell A1 i have 1000 now i am trying to do the following A1*(1+TR) to calculate the growth however the result is...
If I understand the goal correctly, you need some accumulation:
=SCAN(A1,TR,LAMBDA(acc,v,acc*(1+v)))acc is the accumulated value
v is each rate we encounter in TR
I could explain more but it may be best to take it for a spin and play with it.
If you have Microsoft 365:
=SCAN(A1, TR, LAMBDA(a,b, a*(1+b)))