Forum Discussion
Help with formula to add markups based on the cost of an 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...
Hi,
You may lookup your ranges and return related results as
=LOOKUP(A1,{0,200,300},{0.4,0.3,0.2})
Of course it's better not to hardcode values but use cell ranges.