Excel formula

stevenwjbeattie

New Member
Joined
Nov 16, 2005
Messages
1
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?
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Assuming your 3 values are in cells A1, B1, C1 respectively, in D1 type:

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

Regards

Richard
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,088
Members
412,567
Latest member
mm1
Top