Commission Payable based on % target received

Hi there,
I have a commission spreadsheet and I need to calculate an additional commission payable based on whether the store hit target (or in this instance didn't (80-110+% target reached)

I.e. Employee sells 25 units, receives $40 per unit sold (base commission) + additional commission dependant on % of store target reached, 80-110+%.

I have the calculation for the initial commission based on # of units sold set up, but need help with the second layer.

C32 = B32 (drop-down list of %'s) + $ amount for units sold.

HELP!

Screen Shot 2021-11-04 at 11.47.04 AM.png

Lets try a solution.

Wow, this is amazing! Thank you.

I will investigate the formulas to see how I can do this in the future myself. Really, really appreciate it!! :-)