Calculating bonus value based on percentage of goal met

Hi!

I'm attempting to make an excel sheet that automatically calculates my bonus payout for accounting during my maternity leave absence. My quarterly bonus can vary depending on how much of my sales goal is hit. For example, my Q1 goal is $3,000,000. If I hit 80% of that, I receive 15% of my $5,000 bonus. Full breakdown of percentages below. I strung together a very long IF function but it is only reading the 80% payout even if I hit 100% of the goal.

I would like accounting to only have to key in my Q1 revenue in 1 cell then the bonus payout automatically calculates based on the sliding scale of revenue hit and bonus paid out.

Goal: $3,000,000
Bonus: $5,000

80% of $3,000,000 hit = 15% of $5,000 paid
85% of $3,000,000 hit = 25% of $5,000 paid
50% of $3,000,000 hit = 50% of $5,000 paid
90% of $3,000,000 hit = 75% of $5,000 paid
100% of $3,000,000 hit = 100% of $5,000 paid
105% of bonus hit = 105% of $5,000 paid
110% of bonus hit = 110% of $5,000 paid

Thank you!