Pat,

Your question is a bit unclear. What does your data table look like? Does it have interest earned
in the second column, or total balances?

Bernie
MS Excel MVP


"PatJennings" wrote in message
...
I have a column of years and a column of numbers representing annual amounts placed in a savings
account for the year. I would like to calculate the balance of interest earned added to the balance
of the account and then calculate the interest earned on the accumulating amounts each year. The
results would be the account balance displayed in an adjoining column. So far, I have not found a
worksheet function for that. Could someone point me in the right direction? Perhaps there should be
several columns of data?
Thanks