Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: CONVERTING NET PRICES ON A PRICE SHEET TO LIST PRICES

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    CHUCK MEADOR
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I HAVE A PRICE SHEET WITH 1500 NET PRICES IN COLUMN "C". I WANT TO USE A 2X MULTIPLIER TO MAKE A LIST PRICE SHEET WITHOUT HAVING TO USE:"=PRODUCT(NET PRICE)*2" REPEATEDLY FOR EACH PRICE CHANGE. WHAT FORMULA CAN I USE TO DOUBLE ALL THE NET PRICES IN COLUMN 'C" WITH ONE ENTRY?
    THANKS,
    CHUCK

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,033
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    Enter 2 in an empty cell, copy this cell, select all of the net prices, activate Edit|Paste Special >Multiply.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •