LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
to compute interest rate from principal and interest amount PVJ Excel Discussion (Misc queries) 3 December 28th 05 05:01 PM
Interest Functions dwe Excel Worksheet Functions 17 December 8th 05 01:32 PM
How do I calc interest when using multiple dates within a given ye MrTaxGuy Excel Worksheet Functions 2 September 19th 05 06:20 PM
Function help with Calculating Interest for two different investme proshail Excel Worksheet Functions 2 July 29th 05 01:27 PM
Keeping track of loan payments and interest Tony Williams Excel Discussion (Misc queries) 4 July 7th 05 01:10 PM


All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"