Forum Discussion

ALIF_78's avatar
ALIF_78
Copper Contributor
Dec 12, 2024

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.

  • Patrick2788's avatar
    Patrick2788
    Silver 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.

Resources