Thank you Glenn but there is one issue I have with it still.
In your example the result for my exercise should be 160 as I surpassed 101 so I should take the price in column "D"
So range 1-101 = 180, range 102-1001 = 160 etc.

Am I being clear?