nested IF calculation

For multi tiered calculations like this a table with incremental rates allows for standard SUMPRODUCT based approach.

Your Range values should become the "low" point (rather than the high) and it would make sense to store the marginal multiplier for sake of simplicity.

Given modifications required to your original file I have posted a further sample with proposed solution in place.