Does it need VBA?

I have a problem calculating a total interest for an input period that has different interest rates. You can see the attached file:View attachment INTEREST.xls

I have used a function but the result comes out wrong. Can I fine tune it or it needs VBA?

Please on't post the same question twice.