View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
duckie71 duckie71 is offline
external usenet poster
 
Posts: 2
Default 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