Building a compound interest calculator?

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!!

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

I applied it in this post:

best, christiaan


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:


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