Because the IF statements are evaluated left to right, using .... <each top limit +1 , will effectively do just that will it not?

My formula is an example with 4 discounts but you can reduce it to two ranges if you wish.

If it is important to exclude quantities less than say 1000 receiving 0% discount or 1000000 receiving the top discount ??? then you could add some > conditions.