| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The ispmt function is providing unexpected results
The ispmt funtion when calculating for period 1 should provide the same
answer as multiply the monthly interest rate times the principal balance because no amortization has occured yet. The answer I'm getting is less than what is correct. What wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The ispmt function is providing unexpected results
Hello:
The help file says that ISPMT is provided for compatibility with Lotus 1-2-3. (in fact I don't think the later versions of Lotus had this function either, version 9 has @ipaymt) So unless you are using Lotus, IPMT function provides the answers you expected. Pieter Vandenberg Louis Zaffino wrote: : The ispmt funtion when calculating for period 1 should provide the same : answer as multiply the monthly interest rate times the principal balance : because no amortization has occured yet. The answer I'm getting is less than : what is correct. What wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Choose function gives different results from different cells????? | Excel Worksheet Functions | |||
| Can Function results be calculated? | New Users to Excel | |||
| Function Formula is displayed not results | Excel Worksheet Functions | |||
| IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
| in excel how to display results of a function and text in the sam. | Excel Worksheet Functions | |||
Linear Mode
