Hi guys,
It's rare I come to an excel help forum as I try and work things out for myself but alas, I'm stumped on the best way to achieve this.
I have varying weekly interest, say 100 in week 1, 200 in week 2, 300 in week 3 etc and I'm simply trying to calculate the exact interest in the month. As the some weekly interest relate over two months, I'll have to pro rate to get the exact figure.
Is there an elegant solution to this - my thoughts are utilising MINs and MAXs here. Can't seem to attach at the moment, but an example of what I'm trying to get to is provided below.
Thanks!
Example.PNG
Bookmarks