I had a formula before and I tried to edit but I'm struggling. Pls. help me.
I need to calculate 1st month to bring the first rate and the succeeding month the 2nd rate. If at the end there is a fraction in a month. then multiply the 2nd rate x fraction of the month.
I attached the excel file for easy understanding.