SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-326180%22%20slang%3D%22en-US%22%3EHelp%20with%20formula%20to%20add%20markups%20based%20on%20the%20cost%20of%20the%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326180%22%20slang%3D%22en-US%22%3EHi%20Everyone%2C%20please%20help%20I%20need%20to%20workout%20margins%20to%20add%20to%20cost%20prices.%20I%20have%20a%20product%20list%20(7000%20products)%20and%20I%20want%20to%20add%20margins%2Fmarkups%20according%20to%20the%20cost%20value%20of%20the%20items.%20Eg.%20Anything%20less%20than%20200%20I%20want%20to%20add%2040%25%20to%20that%20value%2C%20Anything%20over%20200%20but%20less%20than%20300%20I%20want%20to%20add%2030%25%20and%20so%20forth.%20Your%20help%20will%20be%20much%20appreciated%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-326180%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326190%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formula%20to%20add%20markups%20based%20on%20the%20cost%20of%20the%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326190%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F272704%22%20target%3D%22_blank%22%3E%40Oscarkhathi%3C%2FA%3E!%20Nothing%20easier%20than%20this%20%3A)%20Do%20it%20with%20a%20vlookup%20function%2C%20dont%20mess%20around%20with%20nested%20if%20functions.%20Have%20a%20good%20sunday%2C%20see%20my%20screenshot%20and%20give%20a%20LIKE%20if%20it%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreets%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Oscarkhathi
New Contributor
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
1 Reply
Highlighted
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.

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