Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculation based on year of entry
As background, I am what you might call and advanced novice. I am 81 years old and could have done this myself 20 years ago, but as I age, my ability to concentrate dwindles and I can't resolve conflicts in logic as well as I could years ago. I was teaching programming in 1967 and was involved in software development and maintenance until retirement in 1996, but my involvement has steadily decreased over the years. I am only trying to keep up with the spreadsheet work to keep my mind active
I have developed a spreadsheet, based on an Amortization of a loan. I am actually trying to calculate the total interest in Column "F" that is paid each year, based on the date in Column B. I have a column "I" that contains the year and column "J" that will be the total for that year. Can someone steer me in the right direction? . |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation based on year of entry
"Dond13" wrote:
I have developed a spreadsheet, based on an Amortization of a loan. I am actually trying to calculate the total interest in Column "F" that is paid each year, based on the date in Column B. I have a column "I" that contains the year and column "J" that will be the total for that year. Can someone steer me in the right direction? Take a look at the CUMIPMT function. (I don't like that function for reasons I have long-since forgotten. Instead, I prefer to do the calculation myself, using the FV function.) However, the devil is in the details. In order to offer a more turnkey solution, it would be helpful to see an example Excel file. I believe excelbanter.com provides a way to "attach" a file to a posting. But more generally, upload the Excel file to a file-sharing website, and post the "sharable" URL of the file in a response. Below is a list of some free file-sharing websites; or use your own. But this seems to be an error-prone process; many people post the wrong URL. box.net seems to be the least error-prone, IMHO. Box.Net: http://www.box.net/files MediaFi http://www.mediafire.com FileFactory: http://www.filefactory.com FileSavr: http://www.filesavr.com RapidSha http://www.rapidshare.com Windows Live Skydrive: http://skydrive.live.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
Calculation based on entry into one of 2 cells | Excel Programming | |||
Year Calculation | Excel Worksheet Functions | |||
Is the IRR calculation based on cash flows at beginning of year? | Excel Worksheet Functions | |||
how do I set up an entry so that 3 months or one year later Excel. | Excel Worksheet Functions |