Formula for Sales Milestone Payments 2022

[fabiana_pereira]

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?

I found a formula here but it didn't work for small values.

Google Sheets: Sign-in

Access Google Sheets with a personal Google account or Google Workspace account (for business use).

docs.google.com

Thanks