Value changes depending on amount of units sold?

Hi there, this is probably easy enough but I am not so good at excel functions.

I am trying to do a formula that will change depending on the amount of units sold. Right now it is finding the recurring revenues and total revenues for a specific product. When the amount of units sold for that product is 0-100 it is more expensive than 101-200 and so on. Is there a good way to write a formula like this? I have attached a test workbook showing what I am trying to achieve.

Any help is greatly appreciated. Have a great day!

That worked perfectly. Thank you canapone!