=ROUND(+IF(N21>0,0,C21*$D$7*((+B21-B20)/365)),2)
this is the current formula N21 is interest arrears, B20 can be call March 31 B21 can be called April 30th. So this formula will only calculate interest if they are no arrears and it is calculated for 30 days. My difficulty is how to modify it for cases where the customer pays on APril 15th and then again on April 26th for example. Will i need to insert a column for the payment date and work from there help please.
Please attach a copy of your workbook so we can test solutions on your own data. Remember to remove/replace any sensitive info before uploading.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Loan AMortization beta test data.xlsx
I have attached a sheet above.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks