We supply all smartphone and tablet parts. We have a pricelist of all these products around 8000 to 10000 grouped according to brand Asus,Acer,Apple,Htc,Samsung and so on. Basically they is a price column that we need to add markup on those prices in this way
For products that cost
$1-10 we want to add markup of $5
$11-20 we want to add markup of $10
$21-50 we want to add markup of $20
We don't want the formular to appear as this pricelist will be given to clients. So we just want it to have value we don't want the client to see how much markup we added on each product. I'm sure they is a formula then we having to edit it one by one.