Commission formula based on cumulative percentages

I have been thinking about this too long now.

I am trying to complete my commission sheet based on percentages meaning basically employees get paid commission monthly based on the percentage of sales.

0 - 84.99% = $0
85 - 99.99% = 50% of monthly commission pot ($1000)
100 - 125% = exact percentage hit

The first month then gets reajusted based on the 2nd months results. Which means they may be owed less or more money by the end of the first quarter. I can't seem to get it to work properly. I have attached my sheet hopefully it makes sense. I am trying to make it easy for staff to realize if they are in a negative position after the 1st quarter.

Commission Sales Tracker.xls

Hi Laliberte,

Have gone through your sheet.
It would be more helpful if you can put your number manually in the respective cells and then I will try and achieve the same using formulas

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Laliberte,

Thanks for attachment.
When I opened your file, pressed F5 -> Special -> Formulas -> Enter and I got all the formula cells selected, highlighted them with yellow. Now I again selected constants (values) in similar manner and highlighted them with orange color. My query remains same, which are the cells on which you have entered figures manually for which I think of applying some formula to achieve similar results ? Highlight them. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Oops missed the attachment, now reattached.

Regards,
DILIPandey

<click on below 'star' if this helps>