Hello,
I could use some help with a sliding scale formula. I need a formula that does the following:
if a sales rep achieves 85% of sales, they will achieve 50% of their bonus. If a sales rep achieves 100% of sales, they achieve 100% of their bonus. If they achieve 115% of sales, they’ll get...