Hi
Could anyone please advise how to set Excel up with a formula, to add 2% per day using a spreadsheet to calculate compound interest starting with a £100 bank?
Cheers
Tony
Compound Interest
Re: Compound Interest
Hi
Enter 100 in your first cell (let's say cell C3), in cell C4 enter "=C3*1.02" (without the quotation marks), copy this down through cells C5 and so on by dragging the pan handle as far as you want to go.
Is that what you needed?
Cheers
Dan
Enter 100 in your first cell (let's say cell C3), in cell C4 enter "=C3*1.02" (without the quotation marks), copy this down through cells C5 and so on by dragging the pan handle as far as you want to go.
Is that what you needed?
Cheers
Dan
Re: Compound Interest
Thanks Dan
Much appreciated
Much appreciated
Return to “Trading Discussion”
Who is online
Users browsing this forum: No registered users and 4 guests