I need cell E3 to show the bonus amount my staff earn based on the following:

If cell H27 is equal to or greater than B4 then they qualify for a bonus payment based on the below calculation.

If H27 is 100-149% of B4 then they earn 7.5% of H27
If H27 is 150-199% of B4 then they earn 12.50% of H27
If H27 is 200-249% of B4 then they earn 17.50% of H27
If H27 is 250%+ of B4 then they earn 22.50% of H27

I hope this helps.

Many thanks for your help in advance

Jon