+ Reply to Thread
Results 1 to 2 of 2

Pricing based on sheet lower the price higher the margin

  1. #1
    Registered User
    Join Date
    02-07-2019
    Location
    Whitestown Indiana
    MS-Off Ver
    Office Excel 16
    Posts
    1

    Pricing based on sheet lower the price higher the margin

    Good Afternoon,

    This is a new one and I'm lost! I'm trying to figure a formula or look up I believe. We are trying to create a sheet which would allow us to enter any price from $0.01 to $10,000.00 the return I'm looking for is based on a moving margin.

    Example something that cost $.01 would return a sell price of $1.01 (99% mark up) however, something that cost $160.00 would sell for $266.67 (40% margin) The powers to be keep referring to a sliding scale price low higher mark up price high lower mark up. I'm lost and going nuts. Thank you for any incite.
    Last edited by DSemo; 02-07-2019 at 01:36 PM.

  2. #2
    Registered User
    Join Date
    05-10-2016
    Location
    Cordoba, Argentina
    MS-Off Ver
    2016
    Posts
    27

    Re: Pricing based on sheet lower the price higher the margin

    Hi DSemo,
    You need some formula that would diminish the value of the % as the price rises
    One such formula is a logarithmic formula for B2 where A1 has the price
    Please Login or Register  to view this content.
    Changing -0.092 and 0.87 will give you different variations in %

    MR3.jpg

    I hope this helps
    Cheers
    Sergio

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 10-16-2017, 07:25 PM
  2. Replies: 2
    Last Post: 02-19-2015, 02:00 PM
  3. Replies: 2
    Last Post: 04-18-2014, 04:12 PM
  4. Bell Curve for Profit Margin
    By brentlindeman in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-13-2014, 05:49 AM
  5. Replies: 2
    Last Post: 05-31-2010, 03:23 PM
  6. Doing a "best fit" bell-curve analysis
    By pelagrin in forum Excel General
    Replies: 1
    Last Post: 05-26-2010, 12:08 AM
  7. Deleting duplicates i.e. "Anne Bell"
    By Ctech in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-04-2005, 12:25 PM

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