Hi Guys, My Name is Amer Morgan, I am new here and need your help, I want to calculate the interest rate value for each monthly balance ?. any ideas?. thanks in advance. Month Monthly Balances Min Max Rate% Rate Value Jan 34241.39 0.00 20,000.00 0% Feb 62084.62 20,000.00 50,000.00 6% Mar 53596.19 50,000.00 100,000.00 6% Apr 49516.10 100,000.00 150,000.00 7% May 73609.34 150,000.00 200,000.00 8% Jun 201695.91 200,000.00 350,000.00 8% Jul 261629.04 350,000.00 500,000.00 8% Aug 301223.85 500,000.00 650,000.00 10% Sep 333895.42 650,000.00 750,000.00 10% 750,000.00 1,000,000.00 10%