Excel formula

[stevenwjbeattie]

I am trying to create a formula which calculates compounded interest. Ideally i want a cell with a figure, say £1,000 and the next one with a percentage, say 5% and the next one with another percentage, say 4% and the final one which calculates the total figure (ie 1000 x 5% + total of this sum (1050) x 4%, giving a total of £1092).

Can this be done?

 

[Richard Schollar]

Assuming your 3 values are in cells A1, B1, C1 respectively, in D1 type:

=A1*(1+B1)*(1+C1)

Regards

Richard