dear all
hi
dear all
hi
I think you need to provide some explanation!! I am sure the answer is not =U14 copied across and down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
I am checking the calculation of interest on the customer's debit balance.
It is the purpose to check how many days he has in it, how much interest he has in that day.
It has some parameters is below.
1. 0 is 08 days interest nil
2. 09 to 15 days interest 10%
3. 16 to 60 days interest 13%
4. 60 above 16%
5. D2 IS- Clearing Date - Int Date
6. D1 IS - Clearing Date - Int Date - d2 (if same bill Clearing date)
I have given parameter of 1-3 in excel file, and also file upload
I feel that we need some more clarification on point #6 in order to be able to help (i.e. why is AC14 correct, but AC19 incorrect).
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks