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 Jan-10%,feb-10%)
--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 Jan-10%,feb-10%)
--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.