Dear All,
I am hoping you can help as I am not the best person who knows Excel.
I need to create a formula that that would take 100% divided by the number of months defined as the "ramp period" plus the previous month so that when it adds up to 100% when it reached the end of the ramp month. The condition would need to be the following:
Contract Term = 60 months
Start month for example month 3
End month for example month 29
The above would mean a total ramp period of 27 months
When it reaches 100% by month 29, the following month should be 100% again until the end of the term.
I hope the above is clear and thank you for your help
Kind regards
Bruno
I am hoping you can help as I am not the best person who knows Excel.
I need to create a formula that that would take 100% divided by the number of months defined as the "ramp period" plus the previous month so that when it adds up to 100% when it reached the end of the ramp month. The condition would need to be the following:
Contract Term = 60 months
Start month for example month 3
End month for example month 29
The above would mean a total ramp period of 27 months
When it reaches 100% by month 29, the following month should be 100% again until the end of the term.
I hope the above is clear and thank you for your help
Kind regards
Bruno
