• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

corresponding interest rate for given date

hemasundar

hemasundar

New Member
sir i need solution to the following problem .suppose interest rate form 1.1.12 to 30.04.12 is 5%, and from 1.5.12 to 31.8.12 is 4% and from 1.9.12 to 31.12.12 is 2% ,for example a date falls between 1.1.12 to 31.12.12 it has to pick up corresponding interest rate ,please forgive me for my poor english
 
Hi


Setup a table like this one and use vlookup to find the corresponding rate:

[pre]
Code: 
01-01-10 01-31-10 2
01-01-11 01-31-11 4
01-01-12 01-31-12 5[/pre]
... Above table is present in A1 to C3... Then use Vlookup(Date,A1:C3,3)
where Date is the date u want to get rate for...


Regards,

Faseeh
 
This will work for your problem Hemsundar.


=IF(AND(J10<=J12,K10>=J11),5%,IF(AND(I10<=K12,I10>=K11),4%,IF(AND(I10<=I12,I10>=I11),2%)))
 
Hi hemasundar,


See this attached file: http://dl.dropbox.com/u/60644346/hemasundar_solution.xlsx


....This also includes Montrey's solution.


Regards,

Faseeh
 
You should consult the professional one for this. Though to be able to make money, a payday lender has to charge some cash on the small, short term installment loans it offers out. These payday advance loans are not overpriced when you consider a lender cannot possibly make any money unless it charges a high Interest rate. It is unfair to look at APR when it comes to payday loans, because they are not annual loans. Somebody needs to explain that to the pastor trying to limit the APR on payday advance loans. Get more info at: Payday Loan.
 
You should consult the professional one for this. Though to be able to make money, a payday lender has to charge some cash on the small, short term installment loans it offers out. These payday advance loans are not overpriced when you consider a lender cannot possibly make any money unless it charges a high Interest rate. It is unfair to look at APR when it comes to payday loans, because they are not annual loans. Somebody needs to explain that to the pastor trying to limit the APR on payday advance loans. Get more info at: Payday Loan.
 
You must log in or register to reply here.
Back
Top