Help with formula to add markups based on the cost of the item

[Oscarkhathi]

Hi Everyone, please help I need to workout margins to add to cost prices. I have a product list (7000 products) and I want to add margins/markups according to the cost value of the items. Eg. Anything less than 200 I want to add 40% to that value, Anything over 200 but less than 300 I want to add 30% and so forth. Your help will be much appreciated

[#2 · Accepted solution]

Hi @Oscarkhathi! Nothing easier than this :) Do it with a vlookup function, dont mess around with nested if functions. Have a good sunday, see my screenshot and give a LIKE if it works.

Greets, Eva.