#### james24812

##### New Member

I am trying to write a formula that pays a specific milestone when cumulative sales are greater than a certain number. There are multiple tiers where this applies, but each milestone can only be paid once. Below are the milestone thresholds and amount paid when each is passed. Does anyone know how I can accomplish this by referencing the cumulative sales cell in a given year?

Cumulative Sales Threshold Milestone Amount

500,000 10,000

1,000,000 15,000

2,000,000 40,000

4,000,000 80,000

So, since each milestone is only paid once, the maximum total number of milestone payments that can be received is 145,000 (the sum of all milestones)

Thanks,

James