michaelbanks
New Member
Greeting to the Chandoo Universe.
Hi guys,
Please i need help writing a formula that applies the given rate (%) at the given intervals.
First interval occurs on the 2nd year for 2 month period (in 2016 Jan10%,feb10%)
Second inveral occurs on the 5th year (3 years after the first) for a 1 month period (in 2019  jan 10%)
Also the intervals & duration are variable subject to change
I have attached a sample excel file to illustrate my challenge
I would really appreciate all help and inputs
Thanks in Advance.
Hi guys,
Please i need help writing a formula that applies the given rate (%) at the given intervals.
First interval occurs on the 2nd year for 2 month period (in 2016 Jan10%,feb10%)
Second inveral occurs on the 5th year (3 years after the first) for a 1 month period (in 2019  jan 10%)
Also the intervals & duration are variable subject to change
I have attached a sample excel file to illustrate my challenge
I would really appreciate all help and inputs
Thanks in Advance.
Attachments

36 KB Views: 8