Compounding Interest

Since Excel is more ubiquitous than Quickbase there should be google-able formulas out there for Excel.

Here was one hit I got.

https://zebrabi.com/guide/how-to-calculate-compound-interest-in-excel/#:~:text=There%20are%20two%20basic%20formulas,as%20in%20the%20first%20formula.

The first formula is =P*(1+r/n)^(n*t), where P is the principal amount, r is the interest rate, n is the compounding period, and t is the term.

If you have an example with Principle and Interest Rate and Term and compounding period, I could help you with the exact formula.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------