Hey everyone! First post here. I've been tossing and turning for multiple nights here trying to figure this one out. For FY13 I have a component of my compensation plan that contains a 'stair step' payout. Meaning, every time I hit 5% of the annual quota I receive said payout.

The hard part is if I hit say 12% to annual quota in January (which is sheet 1), the two stair steps I hit (both 5 and 10%) will be paid out in January, and the remaining 2% will be carried over to February (sheet 2) where I will need an additional 3% to get to the next stairstep (15%) for February's payout.

How on earth do I go about doin this calculation in excel?!?