Forum Discussion
ALIF_78
Dec 12, 2024Copper Contributor
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 not what i am looking for , all rates multiply by A1 , i need
1000*(1+10%)=1100
1100*(1+5%)=1155 ...
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.
- Patrick2788Silver Contributor
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)))