Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PER function
I need help with the PER field in the PPMT function. When figuring
the amount of interest and principal paid during a given year, I can't figure out how to determine these amounts for an entire year. When payments are made monthly, the principal and interest amounts change per month, so finding these amounts per year and each year thereafter escapes me. Any help on what to enter in the PER field to account for not only an entire year, but subsequent years would be helpful. Thanks, Josh |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PER function
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
challenge! javascript function into excel function | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |