Interest amounts
Hi i wonder if anyone out there can help me I have an exam on wednesday and
am confused about one area if
If I have a rate of 5% in cell C1 and a investment amount of 5,000,000 in
cell C2 and then a interest amount of 250,00 in C3, then i have a table of
varing interest amounts in B7:B22 how can i work out the formula in C6 and
copy it down the rest of the table.
I hope this is clear to someone
Many thanks
Debbie
|