Building a compound interest calculator?

[Ben_Swanson]

Hey all!

I’m hoping someone might be able to help me - I’m looking to build a compounding interest calculator - but I just can’t figure out how to make it work the the ‘this row’ function. Can anyone please help??

Pictures are better than words, so I’ve dummied up the functionality of what I’m looking for hopefully this helps! Thanks so much!!

[Christiaan_Huizer]

hi @Ben_Swanson , did you consider to use the Power() function? That should normally do the trick.

I applied it in this post:

Referencing the cell above

@Paul_Danyliuk, @shishir First of all thanks a lot for your contributions on this subject. It took me a while to try to understand all the work you did and I am not even sure I do fully understand it as I have no coding back ground. Anyway I used your input to work out a different solution for two scenarios you solved with Previous Row Logic Previous Row - Sales of days before To calculate the cumul of something like sales (first day, second day, third day etc) I used a “coordinate based” l…

best, christiaan

[Federico_Stefanato]

Hi @Ben_Swanson ,
as @Christiaan_Huizer suggests, Power() is the right formula.

If you want to have a working example, please have a look at:

[Ben_Swanson]

Thank you both very much! It’s really appreciated!!