Closed Thread
Results 1 to 3 of 3

percentage markup on various price ranges

  1. #1
    Registered User
    Join Date
    02-09-2016
    Location
    Oceanside, CA
    MS-Off Ver
    2007
    Posts
    2

    percentage markup on various price ranges

    I am trying to set up a pricing worksheet so that if a price of an item is entered into a specific cell, excel will look for a price range and enter that markup into another specific cell.

    For example: item sells for between 5.01 and 7.00 (two different cells, one 5.01 next to it another cell with 7 then next to it markup cell of 110%;
    item sells for between 251.00 and 500.00 (two different cells, one 251 next to it another cell with 500 then next to it markup cell of 55%;

    So if I have 6.95 entered in my target cell, excel searches and enters 100% in my markup cell
    If I have 345 entered in the same target cell, excel enters 55% in the same mark up cell.

    so as the prices change the markups also change....Thanks

  2. #2
    Registered User
    Join Date
    11-14-2014
    Location
    Estonia
    MS-Off Ver
    2013 Office for Mac
    Posts
    31

    Re: percentage markup on various price ranges

    depending on the amount of ranges you have, you could write a a super-long IF formula, e.g. IF(start of range=>target cell<=end of range,markup,if(start of range=>target cell<=end of range,markup,if(...............

    So ever ytime for the false value you start a new IF formula.


    OR you make a mapping table, with all the possible ranges in one column and markups in the other column, and then perform a vlookup.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,746

    Re: percentage markup on various price ranges

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. percentage markup on various price ranges
    By Larry H in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2016, 04:19 PM
  2. Creating and IF statement using price and percentage ranges
    By jfish07 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2014, 06:34 PM
  3. [SOLVED] Price markup to make a certain profit (not percentage)
    By cfcMalky in forum Excel General
    Replies: 5
    Last Post: 09-30-2014, 06:01 PM
  4. Simple Price Markup Percentage Formula
    By Assurance in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2014, 02:14 PM
  5. [SOLVED] How do you use a scaling price markup within a single cell?
    By Nutts32 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-17-2012, 11:55 PM
  6. Margin/price markup as %
    By andycannon in forum Excel General
    Replies: 5
    Last Post: 06-17-2010, 06:30 AM
  7. Calculating Markup For Retail Price
    By gaspower in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2007, 07:16 PM

Tags for this Thread

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