|I'm sorry, but I don't understand what it is your after.|
For example if the price in column 2 is between $5-$10 then the value is divided by .95.
This formula will do that:
But it would have to be placed in Cell C1
You could then compare A1 to C1.