Automate Commission Accelerator calculations based on quota attainment range.

If you're looking to calculate the "additional" tiered commission based on YTD MRR, to append to the standard value, then the below should work:

Formula:

=SUMPRODUCT(--($E$29>=($C$7*{1,1.25,1.5,1.99})),$E$29-($C$7*{1,1.25,1.5,1.99}),{1.25,0.25,0.25,0.25})

using your sample values the above would generate an additional commission of $52,570 which equates to:

7500 @ 1.25
7500 @ 1.5
14,700 @ 1.75
3,110 @ 2.00