|Cost per month||%Allocation||Start Month||Jan||Feb||Mar||Apr||May||Jun||Jul||Aug||Sep||Oct||Nov||Dec|
I hope you can help me with the formula. My logic is if Start month = 1, then Jan - Dec = Cost per month* %Allocation
if start month = 2, Jan = 0, but Feb to Dec = cost per month * %Allocation
if start month = 3, Jan - Feb = 0, March to Dec = cost per month * % allocation
and so on to start month = 12.
How can I do that. I got confuse when I start writing my equation and I hope you can help me.
Thanks A LOT!