Continuing from the same Excel worksheet above, enter “Compound interest” into cell A6 and enter “=Compound_Interest(B1, B2, B3).” This gives you a value of $276.28, which is consistent ...

The key to calculating compound interest lies in the exponential function, which raises a number to a power. The exponential function combines the term and interest rate, the result of which you ...