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.
Please help!
Thank you,
Cheryl
Last edited by dache416; 05-30-2014 at 08:54 AM.
Well this would get you the correct rate:
IF(B15<MIN(B$15:B$2267)+365*5+1,MAX(F15:H15),H15)
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
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))
Thank you very much ragulduy. Your formula works- except a few cents diffence.
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.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks