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. I have to get 33,84 which is done by adding 1 more day at the last interval 26/10-31/12/1993 in the step by step method. Can I fine tune it or do I have to change my method of calculating?
I have used a function but the result comes out wrong. I have to get 33,84 which is done by adding 1 more day at the last interval 26/10-31/12/1993 in the step by step method. Can I fine tune it or do I have to change my method of calculating?