Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spreadsheet for calculating interest charges | Excel Discussion (Misc queries) | |||
Calculating compound interest | Excel Worksheet Functions | |||
Calculating Interest | Excel Discussion (Misc queries) | |||
to compute interest rate from principal and interest amount | Excel Discussion (Misc queries) | |||
money deposited into an account with 6.5% interest-amount of year | New Users to Excel |