Applying a Tiered tariff to calculation

The below would, I believe, replicate your results:

Formula:

I2:

=IF(H2<=0,0,H2*INDEX($P:$P,AGGREGATE(14,6,ROW($P$7:$P$27)/($L$7:$L$27=$B2)/($M$7:$M$27=$C2)/($N$7:$N$27<=$G2),1)))

copied down