+ Reply to Thread
Results 1 to 4 of 4

marking up prices formula

Hybrid View

  1. #1
    Registered User
    Join Date
    02-12-2008
    Posts
    2

    marking up prices formula

    I have found some threads on how to mark up prices using a percentage in excel, but I have not found out how I can put a percentage in one cell and have all the prices update. With the formulas I found, I have to go through every cell and input the formula to have it the prices updated. Any help would be very much appreciated. The formulas I have found are "=A1+(A1*B1)" and "=COST/(1-MARKUP)". These work but I have to type this in every cell to update the price. I am including my spreedsheet that I am working on to give you an idea of what I need.
    Attached Files Attached Files

  2. #2
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    You will need an extra column in your sheet to put the base price say col J

    In another cell say K1 enter your markup %
    Then in K where you want the marked up prices it is J4+(J4*K1) and just copy this formula down the column

    Ed

  3. #3
    Registered User
    Join Date
    02-12-2008
    Posts
    2
    I have the formula working but when I try to copy it down the table it gives me errors (########). Is there a special to copy the formula?

  4. #4
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    Hi,

    It looks like your column needs to be wider.

    Easiest way to copy down is to move curser to the bottom right corner of source cell and click and hold on the little '+' while dragging down through the destination area

    Ed

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1