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: 19
Default Calculating Interest Amount

I'm trying to insert the formula for the correct results below. Here's what
I have:

Int Rate Int. Amt
Total Principal No of days (L+1.5%)
69,000,000.00 182 7.46875 2,605,348.96

I would like to achieve this Int. Amt result by using a formula. I was told
that I could just multiply the Total Principal * Int Rate, but when I insert
that formula, my results are $515,343,750.00.

Any suggestions?

Thanks in advance,
 
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
Spreadsheet for calculating interest charges Kimbo Excel Discussion (Misc queries) 2 September 21st 06 01:31 AM
Calculating compound interest PatJennings Excel Worksheet Functions 8 August 11th 06 07:23 PM
Calculating Interest Jason30 Excel Discussion (Misc queries) 1 August 1st 06 01:12 AM
to compute interest rate from principal and interest amount PVJ Excel Discussion (Misc queries) 3 December 28th 05 05:01 PM
money deposited into an account with 6.5% interest-amount of year mathwiz New Users to Excel 1 November 2nd 05 04:11 PM


All times are GMT +1. The time now is 11:52 AM.

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"