User Profile
Mbarak630
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Excel formula help
mtarler yes, payments made were and the allocation was given priority to the earlier loans. I think best is to avoid multiple loans running for one customer, but stick one loan per customer and until it is fully paid inclussive of all penalties and there is no outstanding amount, then a new loan can be4.4KViews0likes2CommentsRe: Excel formula help
mtarler You are correct, i was just trying to see if a customer has two loans, what was the effect and i saw the issues arising, and so to avoid it then only one loan for a customer and must be cleared before another is taken. Also, its better if I use the Loan ID, and the penalties were necessary because if loan wasnt paid by due date, then the penalties apply. I will replace customer name with Loan ID4.3KViews1like4CommentsRe: Excel formula help
mtarler I wouldn't say that i fully understood, but after testing the first row 5 and and can say that it was working as i was expecting. I changed the invoice dates did calculations manualy and saw i was getting same results. I changed the invoice dates for both row 5 and row 6, as 18-feb-23, same customer name, loan amount is same, however cell H6 and I6 have values different to H5 and I5 . This got me a little confused4.4KViews0likes7CommentsRe: Excel formula help
Thanks for your assistance, However the formula does not solve the one mystery am stuck on. just to be more clear and precise, what am doing is amount borrowed is charged 10% interest, for 30 days, and next month if not paid back or not completely cleared then another 10% is charged, and for the 3rd month and 4th month. If cleared in the 2nd, or 3rd or 4th month then amount to repay should be inclusive with the interests, and not just return nil showing nothing has been charged.4.7KViews0likes19CommentsExcel formula help
kindly assist on formula below in cell E5 =IF(TODAY() > F5, D5 *(1.1)* (1 + 0.1)^MIN(DATEDIF(F5, TODAY(), "M"), 3), D5*1.1) how do I formulate it to first check if (outstanding amount) column H5=0 then if H5 has a value greater than 0 then it does the calculation. the challenge is that H5=E5-G5Solved5.8KViews0likes21Comments
Recent Blog Articles
No content to show