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!

ความคิดเห็น • 10

  • @crispinerotv
    @crispinerotv 8 ปีที่แล้ว

    Thanks for your help :)

    • @599CD
      @599CD  2 ปีที่แล้ว +1

      You're welcome

  • @keithgraber7584
    @keithgraber7584 10 ปีที่แล้ว

    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!

    • @599CD
      @599CD  10 ปีที่แล้ว

      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.

  • @glennmcohen
    @glennmcohen 3 ปีที่แล้ว

    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.

    • @599CD
      @599CD  3 ปีที่แล้ว +1

      Of course. Just multiply by 1.10

  • @oberdanaguiar7911
    @oberdanaguiar7911 6 ปีที่แล้ว +1

    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?

    • @599CD
      @599CD  3 ปีที่แล้ว

      I don't understand.

  • @the5creename
    @the5creename 11 ปีที่แล้ว +1

    thanks for this. If you ever want to have a boxing match just private message me.

  • @599CD
    @599CD  11 ปีที่แล้ว +1

    No thanks. I like my nose just the way it is. :)