Microsoft Excel Marking Up Prices - Product Markup
ฝัง
- เผยแพร่เมื่อ 23 ก.ค. 2024
- In this video tutorial, you will learn how to mark up prices in a product list stored in Excel. You will see how to use AutoFill, perform multiplication, and use the Copy & Paste Values features.
You can learn more about AutoFill in my Excel Beginner Level 2 class: 599CD.com/XHHWU1
You can learn more about pasting values in my Excel Expert Level 8 course: 599CD.com/XGFJI8
Be sure to SUBSCRIBE, and if you have any questions or comments, post them below! Thanks!
Thanks for your help :)
You're welcome
Can you tell me how to do multiple price % markups?.. i.e. products under $10.00 = 35% markup, products between $10-20 = 25% markup and so on.. needs to be done with large range of products 35k without changing anything else in the spreadsheet. Thanks!
Sounds like a job for VLOOKUP, or MATCH & INDEX. At the least you could use a nested IF function. Look up my other tutorials on those topics.
Is there a way to change the original column numbers say 10% more. we want to mark up and send to customer by a percentage.
Of course. Just multiply by 1.10
Does not work on mine
There is no way you can make the numbers change to the markup value auto I guess within the original column?
I don't understand.
thanks for this. If you ever want to have a boxing match just private message me.
No thanks. I like my nose just the way it is. :)