Forum Discussion
Solved
Help with formula to add markups based on the cost of the item
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
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.
1 Reply
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.