 • 460K Members
• 11.9K Online
• 557K Conversations

# 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 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
3 Replies

# Re: Help with formula to add markups based on the cost of an item

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.

# Re: Help with formula to add markups based on the cost of an item

Hi

I understand that you need to calculate the price or the cost after a specific percentage raise depending on a policy.

You can setup a table with the percentages and use something like VLookup function with the calculation formula to get the new price.

The VLookup formula may be like the following formula:

=VLOOKUP(A2,\$I\$6:\$J\$9,2)

You can find more about the VLookup function in the following link:

:

# Re: Help with formula to add markups based on the cost of an item

Hi

I understand that you need to calculate the price or the cost after a specific percentage raise depending on a policy.

You can setup a table with the percentages and use something like VLookup function with the calculation formula to get the new price.

The VLookup formula may be like the following formula:

=VLOOKUP(A2,\$I\$6:\$J\$9,2)

You can find more about the VLookup function in the following link:

:

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies