need formula for tiered interest in excel???

Information:
5,000-10,000- .05%
10,000-20,000-.575%
20,000-50,000-1.0%
50,000-100,000-1.5%
100,000-200,000-1.75%
200,000-500,000-2.0%
above 500,000-2.5%

june 30 balance 6000
july 7 deposit 12000
july16 deposit 6000
july 16 withdraw 2000
july 18 deposit 100000
july 18 withdraw 47000
july 25 deposit 300000
july 25 withdraw 95000
july 29 deposit 720000

pls.. help me compute the tiered interest with the given information..
also i need the formula for the computation in excel thanks!!!!

HI Katrinagidoc and welcome to the forum. Does this work for you?

I've played with the file day92 uploaded, using an approximate VLOOKUP.

The table assumes that the rates you quoted are annual rates, the interest is calculated daily, and interest is paid annually.

The 'Interest' column shows the amount of interest earned during the period between the date on the row above and the date on its row (e.g. the first interest amount in D3 is the amount earned on the balance of $6000 between 30th June and 7th July).

.., thank you so much for the help!!!!

Statement of Account.xlsx

Actually, what I need is this format...
i tried using the formula day92 used but an error occured..

Attachment 173513

Actually, what I need is this format...
i tried using the formula day92 used but an error occurred..

.., thanks to all who had help me, especially to icestationzbra..
you guys are such a great help.... thanks again!

---------- Post added at 12:20 PM ---------- Previous post was at 12:12 PM ----------

.., thanks to all who had help me, especially to icestationzbra..
you guys are such a great help.... thanks again!