Here's a fun one. Incentive formula in tiered structure.

I like to think of myself as quite handy using excel however im stumped on this one. Im trying to figure out a pay scale to use and I like the idea of having a tiered bonus however I cant figure out how to fill in the bonus line highlighted in blue. I also highlighted in blue the table to correspond with the tiers. Can someone help me find a formula I can use to make this work??

Attached is excel sheet I have created

You should start your own new topic...