# Daily Compounding Interest Formula Based on Two Different Rates

1. ## Daily Compounding Interest Formula Based on Two Different Rates

What I am trying to do is to create a formula for the attached spreadsheet  that calculates the daily compounding interest based on the higher rate of the two rates for the first five years then after 5 years the calculation should only be based solely on the blocked rate.

Thank you,
Cheryl  Register To Reply

2. ## Re: Problem with Formula

Well this would get you the correct rate:
IF(B15<MIN(B\$15:B\$2267)+365*5+1,MAX(F15:H15),H15)  Register To Reply

3. ## Re: Problem with Formula

Hi ragulduy,

Thank you very much for your reply. Your formula, won’t worked on what I am trying to do – sorry. I do have a formula that I am currently using. In a separate worksheet, I am using this formula (IF(AND(B15>=\$J\$8,B15<=\$J\$9),1,0)*D15*(MAX(F15,H15)/365)+D15) for the first 5 years, and this formula (IF(AND(B15>=\$J\$8,B15<=\$J\$9),1,0)*D15*(H15/365)+D15) after 5 years.

I am looking to combine these two concepts into one formula that can calculate the interest (daily compounding) using the higher rates for the first 5 years from the start date. After 5 years, it calculates the interest (daily compounding) using the blocked rate from the 5-years date.

Thanks,
Cheryl  Register To Reply

4. ## Re: Problem with Formula

If(b15<min(b\$15:b\$2267)+365*5+1,(if(and(b15>=\$j\$8,b15<=\$j\$9),1,0)*d15*(max(f15,h15)/365)+d15),(if(and(b15>=\$j\$8,b15<=\$j\$9),1,0)*d15*(h15/365)+d15))  Register To Reply

5. ## Re: Problem with Formula

Thank you very much ragulduy. Your formula works - except a few cents diffence.  Register To Reply

6. ## Re: Problem with Formula

Not a good idea to ignore Moderators requests in this forum, I suggest you to take some minutes to read forum rules before you post again.  Register To Reply