User Profile
anna76
Copper Contributor
Joined 10 months ago
User Widgets
Recent Discussions
i want to count the accrue interest for loan and tag either its new or recurring customer
hi to all the experts here.. i need your help to count the accrue interest and tag customer which its a new customer or recurring. i need to count the accrue interest in column H with condition as below: 1. if the status in column "J" is "unpaid", hence i need the formula of accrued interest running until the status changed to paid. 2. the loan tenor is 30 days, so the accrue interest should start from day 1 after disburse date until loan due date. 3. if the loan is unpaid until the due date, column H also need to calculate the late fee but with condition that if days past due (column K) is between day 1-5 it wont calculate the late fee, late fee only occurs in day 6, which is [1 day*0.05%*disburse amount], if the days past due (column K) is 7 hence the formula is [2 days*0.05%*disburse amount] also for column I, i need to have a formula where if the customer name in column A is the first to came hence the status in column I is "New" but if the customer name cames up again for the 2nd time then its a "recurring" let me know im not clear because english is not my 1st language, i can try to rephrase my word later.. thankyou!!!235Views0likes0Commentssum if with condition
Hi all, please kindly help me create this excel formula this is the source of data: Disburse Amount Status Rp300.000.000 Ongoing Rp500.000.000 Ongoing Rp200.000.000 Ongoing Rp150.000.000 Paid Rp20.000.000 Late the formula i want to create Umbrella Limit: Rp 25.000.000.000 (hardcode) Loan Paid: Rp 150.000.000 (all rows with status of "Paid") Loan Outstanding: Rp 1.000.000.000 (all 3 rows with status of "ongoing") Available Limit: umbrella limit: all "ongoing" and "late" rows. which is Rp 1.020.000.000. and i want this available limit to exclude the "Paid" row from the source data the formula i want to create is the Loan Paid , Loan Outstanding and Available limit. thanks364Views0likes1Comment
Groups
Recent Blog Articles
No content to show